mysql -uroot -p

prompt python>
1
\D 完整日期
\U 使用用戶

show databases;

use 數(shù)據(jù)庫名;

select database();

create database 數(shù)據(jù)庫名 charset=utf8;

create database python charset=utf8;

drop database 數(shù)據(jù)庫名;

drop database python;

show tables;

CREATE TABLE table_name(
  column1 datatype contrai,
  column2 datatype,
  column3 datatype,
  .....
  columnN datatype,
  PRIMARY KEY(one or more columns)
);

create table classes(
  id int unsigned auto_increment primary key not null,
  name varchar(10)
);

create table students(
  id int unsigned primary key auto_increment not null,
  name varchar(20) default '',
  age tinyint unsigned default 0,
  height decimal(5,2),
  gender enum('男','女','人妖','保密'),
  cls_id int unsigned default 0
)

alter table 表名 add 列名 類型;

alter table students add birthday datetime;

alter table 表名 change 原名 新名 類型及約束;

alter table students change birthday birth datetime not null;

alter table 表名 modify 列名 類型及約束;

alter table students modify birth date not null;

alter table 表名 drop 列名;

alter table students drop birthday;

drop table 表名;

drop table students;

show create table 表名;

show create table classes;

select * from 表名;

select * from classes;

select 列1,列2,... from 表名;

select id,name from classes;

insert into 表名 values(...)

insert into students values(0,'郭靖‘,1,'蒙古','2016-1-2');

insert into 表名(列1,...) values(值1,...)

insert into students(name,hometown,birthday) values('黃蓉','桃花島','2016-3-2');

insert into 表名 values(...),(...)...;

insert into classes values(0,'python1'),(0,'python2');

insert into 表名(列1,...) values(值1,...),(值1,...)...;

insert into students(name) values('楊康'),('楊過'),('小龍女');

update 表名 set 列1=值1,列2=值2... where 條件

update students set gender=0,hometown='北京' where id=5;

DELETE FROM tbname [where 條件判斷]

delete from 表名 where 條件

delete from students where id=5;

update students set isdelete=1 where id=1;

mysqldump –uroot –p 數(shù)據(jù)庫名 > python.sql;

 
# 按提示輸入mysql的密碼

mysql -uroot –p 新數(shù)據(jù)庫名 < python.sql

# 根據(jù)提示輸入mysql密碼