Tag: mysql

2780 How can I prevent SQL injection in PHP? 2008-09-12T23:55:00.900

2387 Should I use the datetime or timestamp data type in MySQL? 2009-01-03T16:14:37.090

2267 Why shouldn't I use mysql_* functions in PHP? 2012-10-12T13:18:39.307

1430 How to import an SQL file using the command line in MySQL? 2013-07-16T00:43:48.420

1308 What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? 2011-04-18T17:15:24.680

1252 How to get a list of MySQL user accounts 2009-07-16T03:23:53.637

1044 Which MySQL data type to use for storing boolean values 2008-11-14T10:36:18.870

1041 UTF-8 all the way through 2008-11-10T21:04:56.767

1034 How to reset AUTO_INCREMENT in MySQL? 2012-01-19T08:37:49.687

1014 Can I concatenate multiple MySQL rows into one field? 2008-11-10T02:34:26.463

1001 How do I connect to a MySQL Database in Python? 2008-12-16T21:49:09.687

975 How to output MySQL query results in CSV format? 2008-12-10T15:59:51.733

958 Reference - What does this error mean in PHP? 2012-10-07T15:11:00.930

946 SQL select only rows with max value on a column 2011-10-12T19:42:07.780

916 Installing specific package versions with pip 2011-03-07T22:58:13.697

893 mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc... expects parameter 1 to be resource 2010-06-04T10:18:08.993

860 What's the difference between utf8_general_ci and utf8_unicode_ci 2009-04-20T03:43:49.213

835 How do I quickly rename a MySQL database (change schema name)? 2008-09-15T21:22:00.090

825 MyISAM versus InnoDB 2008-08-21T14:50:52.780

791 INNER JOIN ON vs WHERE clause 2009-06-19T16:16:24.347

785 How do you set a default value for a MySQL Datetime column? 2008-10-03T20:24:30.523

780 MySQL: Large VARCHAR vs. TEXT? 2010-01-07T20:40:33.473

768 "INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE" 2009-02-14T05:24:06.610

757 How do I specify unique constraint for multiple columns in MySQL? 2009-03-11T19:12:31.843

728 Retrieving the last record in each group - MySQL 2009-08-21T17:04:04.147

716 Insert into a MySQL table or update if exists 2010-11-17T14:08:52.573

709 How to find all the tables in MySQL with specific column names in them? 2008-10-11T07:02:05.463

701 How to 'insert if not exists' in MySQL? 2009-09-01T08:56:41.863

678 How to get the sizes of the tables of a MySQL database? 2012-03-08T15:30:31.937

668 What is the best collation to use for MySQL with PHP? 2008-12-15T07:48:36.683

667 How can I SELECT rows with MAX(Column value), DISTINCT by another column in SQL? 2009-03-04T20:14:26.573

667 Join vs. sub-query 2010-04-05T06:22:22.540

658 TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes 2012-12-18T12:13:35.297

645 Finding duplicate values in MySQL 2009-03-27T04:22:12.460

613 'IF' in 'SELECT' statement - choose output value based on column values 2011-05-10T13:53:31.433

594 Find duplicate records in MySQL 2009-05-12T18:24:21.757

569 MySQL error code: 1175 during UPDATE in MySQL Workbench 2012-07-12T08:44:39.407

556 Grant **all** privileges on database 2011-02-16T12:38:23.580

549 MySQL Query GROUP BY day / month / year 2009-02-03T20:29:19.177

543 How do I see what character set a MySQL database / table / column is? 2009-06-26T15:22:20.257

542 Duplicating a MySQL table, indexes and data 2010-07-19T09:53:57.910

538 Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL? 2009-04-02T00:32:30.950

528 Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server 2009-10-13T12:40:47.370

526 When to use single quotes, double quotes, and back ticks in MySQL 2012-07-04T01:53:36.917

525 SQL injection that gets around mysql_real_escape_string() 2011-04-21T07:56:11.147

521 How to truncate a foreign key constrained table? 2011-03-27T21:57:42.843

515 How to shrink/purge ibdata1 file in MySQL 2010-08-11T07:20:29.893

512 Create new user in MySQL and give it full access to one database 2009-11-12T06:10:31.173

510 How to do a FULL OUTER JOIN in MySQL? 2011-01-25T17:34:18.777

