1.連接數(shù)據(jù)庫
mysql -u username -p
then enter password
2.使用數(shù)據(jù)庫
use database_name
3.查看所有表
show tables
4.新建表
create table table_name(
id int not null auto_increment,
value varchar(100) not null ,
primary_key (id,value)
);
4.查看表內(nèi)容
select * from table_name
5.刪除表字段
alter table table_name drop column column_name
6.刪除一條數(shù)據(jù)
delete from table_name where value = "xx"
