3 Answered Questions

11 Answered Questions

[SOLVED] MySQL - Rows to Columns

9 Answered Questions

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

11 Answered Questions

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

6 Answered Questions

[SOLVED] SQL query return data from multiple tables

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

32 Answered Questions

10 Answered Questions

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

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

10 Answered Questions

[SOLVED] Rank function in MySQL

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

22 Answered Questions

[SOLVED] Remove duplicate rows in MySQL

  • 2010-07-22 18:03:56
  • Chetan
  • 334746 View
  • 333 Score
  • 22 Answer
  • Tags:   mysql sql duplicates

18 Answered Questions

[SOLVED] Join vs. sub-query

  • 2010-04-05 06:22:22
  • Your Common Sense
  • 376502 View
  • 728 Score
  • 18 Answer
  • Tags:   sql mysql subquery join

8 Answered Questions

[SOLVED] CHECK constraint in MySQL is not working

10 Answered Questions

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

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
  • 18109 View
  • 40 Score
  • 6 Answer
  • Tags:   php mysql

24 Answered Questions

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

  • 2010-12-01 21:35:14
  • Francisc
  • 415619 View
  • 424 Score
  • 24 Answer
  • Tags:   mysql sql

13 Answered Questions

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
  • 81760 View
  • 10 Score
  • 5 Answer
  • Tags:   php mysql mysqli

0 Answered Questions

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

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

25 Answered Questions

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

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

25 Answered Questions

[SOLVED] MyISAM versus InnoDB

6 Answered Questions

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

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

2 Answered Questions

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

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

36 Answered Questions

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

5 Answered Questions

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

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

9 Answered Questions

[SOLVED] MySQL Great Circle Distance (Haversine formula)

28 Answered Questions

[SOLVED] generate days from date range

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
  • 25187 View
  • 54 Score
  • 2 Answer
  • Tags:   php mysql sql

2 Answered Questions

[SOLVED] Delete all Duplicate Rows except for One in MySQL?

  • 2011-01-13 20:58:38
  • Highway of Life
  • 423084 View
  • 394 Score
  • 2 Answer
  • Tags:   mysql sql duplicates