hey , can we fire query like FROM customer SELECT city ?? Instead if SELECT city FROM coustomer | Sololearn: Learn to code for FREE!
Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite
0

hey , can we fire query like FROM customer SELECT city ?? Instead if SELECT city FROM coustomer

26th Jun 2018, 5:56 PM
Prathamesh Patkar
Prathamesh Patkar - avatar
5 Réponses
+ 21
No, it will produce an error.
26th Jun 2018, 6:01 PM
Igor Makarsky
Igor Makarsky - avatar
+ 1
No. SQL is case insensitive, but you still have to keep correct syntax.
26th Jun 2018, 6:21 PM
Jan Štěch
Jan Štěch - avatar
+ 1
yes... as long as the naming/calling of either columns and table are correct using the right syntax...
26th Jun 2018, 9:20 PM
Silvanus Justice Silvanus
Silvanus Justice Silvanus - avatar
0
sql is like English so you have to make clearer what you want to do with this query like you mentioned select city from customers
26th Jun 2018, 6:41 PM
MsJ
MsJ - avatar
- 1
but SELECT city FROM Customer looks odd and this looks sense 😁 FROM customer SELECT city
26th Jun 2018, 6:55 PM
Prathamesh Patkar
Prathamesh Patkar - avatar