Sql语句内功心法
时间：2021-07-01 10:21:17
帮助过：13人阅读
TABLE IF EXISTS dl_user;
CREATE TABLE dl_user(
id int(
12)
NOT NULL auto_increment,
email varchar(
50)
NOT NULL,
nick_name varchar(
30)
default NULL,
password varchar(
50)
NOT NULL,
user_integral int(
12)
not null default ‘0‘,
is_email_verify char(
3),
email_verify_code varchar(
50)
default NULL,
last_login_time bigint default NULL,
last_login_ip varchar(
15),
PRIMARY KEY (id),
UNIQUE KEY email(email)
)ENGINE=InnoDB
DEFAULT CHARSET
=UTF8;
insert into dl_user(email,nick_name,password,
user_integral,is_email_verify,email_verify_code,
last_login_time,last_login_ip)
values("jdbc
@126.com","jdbc","
1234",
10,"Y","ABSDFWE",
345123421345,"
192.168.
3.1");
select * from dl_user;
insert into dl_user(email,nick_name,password,user_integral,is_email_verify,email_verify_code,last_login_time,last_login_ip)
values("jdbc22
@126.com","jdbc","
1234",
10,"Y","ABSDFWE",
345123421345,"
192.168.
3.1")
Sql语句内功心法
标签：res 进一步 cascade sql语句 ast cad select incr ODB
