Anything wrong with this sql code?

I dont see anything wrong, but its not working :/

http://i.imgur.com/RBhYlTU.png

You know it would mean a whole lot if someone helped me. thanks.

The main issue is it seems you're trying to run 4 different queries at the same time.

Quote:

---

Originally Posted by Chippiewill

The main issue is it seems you're trying to run 4 different queries at the same time.

---

Hmm... Well im new to sql (so i have no idea what im doing) and in this im trying to make a table with it

You just want the CREATE TABLE bit then.

Quote:

---

Originally Posted by Chippiewill

You just want the CREATE TABLE bit then.

---

ok so what do i remove then? the create temp,temp variable, and create view?

Well those are just comments.

Quote:

---

Originally Posted by Chippiewill

Well those are just comments.

---

oh yeah LOL. so what do i remove.

you still need to add the gooey interface

....

Edited by Calum0812 (Forum Moderator): Please do not post pointlessly, thanks!

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?

Quote:

---

Originally Posted by KingEvan

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

---

You can use a GUI client. The only one I've tried is MySQL Workbench.

What Scott is asking is that to run MySQL queries you've got to have a blank database set up. If you don't have one then having the queries in a text file will obviously do nothing. So question is: Do you have a database set up in which you'd run the queries?

Quote:

---

Originally Posted by KingEvan

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

---

No run the first one, then the second, then the third and so on.

It's logic, you need to create the table and have values inserted before you expect a result from the SELECT statement.