Top "Mysql" questions

How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

sql mysql sql-server database oracle

Error 1046 No database Selected, how to resolve?

Error SQL query: -- -- Database: `work` -- -- -------------------------------------------------------- -- -- Table structure for table `administrators` -- CREATE TABLE …

sql mysql mysql-error-1046

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I am getting the following error when I try to connect to mysql: Can't connect to local MySQL server through …

mysql sockets connect

How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would …

mysql sql database oracle postgresql

How to run SQL script in MySQL?

I want to execute a text file containing SQL queries, in MySQL. I tried to run source /Desktop/test.sql …

mysql command-line

How do I set the time zone of MySQL?

On one server, when I run: mysql> select now(); +---------------------+ | now() | +---------------------+ | 2009-05-30 16:54:29 | +---------------------+ 1 row in set (0.00 sec) …

mysql timezone

Fatal error: Uncaught Error: Call to undefined function mysql_connect()

I am trying to do a simple connection with XAMPP and MySQL server, but whenever I try to enter data …

php mysql xampp

Find duplicate records in MySQL

I want to pull out duplicate records in a MySQL Database. This can be done with: SELECT address, count(id) …

mysql duplicates

Unknown column in 'field list' error on MySQL Update query

I keep getting MySQL error #1054, when trying to perform this update query: UPDATE MASTER_USER_PROFILE, TRAN_USER_BRANCH SET …

mysql sql mysql-error-1054

TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes

Per the MySQL docs, there are four TEXT types: TINYTEXT TEXT MEDIUMTEXT LONGTEXT What is the maximum length that I …

mysql innodb