COMMUNITY

It seem haxe can't not excute *.sql files?

it seem haxe can’t not excute *.sql files?

test target: hashlink ,neko,hxcpp.

throw error: cannot execute serveral sql requests at the same time

and another error :slight_smile:

id int(20) UNSIGNED NOT NULL AUTO_INCREMENT,

not support UNSIGNED?

I found the problem may be code style is difference

cnx.request("
CREATE TABLE IF NOT EXISTS User (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
age INTEGER,
money DOUBLE
)
");

this style can be execute ,

but when I change AUTOINCREMENT to AUTO_INCREMENT ,it’s error.

what kind of sql Syntax write in Haxe?

from w3c

https://www.w3schools.com/SQl/sql_autoincrement.asp

it’s AUTO_INCREMENT instead of AUTOINCREMENT

It’s not Haxe. It’s DB engine you are trying to send SQL request to.
I suppose you’re using SQLite: https://www.sqlite.org/autoinc.html

thank you .that’s what I missing.