SQL question (1 Viewer)

[AcidKiss]

When you're doing a query what do you put in " " thingos?
Is it only the name of the specific thing you're searching for?

 

[ambartur_lui]

Whatever is inside the inverted commas "___" is whatever you're searching for. It is your search criteria.

 

[PiP]

e.g.

SELECT * FROM table WHERE FieldName = "blah"

something like that anyway heh

 

[criminal]

the double quote (") is non-standard and should not be used.

you should be using single quotes in your SQL query. eg:

INSERT INTO phonebook (id, name, number) VALUES (1, 'fred', 12345678);

 

[hurrotisrobbo]

Hmm... My teacher reckons double quotes, but... umm...

Are there any teachers that know the _IPT_ version?

 

[Alex]

If there is one question I can guarantee to get wrong in the HSC, it's SQL. I had probably the funniest guess at the SQL statement in my trial. If you saw it you would probably all laugh at me