mysql学习笔记

https://www.runoob.com/mysql/mysql-tutorial.html

连接

mysql -u root -p123 -D database_name

-h 可指定ip 本地默认就是 localhost

create

create table 'tablename'(
    id int unsigned auto_increment primary key,
    name varchar(12) not null,
    age int
);

insert

insert into table_name (col_name1,col_name2...) values (123,123);

update

update table_name set col_name1=...,col_name2=... where ...