Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. CREATE TABLE usertable_4711_1;
  2. ALTER TABLE usertable_4711_1 ADD COLUMN rowid INT NOT NULL AUTO INCREMENT;
  3.  
  4. ALTER TABLE usertable_4711_1 ADD COLUMN col1 VARCHAR(255);
  5. ...
  6. ALTER TABLE usertable_4711_1 ADD COLUMN colX VARCHAR(255);
  7.  
  8. // inserts and updates go alike
  9. INSERT INTO usertable_4711_1 (col1, col2, col3) VALUES ('data', 'data', 'data')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement