Sometimes we need to check the CREATE TABLE syntax for already created table in the database. When we need to check what kind of columns and what datatype a column has in a table then we require the ...

innodb-java-reader is a java implementation to access MySQL InnoDB storage engine file directly. With the library or command-line tool, it provides read-only features like examining pages, looking up ...

How to add data into MySQL tables from the command line Your email has been sent So you’re new to MySQL database administration. You’ve probably already installed ...

Make sure you have setup XAMPP stack in your system. The following guide explains how to setup XAMPP stack in Linux. Alternatively, you can use the LAMP or LEMP stacks which provides both PHP and ...

Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...

The MySQL Workbench main window. How to create tables and add data to MySQL database with MySQL Workbench Your email has been sent The MySQL Workbench GUI is cross-platform, open source, and ...

Start 2 node cluster. Execute "show create table on node-1 (we need to block it after acquiring MDL lock) Execute "alter table on node-2 (this alter will be replicated on node-1 and will conflict with ...

The “mysqldump” command is used on the command line to dump databases managed by MySQL. There are several instances where one may wish to dump a database or part of a database and here we consider ...