MySQL Syntax "Error"

Discussion in Platforms and Indicators

Updated August 10, 2018

897 views
0 thanks given
1 followers

Search this Thread

MySQL Syntax "Error"

August 10th, 2018, 05:51 PM

#1 (permalink)

Fernand0

Argentina

Posts: 19 since Apr 2018

Thanks Given: 8

Thanks Received: 3

This syntax works

Code

@"CREATE TABLE IF NOT EXISTS `dom`.`flow` (

		`id`				INTEGER		NOT NULL	AUTO_INCREMENT,
		`current`			TIMESTAMP 	NOT NULL	DEFAULT CURRENT_TIMESTAMP,

		`triggered`		DATETIME 	NOT NULL 	DEFAULT '0000-00-00 00:00:00',
		`milliseconds`		INTEGER 		NOT NULL 	DEFAULT '0',

		`bid_price`		FLOAT		NOT NULL 	DEFAULT '0',
		`ask_price`		FLOAT 		NOT NULL 	DEFAULT '0',

		`bid_start`		INTEGER		NOT NULL 	DEFAULT '0',
		`bid_end`			INTEGER		NOT NULL 	DEFAULT '0',
		`bid_added`		INTEGER		NOT NULL 	DEFAULT '0',
		`bid_hitted`		INTEGER		NOT NULL	DEFAULT '0',
		`bid_removed`		INTEGER		NOT NULL 	DEFAULT '0',

		`ask_start`		INTEGER		NOT NULL	DEFAULT '0',
		`ask_end`		INTEGER		NOT NULL	DEFAULT '0',
		`ask_added`		INTEGER		NOT NULL 	DEFAULT '0',
		`ask_hitted`		INTEGER		NOT NULL 	DEFAULT '0',
		`ask_removed`		INTEGER		NOT NULL 	DEFAULT '0',

		PRIMARY KEY(`id`, `ask_price`, `bid_price`)

)
ENGINE = InnoDB"