Thread: table and column name

table and column name

From
"wisan watcharinporn"
Date:
i think it not bug but it not correct at all

i create table with command
create table helloWorld (....)  <-- it create table helloworld not
helloWorld, i hope it be create helloWorld
create table "helloWorld" (....) <-- ok it create table helloWorld

in the same to create column name

because in style i prefer to give name helloWorld more than hello_world it
save more
character (and in java style) and in query  i like to use

select numberOfTeam from teamInOurSchool where studentAge >
maxAgeOfSmallChild;

more than
select number_of_team from team_in_our_school where student_age >
max_age_of_small_child;

or
select 'numberOfTeam' from 'teamInOurSchool' where 'studentAge' >
'maxAgeOfSmallChild';

for more 3000~5000 query i write in program i think it more save and easy to
read
thank you

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963