databases
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
databases [2013/06/03 09:53] sandeep |
databases [2018/03/24 11:13] (current) |
||
|---|---|---|---|
| Line 73: | Line 73: | ||
| field not like '%' | field not like '%' | ||
| + | </code> | ||
| + | == Multiple constraints == | ||
| + | We can use and,or in SQL to support multiple constraints | ||
| + | <code sql> | ||
| + | SELECT * from tablename where n > 10 and b < 20; # Executes only if both a > 10 and b < 20 | ||
| + | SELECT * from tablename where n > 10 or b < 20; # Executes if any is true | ||
| </code> | </code> | ||
| + | == Getting Count== | ||
| + | <code sql> | ||
| + | SELECT count(*) from tablename; | ||
| + | </code> | ||
| + | === Update === | ||
| + | <code sql> | ||
| + | UPDATE tablename set field = value where field2 = value2; | ||
| + | </code> | ||
| - | === Update === | + | Multiple constraints apply here also. |
| === Insert === | === Insert === | ||
| + | <code sql> | ||
| + | INSERT INTO tablename values ( value1, value2, value3 ); | ||
| + | </code> | ||
databases.1370253222.txt.gz · Last modified: 2018/03/24 11:13 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
