· 8 years ago · Apr 19, 2018, 10:46 AM
1id, questions, keywords, answer
2
31,here1,here2,here3
4
5Error
6Static analysis:
7
85 errors were found during analysis.
9
10A symbol name was expected! A reserved keyword can not be used as a column name without backquotes. (near "int" at position 46)
11At least one column definition was expected. (near "int" at position 46)
12Unexpected beginning of statement. (near "1" at position 50)
13Unexpected beginning of statement. (near "`question`" at position 54)
14Unrecognized statement type. (near "varchar" at position 65)
15SQL query:
16
17CREATE TABLE IF NOT EXISTS `Sample`.`TABLE 3` ( int(1), `question` varchar(5), `keywords` varchar(5), `answer` varchar(5)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
18
19MySQL said: Documentation
20
21#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 'int(1), `question` varchar(5), `keywords` varchar(5), `answer` varchar(5)) DEFAU' at line 1
22
23id, questions, keywords, answer
24
25"1","here1","here2","here3"