Changing storage engine; rebuild table; change file_per_table, ALTER COLUMN OF TABLE, Change auto-increment value, Renaming a MySQL table, ALTER table add INDEX, Changing the type of a primary key ...

CREATE DATABASE IF NOT EXISTS test; USE test; DROP TABLE IF EXISTS test; CREATE TABLE test ( id INT NOT NULL AUTO_INCREMENT, amount FLOAT(10,4) NOT NULL, PRIMARY KEY(id)) ENGINE=InnoDB; vagrant@wheezy ...

Not able to connect to the database server on MySQL Workbench? Solve this error with a simple ALTER query. I think last week I published an article on how to install ...