Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- I made database pug
- Then i tried to import sql files
- Error:
- [code]
- #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DELIMITER' at line 1
- [/code]
- Error 2:
- [code]
- SQL query:
- CREATE TABLE IF NOT EXISTS pug_match
- (
- id INT NOT NULL AUTO_INCREMENT,
- server VARCHAR(32) NOT NULL DEFAULT '',
- ip VARCHAR(32) NOT NULL DEFAULT '',
- map VARCHAR(32) NOT NULL DEFAULT '',
- score1 SMALLINT NOT NULL DEFAULT 0,
- score2 SMALLINT NOT NULL DEFAULT 0,
- rounds SMALLINT NOT NULL DEFAULT 0,
- date DATETIME NOT NULL DEFAULT NOW(),
- seconds FLOAT NOT NULL DEFAULT 0.0,
- duration VARCHAR(32) NOT NULL DEFAULT '',
- PRIMARY KEY (id)
- );
- MySQL said: Documentation
- #1067 - Invalid default value for 'date'
- [/code]
- Smiley, can you help?
- p.s. sql files are original. i didn't change anything.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement