Doubt about database

Asked

Viewed 58 times

-1

Can anyone tell me what the double quotes are for in the table name in a query? for example: select * from "student" Where name= 'Stefany'

what the two quotes of the student table do differently?

database
  • 1

    Depends on the database engine. But in general double quotes delimit database object identifiers and single quotes delimit strings and/or dates.

2 answers

1

Double quotes are standard ANSI delimiters for identifiers, when you run the instruction select * from "aluno", will return the same data as an instruction select * from aluno.

Double quotation marks also mean that a certain value is char

-1

In ANSI SQL, double quotes are used in object names (for example, tables) they allow them to contain characters not otherwise permitted or to be equal to reserved words.

Browser other questions tagged database

You are not signed in. Login or sign up in order to post.