Archive for the ‘ Learn SQL Statement ’ Category
Belajar SQL Statement – How to substract one date
How to substract one date from another date.
SELECT (TO_DATE(‘09-AUG-2003′) – TO_DATE(‘09-JUL-2003′)) as myDate
FROM dual
Result :
myDate
——
31
Tutorial SQL Statement – Select Statement – Part 2
The format is
SELECT field_name FROM table_name
Or you can use * for any field_name
SELECT * from table_name
Belajar SQL Statement – SQL Introduction – Part 1
MySQL is a database application that store your data.
If you want to store the data, you cannot just key in like you type in Microsfot Excel.
So how to do it ?
This is what we call SQL statement.
It is used to keyin, to call and to manupulate the data.