Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

66 total

On This Page:

  1. 1 Export mysql table into csv
  2. 2 Bulk convert InnoDB tables to MyISAM
  3. 3 change mysql user password
  4. 4 move column in mysql
  5. 5 关于MYSQL的用法
  1. 6 Test php mysql pdo_mysql
  2. 7 import data into mysql
  3. 8 mysql jdbc access conf
  4. 9 Manually Starting & Stopping MySQL in Leopard
  5. 10 MySQL 5 macports setup

Export mysql table into csv

to mysql by deckard on Apr 06, 2008
Use /tmp, as mySql doesn't have write privileges everywhere.

select * into outfile '/tmp/outfile.txt' fields terminated by ',' from my_table_name;

Bulk convert InnoDB tables to MyISAM

to mysql sql innodb myisam convert by jamiew on Apr 02, 2008 1 Comments
// produces some handy ALTER statements
// I think there's a way to this w/ mysqladmin but I couldn't find it.

SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' engine=MyISAM;') FROM information_schema.tables WHERE engine = 'InnoDB';

change mysql user password

to mysql admin by deckard on Mar 26, 2008
From terminal (square brackets denote your input, do not actually include the brackets):

mysqladmin -u [user] -h localhost -p password '[new_password]'

move column in mysql

to mysql database by pvoigt on Mar 25, 2008
// description of your code here

ALTER TABLE TableName MODIFY ColumnName ColumnType NULL/NOT NULL AFTER OtherColumnName;

关于MYSQL的用法

to php mysql by panxiaoming on Mar 17, 2008 1 Comments
// MYSQL是一种非常常用的东西
//I JUST WANT TO TEST

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

Test php mysql pdo_mysql

to php mysql administration by deckard on Mar 14, 2008 2 Comments
// description of your code here

<?php $link = mysql_connect('localhost','mydbuser','mydbpassword');
if (!$link) {
        die('Could not connect to MySQL: ' . mysql_error());
} echo 'mySql Connection OK';
mysql_close($link);

$dbh = new PDO('mysql:host=localhost;dbname=test','mydbuser','mydbpassword');
if ($dbh) {
        echo 'mysql_pdo CONNECTION OK';
}
else {echo 'mysql_pdo ERROR';}
?>

import data into mysql

to mysql by deckard on Feb 20, 2008
Things to note:
Mysql may not have access to the directory you've put the datafile. Use /tmp to overcome this problem.
Datafile name must be the same as the mysql table you're importing to.

mysqlimport -u username -p --columns=column_1,column_2 --fields-terminated-by=',' databasename /tmp/data_file_same_as_mysql_table_name

mysql jdbc access conf

to mysql jdbc conf by xico on Jan 30, 2008 

url : jdbc:mysql://host_name:port/dbname

driver class name : com.mysql.jdbc.Driver

Manually Starting & Stopping MySQL in Leopard

to mysql osx start leopard stop mysql5 source built by minofare on Jan 22, 2008
This is for software built from source according to:
http://hivelogic.com/articles/installing-mysql-on-mac-os-x/

Start MySQL
sudo launchctl unload -w /Library/LaunchDaemons/com.mysql.mysqld.plist


Stop MySQL
sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysqld.plist


MySQL 5 macports setup

to mysql setup start stop mysql5 socket by minofare on Jan 16, 2008 2 Comments
You have to symlink mysql to the location on osx

first find out where mysql has put the socket:
mysql_config5 --socket

Next symlink /tmp/mysql.sock to the right location of the socket
sudo ln -s path-of-mysql.sock-from-above /tmp/mysql.sock


Start MySQL
sudo /opt/local/share/mysql5/mysql/mysql.server start

or
/opt/local/bin/mysqld_safe5


Stop MySQL
sudo /opt/local/share/mysql5/mysql/mysql.server stop
66 total

On This Page:

  1. 1 Export mysql table into csv
  2. 2 Bulk convert InnoDB tables to MyISAM
  3. 3 change mysql user password
  4. 4 move column in mysql
  5. 5 关于MYSQL的用法
  1. 6 Test php mysql pdo_mysql
  2. 7 import data into mysql
  3. 8 mysql jdbc access conf
  4. 9 Manually Starting & Stopping MySQL in Leopard
  5. 10 MySQL 5 macports setup