MySQL Archives - Page 36 of 38

How do I copy or clone or duplicate the data, structure, and indices of a MySQL table to a new one? This is ...

My table is: id home datetime player resource 1 10 04/03/2009 john 399 2 11 04/03/2009 juliet 244 5 12 04/03/2009 borat 555 ...

I have a table with a varchar column, and I would like to find all the records that have duplicate values in this ...

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

I’ve got a messages table in MySQL which records messages between users. Apart from the typical ids and message types (all integer types) ...

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

While executing an INSERT statement with many rows, I want to skip duplicate entries that would otherwise cause failure. After some research, my ...

I have 2-3 different column names that I want to look up in the entire database and list out all tables which have ...

I have a table: table votes ( id, user, email, address, primary key(id), ); Now I want to make the columns user, email, ...

How do you set a default value for a MySQL Datetime column? In SQL Server it’s getdate(). What is the equivalant for MySQL? ...