delete record with join table

Posted by admin | Filed under cakephp

untuk arsip aja sebenernya.. soalnya sering lupa :D delete record with join table   DELETE u, up, upc, ut, utp FROM users AS u
LEFT JOIN users_photos AS up ON up.user_id = u.id
LEFT JOIN users_photos_comments AS upc ON upc.photo_id = up.id
LEFT JOIN users_topics AS ut ON ut.user_id = u.id
LEFT JOIN users_topic_posts AS utp ON utp.topic_id = ut.id
WHERE u.id = 12

Read More | Comments (0) | Apr 17th 2009, 06:24

export dan import di mysql

Posted by admin | Filed under IT

ini cuma buat arsip aja kadang saya suka lupa. jadi saya posting deh di blogs. nah pertama kl untuk export gunakan mysqldump cari di path mysql anda.. misal kl pk xampp dan di install di d:\ maka ada di d:\xampp\mysql\bin mysqldump -u root -p namadatabase > d:\namafile.sql sedang kl import gunakan perintah mysql -u root -p namadatabase < d:\namafile.sql

Read More | Comments (0) | Apr 5th 2009, 20:14