cmd 下操作数据库

1.connect to mysql db server:

mysql -u root -p

2. create database first:

create database demo;

3. view all databases created:

show databases;

4. change to destination database:

use demo;

5. create student table:

create table student(

id   int   PRIMARY KEY,

name varchar(32),

age int

);

6. insert 

 

 

create table user(

email varchar(32),

name varchar(32) PRIMARY KEY,

address varchar(128),

telephone int(12),

password varchar(32)

);

 

 

insert into user(email,name,address,telephone,password) values('你','你','你','1','你');

 

DROP TABLE user ; -- 删除表

CREATE TABLE user(

id INT AUTO_INCREMENT PRIMARY KEY ,

name VARCHAR(30) NOT NULL ,

password VARCHAR(32) NOT NULL ,

age INT NOT NULL ,

sex VARCHAR(2) DEFAULT '男' ,

birthday DATE 

) ;

 

INSERT INTO user(name,password,age,sex,birthday) VALUES ('李兴华','www.mldn.cn',30,'男','2008-08-27') ;

INSERT INTO user(name,password,age,sex,birthday) VALUES ('李康','www.mldnjava.cn',23,'女','2005-08-27') ;

 

 

DELETE FROM user WHERE id=3 ;

 

UPDATE user SET name='MLDN',age=5,birthday='2000-08-27' WHERE id=4 ;

 

SELECT name,birthday FROM user ;

 

SELECT * FROM user WHERE name LIKE '%m%' OR password LIKE '%m%' ;

 

SELECT * FROM user WHERE name LIKE '%m%' OR password LIKE '%m%' LIMIT 10,5 ;

 

 

 

 

 

mysql -uroot -proot

create database demo;

use demo;

CREATE TABLE user(

name VARCHAR(30) NOT NULL PRIMARY KEY ,

password VARCHAR(32) NOT NULL ,

email           VARCHAR(32) NOT NULL  ,

        address          varchar(60),

        telephone        int,

        code             int(5)

) ;

insert into user (name,password,email) values ('我','123','[e-mail]');

insert into user (name,password,email) values ('me','123','[e-mail]');

insert into user (name,password,email) values ('we','123','[e-mail]');

insert into user (name,password,email,address,telephone,code) values ('we1','123','[e-mail]','dsf','1381042437','100083');

 

 

insert into user (name,password,email,address,telephone,code) values ('we1a','123','[e-mail]','dsf','1381042437','100083');

 

 

 

CREATE TABLE good(

id              int             AUTO_INCREMENT PRIMARY KEY ,

name VARCHAR(30) NOT NULL ,

        price        float NOT NULL ,

amount          int NOT NULL ,

        detail          VARCHAR(120)

) ;

 

insert into  good(name,url,price,amount,picture,detail) values('book','computer.html','2','3','image/computer.jpg','good computer');

insert into  good(name,url,price,amount,picture,detail) values('computer','computer.html','2','3','image/computer.jpg','good computer');

insert into  good(name,url,price,amount,picture,detail) values('applebook','applebook.html','2','0','image/apple.jpg','verycomputer');

insert into  good(name,url,price,amount,picture,detail) values('1','applebook.html','2','34','image/apple.jpg','verycomputer');

insert into  good(name,url,price,amount,picture,detail) values('2','applebook.html','2','34','image/apple.jpg','verycomputer');

 

 

 

 

 

 

CREATE TABLE orderdetail(

orderid              int             AUTO_INCREMENT PRIMARY KEY ,

username             varchar(30)     not null   unique ,

        gooddetail            varchar(120)   not null,

        orderdate            date            not null,

        price                float           not null

) ;

订单信息数据库

 

 

 

update user set code=1,telephone=212,address='dsf' where name='me';

 

mysqldump -u root -proot  demo > demo.sql

copy demo.sql c:\

 

登陆 建表 

mysql -u root -proot 

create database book;

use book;

exit;

 

cmd下

 

mysql -u root -proot  book < c:\demo.sql;