Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE posts (
- id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
- title VARCHAR(50),
- body TEXT,
- created DATETIME DEFAULT NULL,
- modified DATETIME DEFAULT NULL
- );
- INSERT INTO posts (title,body,created)
- VALUES (’The title’, ’This is the post body.’, NOW());
- INSERT INTO posts (title,body,created)
- VALUES (’A title once again’, ’And the post body follows.’, NOW());
- INSERT INTO posts (title,body,created)
- VALUES (’Title strikes back’, ’This is really exciting! Not.’, NOW());
- #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'title’, ’This is the post body.’, NOW())' at line 2
- INSERT INTO posts
- (
- title,body,created
- )
- VALUES
- (
- 'The title', 'This is the post body.', NOW()
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement