Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- desc Employee;
- +-----------+--------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +-----------+--------------+------+-----+---------+----------------+
- | emp_id | int(11) | NO | PRI | NULL | auto_increment |
- | emp_name | varchar(255) | YES | | NULL | |
- | salary | double | YES | | NULL | |
- | dept_name | varchar(255) | YES | | NULL | |
- +-----------+--------------+------+-----+---------+----------------+
- insert into Employee(emp_name,salary,dept_name)values('sai',20,000,'development');
- ERROR 1136 (21S01): Column count doesn't match value count at row 1
- insert into Employee(emp_name,salary,dept_name)values('sai',20000,'development');
- insert into Employee(emp_name,salary,dept_name)values('sai',20,000,'development');
Add Comment
Please, Sign In to add comment