- mysql -u [username] -p; Login a sql server.
- show databases; List all databases on the sql server.
- create database [databasename]; Create a database on the sql server.
- drop database [databasename]; Delete a database on the sql server.
- grant all on [databasename.*] to [username@localhost] identified by ['password']; Give user privilages for a database.
- use [databasename]; Switch to a database.
- show tables; List all tables in the database.
- create table [tablename] (id int, name varchar(50)); Create a table.
- desc [tablename]; Show information about columns in a table.
- delete table [tablename]; Delete a table.
- insert into [tablename] (id, name) values (1, 'hoge'); Insert a row in an existing table.
- select * from [tablename]; Show all data in a table.
- update [tablename] set id = 1 where name = 'hoge'; Update info already in a table.
- delete from [tablename] where id = 3; delete a row from a table.