SQL Developer to MySQL By default, SQL developer can be used to connect only Oracle databases. As you can see, there's only Oracle tab in… Read More »How SQL Developer Connect MySQL
Fetch Row with Max Value On an online shopping website, we'd like to show visitors the most recent items added to the table items, which… Read More »How MySQL Select Max Value
Just like we said in the previous post: How to Backup MySQL Database, mysqldump exports a set of executable SQL statements that can recreate the… Read More »How MySQL Execute SQL File
Backup MySQL Database MySQL provides mysqldump utility to let us dump SQL statements that can recreate the whole database. We can output the SQL statements… Read More »How mysqldump gzip Compress Backup
You may have known that unique index on a string-typed column has limitation on prefix length, which can't guarantee the uniqueness if the length of… Read More »How to Make a Long Text Column Unique
Remote to Local For migrating a remote database, you can dump and pipe the whole database from remote server to local server via ssh tunnel… Read More »How mysqldump Remote to Local
Before MySQL 5.7 For the first time to reset root password before MySQL 5.7, you set the new password by mysqladmin: On Windows.C:Usersed>mysqladmin -u'root' password… Read More »How to Set or Reset MySQL Root Password