Anything wrong with this sql code?

[KingEvan]

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

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

[KingEvan]

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

[Chippiewill]

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

[KingEvan]

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

[Chippiewill]

You just want the CREATE TABLE bit then.

[KingEvan]

You just want the CREATE TABLE bit then.

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

[Chippiewill]

Well those are just comments.

[KingEvan]

Well those are just comments.

oh yeah LOL. so what do i remove.

[Futz]

you still need to add the gooey interface

[KingEvan]

....

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

[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?

[Drew]

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.

[:Markster:]

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?

[Zak]

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.