MySql :: How to convert UNIX_TIMESTAMP data into DATE data in queries

There might be situations where you would want to convert a data stored in UNIX_TIMESTAMP format (may be by your code or else) to human readable DATE format of mysql, then just run this query-
SELECT FROM_UNIXTIME(time_stamp_fieldname) as any_ FROM table;

and see the results in a new table format, every record's timestamp data will be changed in Date data.
try it.
n
enjoy!
:-)

How to import data into MySql Database table from a CSV file

Whenever I have to fill a table with data in CSV file, I do this-

1.) Log in to your mysql console

    mysql -u root -p

2.) Make sure you have a database set up. now select that database

   mysql> use mydatabase;

3.) Create the table where you'll be inserting the data of CSV. now here, make sure that the table has the same column names ordering as they appear in the CSV file, because mysql puts all data as it encounters it. means in the same order. so if u break the order, then ur table may have fields with irrelevant data.

4.) Now fire this command to actually load the data from CSV into table-

     mysql>load data local infile 'c:/path/to ur/ file/filename.csv' into table yourTableName fields terminated by ',' enclosed by ' " ' lines terminated by '\n'

This should do all.

Any confusions?

ask me.

comment/compliment here.