Guest User

Untitled

a guest
Jan 16th, 2019
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. desc Employee;
  2. +-----------+--------------+------+-----+---------+----------------+
  3. | Field | Type | Null | Key | Default | Extra |
  4. +-----------+--------------+------+-----+---------+----------------+
  5. | emp_id | int(11) | NO | PRI | NULL | auto_increment |
  6. | emp_name | varchar(255) | YES | | NULL | |
  7. | salary | double | YES | | NULL | |
  8. | dept_name | varchar(255) | YES | | NULL | |
  9. +-----------+--------------+------+-----+---------+----------------+
  10.  
  11. insert into Employee(emp_name,salary,dept_name)values('sai',20,000,'development');
  12.  
  13. ERROR 1136 (21S01): Column count doesn't match value count at row 1
  14.  
  15. insert into Employee(emp_name,salary,dept_name)values('sai',20000,'development');
  16.  
  17. insert into Employee(emp_name,salary,dept_name)values('sai',20,000,'development');
Add Comment
Please, Sign In to add comment