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 MoreTag: MySQL | MySQL Tutorial from Beginners to Intermediate | MySQL Interview Question
How to clone table in MySQL ?
Table Clone in MySQL Copy a existing table structure and datas into new table CREATE TABLE enquirydetail1 LIKE enquirydetail; INSERT enquirydetail1 SELECT * FROM enquiry;
Read MoreHow to import table from other database in MySQL
Import a record from other Database How to import a record from another database table in mysql ? Same Table Structure in Source and Destination Table INSERT INTO <TABLENAME> SELECT * FROM <DESTINATION DATABASENAME>.<TABLENAME> Transfer from Limited Fields INSERT INTO <TABLENAME> (col1, col2) SELECT (col1, col2) FROM <DESTINATION DATABASENAME>.<TABLENAME> Transfer from Limited Fields with Condition INSERT INTO <TABLENAME> (col1, col2) SELECT (col1, col2) FROM <DESTINATION DATABASENAME>.<TABLENAME> where condition.field = condition.value
Read MoreHow 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 MoreInsert a row no in new column in MySQL
Add a row no. in new column Update a column with record row no in MySQL Execute the below query in Mysql to update an row no. in the specified column My Sql Query Example SET @pos := 0 UPDATE userinfo SET fuserid = ( SELECT @pos := @pos + 1 ) ORDER BY updated_at DESC @pos -> Variable Name userinfo -> Table Name fuserid -> Column Name
Read More