A friend of mine mentioned that Suse and another Linux distribution were going to switch from MySQL to MariaDB. So I got curious and looked at it. According to their website, it is a drop-in replacement for MySQL. You can uninstall MySQL, install MariaDB and things will just work. No need to change any code. […]
Tag Archives: mysql
Importing a CSV file into a table in MySQL
Here’s how you would import data into MySQL using a query
|
1 2 3 4 5 6 7 8 |
/* If the CSV file was created in Windows, then replace '\n' with '\r\n' */ LOAD DATA LOCAL INFILE '/path/to/csv_file.csv' INTO TABLE `table_name` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY "\"" LINES TERMINATED BY '\n' (field1, field2, field3); |
Cool things you can do with MySQL
Run a query from command line
|
1 2 |
# Use the -e flag shell>mysql -e "select * from table" |
Tell MySQL to output the results of a query in HTML or XML
|
1 2 3 4 5 6 7 8 9 |
# On command line you would write the following to # tell MySQL to output the results in HTML format shell>mysql -e "select * from table" --html # This is for XML shell> mysql -e "select * from table" --xml # This is for batched results shell> mysql -e "select * from table" --batch |