Top "Mysql" questions

Import SQL file into mysql

I have a database called nitm. I haven't created any tables there. But I have a SQL file which contains …

mysql sql database windows import

MySQL Insert Where query

What's wrong with this query: INSERT INTO Users( weight, desiredWeight ) VALUES ( 160, 145 ) WHERE id = 1; It works without the WHERE clause. I've …

sql mysql

Can't connect to MySQL server on 'localhost' (10061)

I recently installed MySQL 5 on Windows 2003 and tried configuring an instance. Everything worked fine until I got to "Applying Security …

mysql localhost mysql5 windows-firewall

MySQL > Table doesn't exist. But it does (or it should)

I changed the datadir of a MySQL installation and all the bases moved correctly except for one. I can connect …

mysql exists database-table

How do I show the schema of a table in a MySQL database?

From the MySQL console, what command displays the schema of any given table?

mysql database schema database-schema

Copy/duplicate database without using mysqldump

Without local access to the server, is there any way to duplicate/clone a MySQL db (with content and without …

mysql

MySQL Error 1215: Cannot add foreign key constraint

I am trying to forward engineer my new schema onto my db server, but I can't figure out why I …

mysql foreign-keys

Setting the MySQL root user password on OS X

I just installed MySQL on Mac OS X. The next step was setting the root user password, so I did …

mysql macos passwords

Get table column names in MySQL?

Is there a way to grab the columns name of a table in mysql? using php

php sql mysql

How to copy a row and insert in same table with a autoincrement field in MySQL?

In MySQL I am trying to copy a row with an autoincrement column ID=1 and insert the data into same …

mysql sql insert copy