Questions tagged [mysql]

9

votes

11

answers

Any tips on planning a large database

mysql sql

asked 2009-08-21T00:20:55.963

52

votes

5

answers

Python MYSQL update statement

python mysql mysql-python prepared-statement

asked 2009-08-20T16:30:31.337

75

votes

11

answers

JSON vs. Serialized Array in database

php mysql serialization mysql-json

asked 2009-08-20T14:53:49.040

14

votes

2

answers

Selecting all corresponding fields using MAX and GROUP BY

sql mysql group-by max greatest-n-per-group

asked 2009-08-20T09:38:41.123

21

votes

4

answers

How do I alias a database in MySQL?

mysql schema alias

asked 2009-08-19T22:49:15.047

30

votes

8

answers

Selecting a float in MySQL

php mysql floating-point database

asked 2009-08-19T19:48:51.667

16

votes

2

answers

How to insert / retrieve a file stored as a BLOB in a MySQL db using python

python mysql file-io blob

asked 2009-08-18T14:50:58.373

11

votes

3

answers

MySQL, Get users rank

sql mysql rank

asked 2009-08-18T13:26:14.000

76

votes

9

answers

How to deal with enormous line lengths created by mysqldump

mysql

asked 2009-08-18T12:30:27.463

45

votes

3

answers

Are unique indexes better for column search performance? (PGSQL & MySQL)

postgresql mysql hash indexing

asked 2009-08-18T12:22:51.177

102

votes

12

answers

Easiest way to activate PHP and MySQL on Mac OS 10.6 (Snow Leopard), 10.7 (Lion), 10.8 (Mountain Lion)?

php mysql macos osx-snow-leopard osx-lion

asked 2009-08-18T12:18:58.240

275

votes

51

answers

Simple way to calculate median with MySQL

sql mysql statistics median

asked 2009-08-18T00:13:49.707

11

votes

2

answers

SQL: "NOT IN" alternative for selecting rows based on values of different rows?

mysql performance subquery

asked 2009-08-17T04:29:39.353

191

votes

5

answers

Choosing a stand-alone full-text search server: Sphinx or SOLR?

mysql full-text-search lucene solr sphinx

asked 2009-08-16T11:25:14.433

210

votes

3

answers

MySQL high CPU usage

mysql cpu-usage

asked 2009-08-15T16:17:04.167

14

votes

2

answers

Does IGNORE clause work with bulk insert?

php mysql bulkinsert

asked 2009-08-15T14:39:42.063

130

votes

11

answers

what is the difference between GROUP BY and ORDER BY in sql

sql mysql database

asked 2009-08-14T11:50:07.497

54

votes

14

answers

phpMyAdmin - can't connect - invalid setings - ever since I added a root password - locked out

mysql phpmyadmin root

asked 2009-08-14T07:39:12.323

11

votes

6

answers

How do you select from mysql where last character in a string = x?

mysql

asked 2009-08-13T04:42:08.137

12

votes

2

answers

Multiple counts within a single SQL query

sql mysql join count

asked 2009-08-13T01:53:09.017

246

votes

6

answers

MySQL, better to insert NULL or empty string?

mysql sql sql-null

asked 2009-08-12T18:47:23.053

704

votes

12

answers

MySQL - UPDATE query based on SELECT Query

mysql select sql-update

asked 2009-08-11T20:39:40.993

40

votes

6

answers

MySQL: Why use VARCHAR(20) instead of VARCHAR(255)?

mysql database types varchar

asked 2009-08-11T18:34:45.660

12

votes

6

answers

sql pulling a row for next or previous row of a current row

sql mysql

asked 2009-08-11T10:06:17.210

254

votes

21

answers

Mysql error 1452 - Cannot add or update a child row: a foreign key constraint fails

mysql foreign-keys mysql-error-1452

asked 2009-08-10T06:54:18.740

46

votes

4

answers

How can I select rows in MySQL starting at a given row number?

php mysql pagination limit

asked 2009-08-10T00:26:17.233

60

votes

20

answers

Illegal mix of collations error in MySql

mysql collation mysql-error-1267

asked 2009-08-06T22:21:14.103

22

votes

15

answers

PHP: Show yes/no confirmation dialog

php javascript mysql

asked 2009-08-06T11:37:15.543

18

votes

2

answers

MySQL LOAD DATA LOCAL INFILE example in python?

python mysql load-data-infile

asked 2009-08-05T08:36:26.567

75

votes

6

answers

Why does MySQL allow "group by" queries WITHOUT aggregate functions?

mysql sql standards-compliance ansi-sql

asked 2009-08-03T23:44:57.177

38

votes

4

answers

Does mysql_real_escape_string() FULLY protect against SQL injection?

php mysql sql-injection

asked 2009-08-02T23:37:46.487

166

votes

3

answers

MySQL join with where clause

mysql join where-clause

asked 2009-08-02T21:31:55.307

9

votes

5

answers

Do I need htmlentities() or htmlspecialchars() in prepared statements?

php mysql

asked 2009-08-02T16:06:47.147

203

votes

7

answers

How to show a MySQL warning that just happened?

mysql database warnings mysql-cli mysql-command-line-client

asked 2009-08-01T02:40:40.070

16

votes

3

answers

Is MySQL Connector/JDBC thread safe?

java mysql jdbc concurrency thread-safety

asked 2009-07-30T22:12:54.250

11

votes

8

answers

Oracle Gotchas for An Experienced Newb

php mysql sql-server oracle-database postgresql

asked 2009-07-30T20:10:26.760

52

votes

8

answers

Optimal number of connections in connection pool

java mysql performance weblogic connection-pooling

asked 2009-07-30T17:25:01.243

14

votes

6

answers

"193: %1 is not a valid Win32 application" bug with a new Rails Application

mysql windows ruby windows-7

asked 2009-07-30T17:17:11.727

53

votes

5

answers

MySQL DAYOFWEEK() - my week begins with monday

mysql

asked 2009-07-29T20:43:08.670

90

votes

5

answers

Does SQL Server Offer Anything Like MySQL's ON DUPLICATE KEY UPDATE

mysql sql-server t-sql

asked 2009-07-29T02:06:03.893

10

votes

2

answers

What is a query offset?

mysql kohana

asked 2009-07-29T01:12:43.677

70

votes

5

answers

How to get numeric types from MySQL using PDO?

php mysql pdo

asked 2009-07-28T22:02:31.817

46

votes

11

answers

Is there a simple way to convert MySQL data into Title Case?

mysql phpmyadmin title-case

asked 2009-07-28T02:09:37.240

13

votes

5

answers

What's faster/better to use: the MySQL or PHP md5 function?

php mysql performance function md5

asked 2009-07-26T13:05:57.647

39

votes

4

answers

MySQL errorno 121

mysql foreign-keys mysql-error-1005

asked 2009-07-24T23:30:52.913

9

votes

2

answers

MySQL Join Condition

sql mysql join

asked 2009-07-23T21:23:40.157

55

votes

11

answers

how to check if a string looks randomized, or human generated and pronouncable?

mysql algorithm nlp spam phonetics

asked 2009-07-22T09:48:14.940

9

votes

4

answers

How can I use MAX and LIMIT together in MySQL

mysql limit max

asked 2009-07-19T19:49:47.167

36

votes

7

answers

MySQL Query to calculate the Previous Month

mysql

asked 2009-07-16T14:52:56.630

158

votes

9

answers

Inserting a Python datetime.datetime object into MySQL

python mysql datetime

asked 2009-07-16T09:29:48.843

Questions tagged mysql