Wednesday, August 01, 2007

I insert data in to multiple tables in MySql

I saw this question on Techjamaica forum and noted it. Interesting question and interesting answer.

Basically here is the question. Can I insert data in to multiple tables in MySQL using one insert SQL statement?

Seems like the answer is no

Can I you insert data multiple times into the same table with one statement too.
INSERT INTO employees VALUES
(DEFAULT,'Hicks','Freddy','crew'),
(DEFAULT,'Harris','Joel','crew'),
(DEFAULT,'Davis','Julie','manager');

Examples taken from:
http://www.tizag.com/sqlTutorial/sqlinsert.php
http://www.desilva.biz/mysql/insert.html

Robots.txt and Search Engines

It is not sexy but it useful. The robots.txt is suppose to tell robots/bots/crawlers where they can crawl on a web site. The robots.txt mus...