Issue
whats wrong with this code?
CREATE TABLE `cars` (
`id` INT unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` varchar,
`image` varchar
) ENGINE = INNODB DEFAULT CHARSET = utf8;
Err:
#1064 - Near '
`image` varchar
) ENGINE = INNODB DEFAULT CHARSET = utf8' in Zeile 3
Can anyone help me to solve this issue ?
Solution
varchar must have a size, when you define it.
So you can choose for example 100
CREATE TABLE `cars` (
`id` INT unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` varchar(100),
`image` varchar(100)
) ENGINE = INNODB DEFAULT CHARSET = utf8;
Answered By - nbk Answer Checked By - Marie Seifert (PHPFixing Admin)
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.