csv file which is created in Libre Office.LibreOffice Editor is an extension that allows to create, edit and view any Microsoft Word document, Excel spreadsheet and Powerpoint slide. Nevertheless, this error does not occur at all in the case of the. csv file is id which is a reserved word for the database. If I understand it right, this error occurs because the name of the first column in the. #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 (near "varchar" at position 65)ĬREATE 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 (near "int" at position 46)Īt least one column definition was expected. ![]() But when I try to import the former file to it then I get the following error: ErrorĪ symbol name was expected! A reserved keyword can not be used as a column name without backquotes. The latter file is properly imported to the database. ![]() ![]() However, when I try to import them to the MySQL database at PhpMyAdmin then some something surprising is happening. csv files are looking absolutely the same at TextEdit: id, questions csv file with Excel which looks like this:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |