NOW, CURDATE, & CURTIME in MySQL

Contoh2nya seperti terlihat di bawah :

Creating new DB in HeidiSQL

After connecting HeidiSQL to our localhost db, next let's create a new db to play with... :D... Follow below pictures...

Next... Add a new column, hit "Add" button as shown above...Then edit the new column as shown below

Then create this CustomerID as Primary Key:

Okie... Let's add another table column....

Yuuups.... That's all of column that we need... Next... Let's put something to our table by using this sql query :

Result :

Yuuups..... That's all... :v