CREATE DATABASE bookdb;
use bookdb;
CREATE TABLE user
(
	uid int PRIMARY KEY,
	uname varchar(255) NOT NULL,
	email varchar(255)
),
	tnum int(11),
    score int,
);

INSERT INTO user VALUES (1001, '春天', 'spring@163.com', 13320105678,20);
INSERT INTO user VALUES (1002, '平平人生',  '123456@qq.com', 18688166789,300);
INSERT INTO user VALUES (1003, '四十不惑',  '123456@qq.com', 18688166789,1000);
INSERT INTO user VALUES (1004, '桃花岛主',  '654321@qq.com', 13068011234,600);
INSERT INTO user VALUES (1005, '水灵',  '654321@163.com', 15838182345,150);
INSERT INTO user VALUES (1006, '感动心灵',  'gandong@tom.com', 13541151234,500);
SELECT uname ,tnum
FROM user  
WHERE score>500;
 
SELECT uname AS'用户名称',tnum AS'用户电话'
FROM user
WHERE score <200;
SELECT uname email
 FROM user
  WHERE email LIKE'%@qq.com';