epiphone32
asked on
SQL Overview
Hi, i would just like to have a sql statement overview... any websites would be great, i would appreciate input on this site also.
what i am specifically looking for are a list of statements, Update, delete, insert.... and how you use them (including the proper ' and " so i dont get syntax errors)
thank you
what i am specifically looking for are a list of statements, Update, delete, insert.... and how you use them (including the proper ' and " so i dont get syntax errors)
thank you
ASKER
do you have a specific link, cause im not finding what im looking for
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
okay thats exactly what im looking for ryancys, the only other question im concerned with is the " and ' im not sure when to use them. i know sometimes its both and others its one or the other.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Typically we use the ' And ' within the " Where " condition, where we need to add more condition to the SQL statement.
Example:
UPDATE table_name SET column_name = some_value, column_name2 = some_value2 WHERE column_name3 = some_value3 And column_name4 = some_value4;
DELETE FROM table_name WHERE column_name = some_value And column_name2 <> some_value2;
And we also use the ' And ' in JOIN Statements where to join 2 or more tables according to the conditions
regards
Example:
UPDATE table_name SET column_name = some_value, column_name2 = some_value2 WHERE column_name3 = some_value3 And column_name4 = some_value4;
DELETE FROM table_name WHERE column_name = some_value And column_name2 <> some_value2;
And we also use the ' And ' in JOIN Statements where to join 2 or more tables according to the conditions
regards
www.sqlmag.com