Anything wrong with this sql code?

You run 4 queries

Code:

---

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

---

run that first

Code:

---

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

Code:

---

SELECT * FROM CUSTOMER;

---

to view everything or

Code:

---

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

---

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

Quote:

---

Originally Posted by scottish

You run 4 queries

Code:

---

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

---

run that first

Code:

---

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

Code:

---

SELECT * FROM CUSTOMER;

---

to view everything or

Code:

---

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?

Where are you running them?

Quote:

---

Originally Posted by scottish

Where are you running them?

---

what ?

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..

Quote:

---

Originally Posted by 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..

---

notepad lol

Quote:

---

Originally Posted by KingEvan

notepad lol

---

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

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?

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

Quote:

---

Originally Posted by 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?

---

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