Advertisement
apl-mhd

createTable

Jun 23rd, 2018
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.27 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS student(
  2.    
  3.     student_id INT NOT NULL UNIQUE,
  4.     student_name  VARCHAR(30) NOT NULL,
  5.     age INT NOT NULL
  6.    
  7.     );
  8.  
  9.  
  10. update
  11.  
  12. UPDATE student SET student_id= 161042 ,student_name = "Ahsanullah", age =22 WHERE student_id = 11
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement