Articles by Steve Cheng

 INSERT INTO {table_name} (col1,col2) VALUES (val1,val2), (val3,val4),(val5,val6);

This would insert three rows.

Great for relatively short inserts, larger amounts of data can cause MySql server to lock up and possibly abort.

I setup Xdebug recently to profile a drupal page that was exceedly slow.  I'm running ubuntu 10.10 with a typical lamp stack and did the following:

apt-get update

apt-get install php5-dev php-pear

pecl install xdebug

locate xdebug.so (should look something like this: /usr/lib/php5/20060613/xdebug.so)

Add the following line to php.ini (zend_extension="/usr/lib/php5/20060613/xdebug.so")

/etc/init.d/apache2 restart

Check your phpinfo to ensure xdebug has been sucessfully installed

SELECT id FROM table WHERE id in (7,2,5,9,8) ORDER BY FIND_IN_SET(id,"8,2,5,9,7");

GRANT ALL PRIVILEGES ON db_base.* TO db_user @'localhost' IDENTIFIED BY 'db_passwd';