Anything wrong with this sql code?

[scottish]

You run 4 queries

CREATE TABLE CUSTOMER (
ID..........
............
..........
PHONE VARCHAR(20),
);

run that first

INSERT INTO CUSTOMER VALUES ('EXAMPLE EXAMPLE', 'EXAMPLE', 'NC', 111111111111);

then run a few of those to input info into the db

then you can run

SELECT * FROM CUSTOMER;

to view everything or

SELECT `FULL NAME` FROM CUSTOMER WHERE `FULL NAME` = 'Some Name';

to view a specific full name (use `field` or [field])

[KingEvan]

You run 4 queries

CREATE TABLE CUSTOMER (
ID..........
............
..........
PHONE VARCHAR(20),
);

run that first

INSERT INTO CUSTOMER VALUES ('EXAMPLE EXAMPLE', 'EXAMPLE', 'NC', 111111111111);

then run a few of those to input info into the db

then you can run

SELECT * FROM CUSTOMER;

to view everything or

SELECT `FULL NAME` FROM CUSTOMER WHERE `FULL NAME` = 'Some Name';

to view a specific full name (use `field` or [field])

Umm... i dont get it..Would i just put all those codes together?

[scottish]

Where are you running them?

[KingEvan]

Where are you running them?

what ?

[scottish]

How are you running the SQL?

Where are you entering it? Are you doing it through an SQL browser? Are you doing it in PHP? what..

[KingEvan]

How are you running the SQL?

Where are you entering it? Are you doing it through an SQL browser? Are you doing it in PHP? what..

notepad lol

[Trinity]

notepad lol

And what are you doing after you type it out in notepad?

[scottish]

You're executing them somewhere, where..

If you know they're failing there's obviously something that's saying the syntax is incorrect or some other error, what's giving this error, how do you know it won't work?

[Kyle]

notepad is my fav coding program
i think it was used for coding the habbox.com website

[KingEvan]

You're executing them somewhere, where..

If you know they're failing there's obviously something that's saying the syntax is incorrect or some other error, what's giving this error, how do you know it won't work?

Well hey, i know nothing about sql. which would be a good writing program?