Staredit Network

Staredit Network -> Computers and Technical -> mysql syntax error
Report, edit, etc...Posted by -bilal92- on 2006-09-01 at 18:23:30
what the f*** is this s*** ???

SELECT;
# Use "my_database" database
USE my_database;

# create a table called "user_log" with 3 columns
CREATE TABLE IF NOT EXISTS user_log
(
id INT,
date TIMESTAMP,
first_name VARCHAR(20),
last_name VARCHAR(20)
) ;

# confirm the "user_log" table format
EXPLAIN user_log;

# delete this sample table
DROP TABLE user_log;


There isnt anything wrong in this is there? Im using microsoft access. and it says theres a syntax error.

QUOTE
The SELECT statement includes a reserved word or an argument name that is mispelled or missing, or that punctuation is incorrect.


this is exaclty what it says...wow didnt know mysql has to be so perfect
Report, edit, etc...Posted by Vibrator on 2006-09-01 at 18:25:01
Err what exactly are you doing?
Report, edit, etc...Posted by -bilal92- on 2006-09-01 at 18:26:12
i have no clue, just typing the stuff in the book, im just seeing whats wrong, lol. But no theres no reason for me doing this. I went into book and found random stuff and typed it in, but im just wondering why its screwed up.
Next Page (1)