Pages tagged with mysql

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...

This website is a personal resource. Nothing here is guaranteed correct or complete, so use at your own risk and try not to delete the Internet. -Stephan

Site Info

Privacy policy

Go to top