17 Answered Questions

10 Answered Questions

[SOLVED] MySQL - Rows to Columns

3 Answered Questions

10 Answered Questions

[SOLVED] Can I concatenate multiple MySQL rows into one field?

9 Answered Questions

[SOLVED] How to 'insert if not exists' in MySQL?

6 Answered Questions

[SOLVED] SQL query return data from multiple tables

  • 2012-09-18 11:11:39
  • Fluffeh
  • 737758 View
  • 409 Score
  • 6 Answer
  • Tags:   mysql sql select

10 Answered Questions

[SOLVED] Rank function in MySQL

  • 2010-07-26 09:35:48
  • abhis
  • 220648 View
  • 141 Score
  • 10 Answer
  • Tags:   mysql sql rank

10 Answered Questions

[SOLVED] "INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"

  • 2009-02-14 05:24:06
  • Thomas G Henry
  • 788777 View
  • 788 Score
  • 10 Answer
  • Tags:   mysql insert

32 Answered Questions

17 Answered Questions

[SOLVED] Join vs. sub-query

  • 2010-04-05 06:22:22
  • Your Common Sense
  • 365938 View
  • 704 Score
  • 17 Answer
  • Tags:   sql mysql subquery join

20 Answered Questions

[SOLVED] Remove duplicate rows in MySQL

  • 2010-07-22 18:03:56
  • Chetan
  • 329582 View
  • 322 Score
  • 20 Answer
  • Tags:   mysql sql duplicates

10 Answered Questions

[SOLVED] How to apply bindValue method in LIMIT clause?

6 Answered Questions

[SOLVED] Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result

  • 2009-04-28 00:03:46
  • user96828
  • 17897 View
  • 40 Score
  • 6 Answer
  • Tags:   php mysql

8 Answered Questions

[SOLVED] CHECK constraint in MySQL is not working

10 Answered Questions

[SOLVED] Insert into a MySQL table or update if exists

23 Answered Questions

[SOLVED] MySQL select 10 random rows from 600K rows fast

13 Answered Questions

0 Answered Questions

[SOLVED] Warning: mysql_fetch_* expects parameter 1 to be resource, boolean given error

  • 2012-07-26 17:00:06
  • John Conde
  • 1274 View
  • 5 Score
  • 0 Answer
  • Tags:   php mysql

15 Answered Questions

[SOLVED] Error related to only_full_group_by when executing a query in MySql

5 Answered Questions

[SOLVED] mysqli_query expects at least 2 parameters

  • 2011-11-09 23:41:15
  • Joe Winfield
  • 79117 View
  • 10 Score
  • 5 Answer
  • Tags:   php mysql mysqli

2 Answered Questions

[SOLVED] Return row only if value doesn't exist

  • 2014-02-07 16:37:38
  • Madr
  • 5030 View
  • 4 Score
  • 2 Answer
  • Tags:   mysql sql

25 Answered Questions

[SOLVED] MyISAM versus InnoDB

25 Answered Questions

[SOLVED] Solving a "communications link failure" with JDBC and MySQL

  • 2011-07-28 20:55:24
  • Anthony
  • 556831 View
  • 171 Score
  • 25 Answer
  • Tags:   java mysql jdbc

6 Answered Questions

[SOLVED] PDO support for multiple queries (PDO_MYSQL, PDO_MYSQLND)

  • 2011-06-14 16:15:30
  • Gajus
  • 94235 View
  • 88 Score
  • 6 Answer
  • Tags:   php mysql pdo

6 Answered Questions

[SOLVED] How can I fix MySQL error #1064?

5 Answered Questions

[SOLVED] How to do 3 table JOIN in UPDATE query?

  • 2013-03-04 19:24:47
  • Ricky
  • 424320 View
  • 434 Score
  • 5 Answer
  • Tags:   mysql join

4 Answered Questions

[SOLVED] How to properly set up a PDO connection

2 Answered Questions

[SOLVED] Can I parameterize the table name in a prepared statement?

  • 2012-07-03 14:09:51
  • GK1667
  • 24504 View
  • 53 Score
  • 2 Answer
  • Tags:   php mysql sql

9 Answered Questions

[SOLVED] MySQL Great Circle Distance (Haversine formula)

35 Answered Questions

[SOLVED] Should I use the datetime or timestamp data type in MySQL?