SQL syntax question?

Question

If my column name contains space, what kind of quotation can i use ?

for example, if my table is (product name, price), would this be correct ? i used double-quotes .. is it correct ?

SELECT "product name"
FROM MyTable
WHERE "product name" LIKE 'SQL book'

Please tell me what will exact syntax look like in this case ?

Thanks

Answer 1

The syntax depends on the system you're using. What you have above will work for Oracle, but in MS Access you'd use [ ] rather than the quotes.

Also note that since the column name is quoted, case will matter in some databases.

Avoid using spaces in your object names - it'll cause nothing but pains.

Answer 2

Yes, you can use double quotes, but also square brackets. You may be better off with them to distinguish table or field names with literals.

select [product name] from mytable where [product name] like 'sql book'

Oh: this is for SQL Server. Square brackets also for MS Access. Can't vouch for other sql dialects (oracle...).

Answer 3

if your connection string code is in the same code as the insert code, I'd segment out each statement a bit. what you are showing is PHP code with SQL statements assuming the code it breaking on line 1

Answer 4

till date i havent come across a database that accpets spaces between the column names.. during table creation phase.

u cant do something like :

CREATE TABLE mytable
(product name varchar(20 ) );

it will give u an error.

this is valid for DB's i have worked with Oracle,MsSQL
and Postgre

u have to do something like

CREATE TABLE mytable
(product_name varchar(20 ) );

Answer 5

Oh and just to add... for the 'like' predicate you need to use a percent sign otherwise you will never find any records unless there is an exact match. e.g.

Where myField like 'Smith%'

will find anything that begins with the word 'Smith' and

where myField like '%Smith'

will find anything that ends with the word 'Smith' and

where myField like '%Smith%' will find anything where the word 'Smith' exists in the field data.

Answer 6

square brackets work with sql server and access, but it is best practise not to have spaces, and use and underscore between words

Answer 7

if a name contains space(s) you should use [ ] for accessing to it.
for example::

select * from myTable
where [st num]="name"

Answer 8

<0098741>****>>>>>>S--___ - Quote > DLL. ?lamb>?..**%%%.regetit&&**)