Questions tagged [mysql]

12

votes

5

answers

MySQL 'Update Timestamp' Column - Trigger

mysql triggers

asked 2010-01-11T23:40:20.147

16

votes

7

answers

Are prepared statements cached server-side across multiple page loads with PHP?

php mysql

asked 2010-01-11T01:25:53.593

11

votes

5

answers

How to Call Java Code from MySQL?

java mysql java-stored-procedures

asked 2010-01-09T19:28:34.163

17

votes

5

answers

Mysql: Which to use when: drop table, truncate table, delete from table

sql mysql

asked 2010-01-06T12:52:38.750

110

votes

18

answers

MySQL: #126 - Incorrect key file for table

mysql mysql-error-126

asked 2010-01-06T05:01:44.140

77

votes

2

answers

MySQL - Conditional Foreign Key Constraints

mysql sql database-design foreign-keys polymorphic-associations

asked 2010-01-04T23:12:56.487

14

votes

9

answers

How do I construct a cross database query in PHP?

php mysql

asked 2010-01-04T12:23:39.140

10

votes

5

answers

MySQL stored procedure, handling multiple cursors and query results

mysql sql stored-procedures database-cursor

asked 2010-01-03T14:55:50.800

53

votes

7

answers

Meaning of "Select tables optimized away" in MySQL Explain plan

sql mysql performance query-optimization sql-execution-plan

asked 2010-01-02T18:18:01.190

23

votes

1

answers

What's the difference between mysqlimport and mysql < dbfile.sql

mysql

asked 2009-12-31T10:40:46.183

51

votes

4

answers

How to drop this index in MySQL?

mysql indexing

asked 2009-12-31T07:28:24.090

15

votes

2

answers

unbuffered query with MySQLi?

php mysql mysqli unbuffered-queries

asked 2009-12-30T19:38:07.940

11

votes

2

answers

What are the limitations of implementing MySQL NDB Cluster?

mysql cluster-computing bigdata mysql6

asked 2009-12-30T14:34:07.900

95

votes

14

answers

Save PHP array to MySQL?

php mysql arrays

asked 2009-12-30T04:33:30.930

34

votes

3

answers

MySQL Include a script within script

sql mysql scripting

asked 2009-12-29T19:23:34.677

11

votes

3

answers

MySQL Benchmark

php mysql benchmarking mysql-error-1242

asked 2009-12-28T19:38:14.020

10

votes

4

answers

How much faster is MyISAM compared to InnoDB?

mysql

asked 2009-12-28T17:00:34.357

108

votes

10

answers

Show procedure definition in MySQL

sql mysql database stored-procedures stored-functions

asked 2009-12-28T10:06:24.463

9

votes

2

answers

Row Rank in a MySQL View

sql mysql view ranking

asked 2009-12-27T00:54:04.933

11

votes

2

answers

How do I tell DBD::mysql where mysql.sock is?

mysql perl dbi

asked 2009-12-24T11:12:55.467

11

votes

4

answers

MySQL: Removing duplicate columns on Left Join, 3 tables

sql mysql database left-join mysql-connector

asked 2009-12-24T00:15:17.753

35

votes

6

answers

How to INSERT a record or UPDATE if it already exists?

mysql insert insert-update

asked 2009-12-23T13:50:11.640

35

votes

8

answers

find all the name using mysql query which start with the letter 'a'

mysql

asked 2009-12-23T08:06:00.963

23

votes

6

answers

What is MySQL row order for "SELECT * FROM table_name;"?

mysql select sql-order-by

asked 2009-12-22T22:32:13.623

54

votes

9

answers

How many significant digits should I store in my database for a GPS coordinate?

mysql database database-design gps rdbms

asked 2009-12-22T16:29:19.887

16

votes

17

answers

Problem installing mysql gem on Snow Leopard: uninitialized constant MysqlCompat::MysqlRes

mysql ruby osx-snow-leopard rubygems

asked 2009-12-22T12:46:36.393

101

votes

1

answers

Comparison of database column types in MySQL, PostgreSQL, and SQLite? (Cross-Mapping)

mysql database sqlite postgresql types

asked 2009-12-21T20:57:56.273

28

votes

8

answers

Is there a tool to generate a full database DDL for SQL Server? What about Postgres and MySQL?

sql mysql sql-server postgresql ddl

asked 2009-12-18T18:05:31.923

26

votes

1

answers

Multiple insert/update statements inside trigger?

mysql database triggers

asked 2009-12-17T13:00:02.767

18

votes

4

answers

How to convert DateTime to a number in MySQL?

mysql datetime type-conversion

asked 2009-12-17T12:51:47.470

19

votes

2

answers

Simple Math max function in MySQL

sql mysql math stored-procedures

asked 2009-12-17T02:03:52.543

423

votes

31

answers

Truncate all tables in a MySQL database in one command?

mysql

asked 2009-12-16T06:58:40.937

27

votes

0

answers

"Warning: Cannot modify header information - headers already sent by" error

php mysql

asked 2009-12-16T03:15:18.897

43

votes

10

answers

Why do I need to use foreign key if I can use WHERE?

mysql foreign-keys

asked 2009-12-15T13:07:16.317

9

votes

3

answers

Django + MySQL on Mac OS 10.6.2 Snow Leopard

python mysql django osx-snow-leopard

asked 2009-12-14T22:43:19.473

51

votes

4

answers

Does index on Varchar make performance difference?

mysql sql performance indexing varchar

asked 2009-12-14T01:07:20.393

12

votes

2

answers

Is php deg2rad() equal to mysql radians()

php sql mysql trigonometry

asked 2009-12-13T21:24:01.420

342

votes

23

answers

ROW_NUMBER() in MySQL

mysql sql greatest-n-per-group rank row-number

asked 2009-12-12T23:58:44.780

100

votes

10

answers

Duplicate Entire MySQL Database

mysql database linux

asked 2009-12-11T13:08:13.007

85

votes

26

answers

Lost connection to MySQL server during query

python mysql

asked 2009-12-10T23:29:47.403

37

votes

5

answers

How to override the attribution of an auto incrementing primary key when inserting a value in a MySQL table?

mysql

asked 2009-12-10T22:01:37.300

16

votes

6

answers

SQL ORDER by `no` with NULLs at the end

mysql sql-order-by

asked 2009-12-10T11:08:24.590

16

votes

4

answers

why can't I find my.cnf?

mysql database linux unix aptitude

asked 2009-12-09T18:50:08.773

21

votes

6

answers

Update Field When Not Null

mysql sql null sql-update

asked 2009-12-07T14:13:20.703

11

votes

2

answers

Mysql deadlock explanation needed

sql mysql locking deadlock transactions

asked 2009-12-05T07:55:37.430

53

votes

11

answers

mysql datatype for telephone number and address

mysql types phone-number street-address

asked 2009-12-04T11:00:49.543

310

votes

8

answers

Is it possible to GROUP BY multiple columns using MySQL?

mysql sql group-by

asked 2009-12-03T17:13:40.930

49

votes

6

answers

How to order 1,2,3 instead of 1, 10, 11, 12 in MySQL when the column to sort by is a string?

mysql sql-order-by

asked 2009-12-02T14:03:00.083

32

votes

2

answers

Is it bad to use user name as primary key in database design?

mysql database-design primary-key unique-key

asked 2009-12-01T11:37:08.250

679

votes

37

answers

MySQL Error #1071 - Specified key was too long; max key length is 767 bytes

mysql byte varchar mysql-error-1071

asked 2009-11-29T03:18:17.483

Questions tagged mysql