To view database tables details:
How change tables database engine:
How read and import csv file data:
LOAD DATA
LOCAL INFILE ‘C:/uk.csv’
INTO TABLE myTable
FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ (
id,
tableField1,
tableField2,
tableField3
);
SHOW WARNINGS;
LOCAL INFILE ‘C:/uk.csv’
INTO TABLE myTable
FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ (
id,
tableField1,
tableField2,
tableField3
);
SHOW WARNINGS;
How insert data using select query in mysql:
INSERT INTO new_table (date,record_id,data_field)
SELECT date, record_id, data_field FROM old_table
ON DUPLICATE KEY UPDATE date=old_table.data, data_field=old_table.data_field;
Category: All Tutorials