How to get last one hour data in MySQL ?

Last one Hour data in MySQL ? Example :- select o.code, o.customerId, c.name, c.email from `Order` o’; join Customer c on c.id = o.customerId ‘; where o.orderDate >= DATE_SUB(NOW(),INTERVAL <<SYNTAX>> HOUR) order by o.id limit 0, 2 Example :- select o.code, o.customerId, c.name, c.email from `Order` o’; join Customer c on c.id = o.customerId ‘; where o.orderDate >= DATE_SUB(NOW(),INTERVAL 1 HOUR) order by o.id limit 0, 2

Read More

How to import CSV file into Table in MySQL ?

Import CSV File into MySQL Table This below example shows you how to use the LOAD DATA INFILE statement to import CSV file into MySQL table. The LOAD DATA INFILE statement allows you to read data from a text file and import the file’s data into a database table very fast. Before importing the file, you need to complete the following steps : 1) Data Import table should be created 2) CSV Columns Should be match with the Database Table. 3) Access required to execute the query LOAD DATA INFILE…

Read More