MySQL commands


# login
mysql -u root -p



# create database
create database some-name-here;

# create user
grant all privilages on *.* to 'username'@'localhost' identified by 'password';

# create table with primary key
create table table-name-here(id int, constraint pk_name primary key(id) );

# create table with foreign key
create table different-table-name-here(id int, constraint fk_name foreign key(id) references table-name-here(id));

# insert values into table
insert into table-name-here(id) values(1);

# update values in table
update table-name-here set id = 2 where id = 1;

# delete rows in table
delete from table-name-here where id = 2;