Home /Archive by Category "Mysql"

How To Install MySQL / MariaDB on CentOS 7

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at: MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL, in MariaDB Version 10), XtraDB … Continue reading

Restart, Start, Stop MySQL from the Command Line Terminal, OSX, Linux

To restart, start or stop MySQL server from the command line, type the following at the shell prompt… On Linux start/stop/restart from the command line: Some Linux flavours offer the service command too or On OS X to start/stop/restart MySQL pre 5.7  from the command line: On OS X Yosemite/El Capitan to start/stop/restart MySQL post 5.7  from the command line:

The ALTER TABLE Statement

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. SQL ALTER TABLE Syntax To add a column in a table, use the following syntax: To delete a column in a table, use the following syntax (notice that some database systems don’t allow deleting a column):