Bookmark and Share
Last Updates
Display: 1 - 5 of 5, Total Pages: 1
1
[Blog] how to dump mysql procedures [Original] 2010-4-26 10:44pm

mysqldump -uroot -p --routines --no-create-info --no-data -S /data1/mysql/tmp/mysql.sock network > proc.sql

Read Full Article...

Section:MySQL DBA | Read:2051 | Comment:0 | Rating:0%

[Work Notes] an example of loop insert in a MySQL procedure [Original] 2009-11-13 4:13pm
delimiter //CREATE PROCEDURE insert_temp()    BEGIN    DECLARE v1 INT;    SET v1 = 2707242;    WHILE v1 < 2721615 DO    in..

Read Full Article...

Section:MySQL DBA | Read:11022 | Comment:0 | Rating:0%

[Study Notes] How MySQL handles errors during trigger execution? [Original] 2009-11-4 4:22pm
MySQL handles errors during trigger execution as follows:     * If a BEFORE trigger fails, the operation on the corresponding row is not performed.    * A BEFORE trigger..

Read Full Article...

Section:MySQL DBA | Read:3029 | Comment:0 | Rating:0%

[Study Notes] potential problems of Stored Programs in MySQL replication [Original] 2009-11-4 4:19pm
18.6. Binary Logging of Stored Programshttp://dev.mysql.com/doc/refman/5.4/en/stored-programs-logging.html However, there are certain binary logging issues that apply with respect to stored programs..

Read Full Article...

Section:MySQL DBA | Read:605 | Comment:0 | Rating:0%

[Study Notes] Disadvantages of mysql stored procedures [Original] 2009-11-4 4:17pm
• MySQL doesn’t provide good developing and debugging tools, so it’s harder towrite stored code in MySQL than it is in some other database servers.• The language is slow and prim..

Read Full Article...

Section:MySQL DBA | Read:3929 | Comment:0 | Rating:0%

1
Latest Comments
eozzrixrlo

on line..
- By admin, 2008-4-24 2:34am
rvaqlckrdu

free nud..
- By admin, 2008-4-24 2:33am
xndfjmwcpj

- By admin, 2008-4-5 1:02pm
vsjblsgatm

somali p..
- By admin, 2008-4-5 1:01pm
jknsdsmvyi

- By admin, 2008-3-12 1:48am
fkgyuchizk

tramadol..
- By admin, 2008-3-12 1:48am
wnniqpohsg

- By admin, 2008-4-24 2:32am
unxnmahoya

in phent..
- By admin, 2008-4-24 2:29am
bkgulrjbtt

- By admin, 2008-3-12 1:47am