Advertisement
Guest User

Untitled

a guest
Jul 25th, 2014
208
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. INSERT INTO NAMES VALUES(...)
  2. INSERT INTO PHONES VALUES(...)
  3.  
  4. START TRANSACTION;
  5. INSERT INTO table1 VALUES ('1','2','3');
  6. INSERT INTO table2 VALUES ('bob','smith');
  7. COMMIT;
  8.  
  9. for x = 0 to 1
  10.  
  11. if x = 0 then TableToWrite = "Table1"
  12. if x = 1 then TableToWrite = "Table2"
  13. Sql = "INSERT INTO " & TableToWrite & " VALUES ('1','2','3')"
  14. NEXT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement