Advertisement
Guest User

sql sample

a guest
Mar 8th, 2019
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.54 KB | None | 0 0
  1. BEGIN TRANSACTION;
  2.  
  3. /* Create a table called NAMES */
  4. CREATE TABLE NAMES(Id INTEGER PRIMARY KEY, USER text, password text);
  5.  
  6. /* Create few records in this table */
  7. INSERT INTO NAMES VALUES(1,'Tom', 'secret');
  8. INSERT INTO NAMES VALUES(2,'Lucy', 'secret');
  9. INSERT INTO NAMES VALUES(3,'Frank', 'secret');
  10. INSERT INTO NAMES VALUES(4,'Jane', 'secret');
  11. INSERT INTO NAMES VALUES(5,'Robert', 'secret');
  12. COMMIT;
  13.  
  14. /* Display all the records from the table */
  15. SELECT USER FROM names WHERE USER = '' OR USER LIKE 't%' OR '1'='1' AND password ='asdfdsadf'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement