Thread: mysql server problem:

i have mysql server. not working properly.

example;

create table employee(first varchar(20),last varchar(20),age number);

error 1064 (42000): have error in sql syntax check manual corresponds mysql server version right syntax use near 'number' @ line 1

im getting error in number data type. othr data types fine.
dont see mistake. if in friends laptop executing.

should b problem?

as know number not valid type in mysql.
there many numeric types:
timyint, smallint, mediumint, int, bigint...decimal, float, double, real... , more.
in mysql can decide type use.

Forum The Ubuntu Forum Community Ubuntu Official Flavours Support New to Ubuntu [all variants] mysql server problem:

Ubuntu