这是主表:createtableusers(useridbigintnotnullauto_increment,usernamevarchar(32)notnull,passwordvarchar(64)notnull,sextinyint,adddatedatetimenotnull,primarykey(userid));这...
这是主表:create table users( userid bigint not null auto_increment, username varchar(32) not null, password varchar(64) not null, sex tinyint, adddate datetime not null, primary key (userid));这是附表:create table usersattached( userid bigint not null auto_increment, balance float(5,2) not null, status smallint not null, primary key (userid));alter table usersattached add constraint FK_Reference_1 foreign key (userid) references users (userid) ON DELETE CASCADE ON UPDATE CASCADE;按照构想,把这两个表创建成功后,要想在表usersattached中添加一条记录,比如 insert into usersattached values(1,4.66,0);则在users中必须有一条id=1的记录才能添加。但是我在两个执行了这句,为什么成功添加了呢
展开