How to give GRANT access to existing MYSQL Users ?
1) SELECT access
GRANT select on <> to <>@%
DBName > Database Name
User Name > MYSQL User Access Name
Example :-
GRANT select on ‘MASTER.*’ to ‘GuestUser@%’
2) UPDATE, INSERT, DELETE Access
GRANT INSERT, UPDATE, DELETE on <> to <>@<>
How to get Yesterday date in MYSQL Query ?
The below function return the yesterday date in MySQL
Movers in Dubai
SELECT SUBDATE(CURDATE(),1)
How to Convert the DATE TIME column to local time zone ?
In mysql the function CONVERT_TZ (, <>,<), converting a time zone from default to new / local zone.
Movers in Dubai
| Check Responsive site
Example :
Change to IST from Default.
convert_tz(order_date, ‘+00:00’ , ‘+05:30’)
How to convert MYSQL Datas to JSON.
json_encode ($datas)
json_decode($datas)
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 ‘<<CSV File Name>>’
INTO TABLE <<Table Name>>
FIELDS TERMINATED BY ‘,’
ENCLOSED BY ‘”‘
LINES TERMINATED BY ‘\n’
IGNORE 1 ROWS
Example :-
LOAD DATA INFILE ‘f:/LeadsDetails.csv’
INTO TABLE oldleads
FIELDS TERMINATED BY ‘,’
ENCLOSED BY ‘”‘
LINES TERMINATED BY ‘\n’
IGNORE 1 ROWS
Create an duplicate table structure from the primary table
1) CREATE TABLE enquirydetail1 LIKE enquirydetail;
Copy a existing table structure and datas into new table
CREATE TABLE enquirydetail1 LIKE enquirydetail;
INSERT enquirydetail1 SELECT * FROM enquiry;
