Advertisement
vinaypaleja

Table Items (SQL)

Mar 17th, 2021 (edited)
568
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.33 KB | None | 0 0
  1. create table ITEMS (Item_No int, Cost int);
  2. insert into ITEMS values (101, 5000);
  3. insert into ITEMS values (102, NULL);
  4. insert into ITEMS values (103, 4000);
  5. insert into ITEMS values (104, 6000);
  6. insert into ITEMS values (105, NULL);
  7. insert into ITEMS values (106, -1000);
  8. SELECT * from ITEMS;
  9.  
  10. select * from ITEMS where Cost<0;
  11.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement