Top "Mysql" questions

MySQL select rows where left join is null

I have these MySQL tables: table1: id | writer 1 | Bob 2 | Marley 3 | Michael table2: user_one | user_two 1 | 2 And this query: SELECT …

mysql sql join left-join

How to do the Recursive SELECT query in MySQL?

I got a following table: col1 | col2 | col3 -----+------+------- 1 | a | 5 5 | d | 3 3 | k | 7 6 | o | 2 2 | 0 | 8 If a user searches for "1", …

mysql sql query-optimization recursive-query

MySQL pivot table query with dynamic columns

I'm using the following tables for storing product data: mysql> SELECT * FROM product; +---------------+---------------+--------+ | id | name | description | …

mysql dynamic pivot

Database corruption with MariaDB : Table doesn't exist in engine

I'm in an environement setup, running OSX with MariaDB 10.0.12-MariaDB Homebrew I've screwed up the installation so I did completely …

mysql innodb mariadb

How to store phone numbers on MySQL databases?

Possible Duplicate: mysql datatype for telephne number and address Any suggestions on best practice to store telephone numbers in a …

mysql string database-design formatting int

How to set a maximum execution time for a mysql query?

I would like to set a maximum execution time for sql queries like set_time_limit() in php. How can …

mysql sql time limit

How can I avoid getting this MySQL error Incorrect column specifier for column COLUMN NAME?

How can I avoid getting this MySQL error Incorrect column specifier for column topic_id ? MySQL Error... #1063 - Incorrect column …

mysql sql auto-increment ddl

Wampserver icon not going green fully, mysql services not starting up?

I'm running an application on localhost, it's been running successfully for at least a year now, but suddenly today wampserver …

mysql apache wampserver

The Response content must be a string or object implementing __toString(), "boolean" given after move to psql

As soon as I move my Laravel App from MySQL to pSQL. I kept getting this error. The Response content …

php mysql laravel laravel-5 psql

MySQL Select last 7 days

I read some Posts here and seems like nothing special but I can not still select the entries of the …

mysql sql where-clause date-arithmetic