Skip to content

SELECT INTO OUTFILE syntax problems #105

@ibennetch

Description

@ibennetch

According to the MySQL manual, this is valid SQL.

SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  FROM test_table;

But gives these errors:

#1: Unrecognized keyword. (near "FIELDS" at position 48)
#2: Unrecognized keyword. (near "TERMINATED" at position 55)
#3: Unrecognized keyword. (near "BY" at position 66)
#4: Unexpected token. (near "','" at position 69)
#5: Unrecognized keyword. (near "OPTIONALLY" at position 73)
#6: Unrecognized keyword. (near "ENCLOSED" at position 84)
#7: Unrecognized keyword. (near "BY" at position 93)
#8: Unexpected token. (near "'"'" at position 96)
#9: Unrecognized keyword. (near "LINES" at position 101)
#10: Unrecognized keyword. (near "TERMINATED" at position 107)
#11: Unrecognized keyword. (near "BY" at position 118)
#12: Unexpected token. (near "'\n'" at position 121)

According to composer.lock, I have sql-parser v3.4.14

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions