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
id
int(20) UNSIGNED NOT NULL AUTO_INCREMENT,
not support UNSIGNED?
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
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: SQLite Autoincrement
thank you .that’s what I missing.
© 2018-2020 Haxe Foundation - Powered by Discourse