I'm still in the process of tagging pages that were migrated from the old site, so for now you're best off using the search engine rather than relying on the tags.
- Grouping / concatenating / aggregating MySQL fields / column values - Given the test database from MySQL many-to-many join test and the following query: mysql> select posts.*, categories.* from posts_categories join posts on posts_categories.post_id = posts.post_id join categories on posts_categories.category_id = ca...
- How to write a MySQL table to a CSV file - To write the users table to /tmp/users.csv: SELECT * INTO OUTFILE '/tmp/users.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM users Source: Export data to CSV from MySQL
- MySQL many-to-many join test - MySQL 5.1.56. Setup: create database join_test; connect join_test; create table posts (post_id int not null auto_increment, name varchar(100), primary key (post_id)); create table categories (category_id int not null auto_increment, name varchar(100)...
- MySQL - Index User admin Grant Revoke Backing up Locate configuration files Max allowed packet error MyISAM to InnoDB Check a database for errors and repair tables Multiple access details in my.cnf User admin The foll...