492 When to use MongoDB or other document oriented database systems? 2009-09-25T09:16:03.720

489 How to temporarily disable a foreign key constraint in MySQL? 2013-03-19T14:03:58.643

481 MySQL Error 1093 - Can't specify target table for update in FROM clause 2008-09-05T10:03:46.590

481 MySQL string replace 2011-05-10T21:58:03.040

478 Skip certain tables with mysqldump 2009-01-08T17:30:17.323

466 MySQL: @variable vs. variable. What's the difference? 2009-06-17T23:04:00.137

449 How do I see all foreign keys to a table or column? 2008-10-14T15:18:49.127

446 How do I restore a dump file from mysqldump? 2008-09-19T21:27:00.673

446 Error installing mysql2: Failed to build gem native extension 2010-08-31T10:54:58.307

441 How to do a regular expression replace in MySQL? 2009-06-12T14:08:42.923

441 Create a temporary table in a SELECT statement without a separate CREATE TABLE 2011-05-02T16:03:02.940

428 Error renaming a column in MySQL 2010-10-23T03:35:23.100

423 How to do 3 table JOIN in UPDATE query? 2013-03-04T19:24:47.867

421 List of Stored Procedures/Functions Mysql Command Line 2009-04-09T08:43:36.897

420 Delete with Join in MySQL 2009-03-17T01:44:05.523

418 #1071 - Specified key was too long; max key length is 767 bytes 2009-11-29T03:18:17.483

417 How can I view live MySQL queries? 2009-02-20T06:54:18.763

414 Copy/duplicate database without using mysqldump 2008-08-25T08:47:27.160

413 How to show the last queries executed on MySQL? 2009-03-16T12:35:54.390

409 Convert from MySQL datetime to another format with PHP 2008-09-25T23:10:30.203

408 MySQL select 10 random rows from 600K rows fast 2010-12-01T21:35:14.593

405 MySql export schema without data 2011-05-30T11:06:54.273

400 MySQL - UPDATE query based on SELECT Query 2009-08-11T20:39:40.993

396 SQL query return data from multiple tables 2012-09-18T11:11:39.310

394 How to delete a column from a table in MySQL 2012-12-20T09:04:03.380

392 How to get size of mysql database? 2009-11-14T06:40:21.020

391 Disable ONLY_FULL_GROUP_BY 2014-05-28T20:21:28.723

390 Run MySQLDump without Locking Tables 2008-09-19T19:07:09.293

387 Is there an SQLite equivalent to MySQL's DESCRIBE [table]? 2010-07-25T18:23:02.510

387 What is the size of column of int(11) in mysql in bytes? 2011-04-12T10:58:36.167

382 MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes 2008-09-18T14:38:14.993

382 Delete all Duplicate Rows except for One in MySQL? 2011-01-13T20:58:38.427

380 What is the ideal data type to use when storing latitude / longitudes in a MySQL database? 2008-10-01T19:18:13.960

380 How to convert an entire MySQL database characterset and collation to UTF-8? 2011-05-24T19:12:51.683

369 How do I change the data type for a column in MySQL? 2009-08-31T10:44:24.233

368 Compare two MySQL databases 2008-10-22T13:41:07.557

361 MySQL with Node.js 2011-04-28T12:05:33.743

361 How to take backup of a single table in a MySQL database? 2011-07-13T17:17:44.027

353 How to see indexes for a database or table in MySQL? 2011-03-06T20:55:52.883

350 Inserting multiple rows in mysql 2011-07-31T11:06:44.993

349 How to get UTF-8 working in Java webapps? 2008-09-26T11:48:09.763

347 How do MySQL indexes work? 2010-08-25T16:12:41.437

345 Maximum length for MySQL type text 2011-07-20T18:37:45.827

345 MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) 2012-04-24T13:42:50.847

343 How do I add indices to MySQL tables? 2010-06-09T01:41:23.900

342 mysqli or PDO - what are the pros and cons? 2008-08-17T09:47:22.610

340 Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (38) 2011-03-21T10:33:36.173

334 How can I check MySQL engine type for a specific table? 2008-10-17T19:28:38.230

332 gem install: Failed to build gem native extension (can't find header files) 2010-11-29T13:58:14.690

331 Multiple Updates in MySQL 2008-08-06T14:12:09.903