Category: MySQL

MySQL: Duplicate record

Today I had to duplicate a record in a MySQL database. Of course the primary key  (which is AUTO_INCREMENT in my case) has to be unique. This is what I came up with:

Tagged with: ,

Import SQL data to MySQL database via console

Today I had to import a large amount of SQL data into an existing database. In detail I needed to import the latest ip2nation data into my wordpress database. Because the file has a lot of records managing the import

Tagged with: , , ,