MySQL Decimal Syntax Error when creating table

70
October 30, 2018, at 10:00 PM

When I create a table using the decimal data types I keep getting syntax error and it keeps highlighting the decimal keyword

CREATE TABLE ADVENTURE_TRIP
(
TRIP_ID decimal(3,0) PRIMARY KEY,
TRIP_NAME varchar,
START_LOCATION char,
STATE char,
DISTANCE number,
MAX_GRP_SIZE number,
TYPE char,
SEASON char
);

Then When I try to instead use a double or float it will instead highlight the parentheses next to it arrow points to where sql highlights the error, float(3,0)

                                              ^
READ ALSO
Botkit with mysql instead of mongodb

Botkit with mysql instead of mongodb

Does anyone know how to use mysql with botkit instead of mongodb?

85
Duplicating Data in Another Table for Performance Gain

Duplicating Data in Another Table for Performance Gain

I'm currently designing the database architecture for a product that I'm in the process of buildingI'm simply drawing out everything in an Excel file before I begin creating everything in MySQL

27
python multiple socket connection to a single server from one client

python multiple socket connection to a single server from one client

i need to read rows from a mysql database and send to a second server over sockets

87
Looking for a cloud database service which is accessible in China for mobile application ( iOS and Android ) [on hold]

Looking for a cloud database service which is accessible in China for mobile application ( iOS and Android ) [on hold]

I am working on a mobile application which requires users are able to access from China and the United StatesBecause Google and many other services based in the United States are blocked by China, I can't use these services

48