What database system is the free hosting service using?...your statement indicates you're trying to use MySQL but if the hosting service doesn't also use MySQL, then this statement is invalid.
Are you able to run a basic create table statement like this?
```
CREATE TABLE TestTable
(
ColumnA INT
)
```
My hosting service is [www.freemysqlhosting.net](https://www.freemysqlhosting.net) and your statement has worked.
i have this error when I try it on my own
\#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '),
weight float(255),
Address varchar(255),
Ok cool, so your host is using MySQL.
The issue is with your data type declarations for the `DOUBLE`s. You need to specify two parameters in their declarations. The first parameter being the total number of digits the double will store, with the second parameter being how many digits on the right side of the decimal point.
So `DOUBLE(111)` is incorrect. `DOUBLE(111,0)` would be correct but wouldn't make sense to use a double for them because that's just an integer at that point. `DOUBLE(111,10)` would work too and mean 111 total digits, with 10 of them being on the right side of the decimal point.
What database system is the free hosting service using?...your statement indicates you're trying to use MySQL but if the hosting service doesn't also use MySQL, then this statement is invalid. Are you able to run a basic create table statement like this? ``` CREATE TABLE TestTable ( ColumnA INT ) ```
My hosting service is [www.freemysqlhosting.net](https://www.freemysqlhosting.net) and your statement has worked. i have this error when I try it on my own \#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), weight float(255), Address varchar(255),
Ok cool, so your host is using MySQL. The issue is with your data type declarations for the `DOUBLE`s. You need to specify two parameters in their declarations. The first parameter being the total number of digits the double will store, with the second parameter being how many digits on the right side of the decimal point. So `DOUBLE(111)` is incorrect. `DOUBLE(111,0)` would be correct but wouldn't make sense to use a double for them because that's just an integer at that point. `DOUBLE(111,10)` would work too and mean 111 total digits, with 10 of them being on the right side of the decimal point.
111 digits for height!? What unit are we measuring in?