我想在表中插入以下信息,但它给我以下错误以下代码:
msg 109,15级,状态1,第1行 插入语句中的列比值子句中指定的值更多。值子句中的值数量必须匹配插入语句中指定的列数。
create table registration
(
id int identity primary key,
first_name varchar(100),
last_name varchar(100),
username varchar(100),
[password] varchar(100),
email varchar(100),
[address] varchar(100),
gender varchar(10),
dob date,
reg_date date,
country varchar(50),
city varchar(50),
[status] bit
)
select * from registration
insert into registration (first_name,last_name,username,password,email,[address],gender,dob,reg_date,country,city,status)
values ('Ali','Khan','alik','123','alikhan@gmail.com','Male','19930318','20170318','Pakistan','Karachi')
错误非常明显,您缺少值中的某些列。尝试以下操作:
insert into registration (first_name,last_name,username,password,email,[address],gender,dob,reg_date,country,city,status)
values ('Ali','Khan','alik','123','alikhan@gmail.com','100 Sample Street Address', 'Male','19930318','20170318','Pakistan','Karachi', cast(1 as bit))
查看您的查询:
Column Value you want to insert
----------- ------------------------
first_name 'Ali'
last_name 'Khan'
username 'alik'
password '123'
email 'alikhan@gmail.com'
[address] 'Male'
gender '19930318'
dob '20170318'
reg_date 'Pakistan'
country 'Karachi'
city
status
您缺少一些值。错误清楚地说。
值子句中指定的值和插入语句在数字中相等。那就是我的问题是