Buat rekan-rekan yang driver untuk toshiba silahkan ke link berikut Driver Toshiba, semoga membantu
Software Hotel atau Wisma Berbasis Web
Software ini cocok untuk kalangan usaha hotel, wisma, homestay atau lainnya.
Software Maintenance Kendaraan Rental atau Travel Bus
Software ini cocok bagi instansi atau pribadi yang memiliki kendaraan cukup banyak agar tidak lupa dalam maintenance.
Software SMS Quick Count
Software ini cocok untuk PILEG, PILEPRES, dan PILKADA agar perhitungan hasil dari TPS dapat cepat diterima.
Software SMS Gateway Untuk Sekolah, Akademik, dan Bimbingan Belajar
Software sms gateway ini dapat memberikan informasi yg cepat keorang tua atau siswa tentang kehadiran siswa, nilai siswa, serta pengumuman dari sekolah.
Software Pengelolaan Arsip
Softare ini cocok bagi instansi swasta atau pemerintah agar mudah dalam monitoring arsip yang keluar masuk.
August 28, 2011
Driver Toshiba Satellite L510
| |||||||||||
| |||||||||||
August 22, 2011
Ebook O'Reilly Hacking
Index of ebooks o reilly hacking
Name Last modified Size Description
![[DIR]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uHH0Bg-1EMyIamTT3H9s4N9IQu7CDuoy6jsWBWbEbVj6DsGUmSz4294_OYf4aOEW8eilWQIDDnM7pvFx8aNJsQ0hFv351Sn8ES4Q0CjA=s0-d)
ebooks_o_reilly_hacking.rar 2011-08-20 18:00:00 -
Maggie Reilly - 2006 - Rowan 2008-09-27 09:20:01 -
Tutorial Trigger in Mysql
If you’ve worked with any of the commerical databases other than MySQL, you may have already had some experience with triggers.
I’m glad that the MySQL developers finally managed to squeeze in this extremely important feature. I no longer dread trying to defend MySQL from the Microsoft and Oracle developers who have had triggers for so many years.
I’ll use the example off the MySQL website (explained below in detail). I’ll assume you know how to create a table. If not, please read up on that first.
A few notes:
As of MySQL 5, triggers on DELETES will not run if you delete via cascading foreign keys.
On an INSERT, you can only use NEW for column values. On a DELETE, you must use OLD.
I’m glad that the MySQL developers finally managed to squeeze in this extremely important feature. I no longer dread trying to defend MySQL from the Microsoft and Oracle developers who have had triggers for so many years.
I’ll use the example off the MySQL website (explained below in detail). I’ll assume you know how to create a table. If not, please read up on that first.
First, we need to change the end of line delimiter. We do this because the statements in the trigger need to end in a semicolon, this is explained further below. This is simple:CREATE TABLE test1(a1 INT);
CREATE TABLE test2(a2 INT);
CREATE TABLE test3(a3 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
CREATE TABLE test4(
a4 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
b4 INT DEFAULT 0
);DELIMITER |CREATE TRIGGER testref BEFORE INSERT ON test1
FOR EACH ROW BEGIN
INSERT INTO test2 SET a2 = NEW.a1;
DELETE FROM test3 WHERE a3 = NEW.a1;
UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
END;
|DELIMITER ;
Next, we specify the action and table for this trigger. In this example, the table is “test1″, and the trigger will execute before any inserts.DELIMITER |
We specify the following line to make sure if we’re doing a batch update it’ll apply the trigger to each row inserted.CREATE TRIGGER testref BEFORE INSERT ON test1
Now we can specify the actions that will occur as the trigger. We use the keywords NEW and OLD to reference the columns in the row. On an INSERT, there are no OLD columns.FOR EACH ROW BEGIN
We’re done - end the trigger. To finish this single statement (because this entire trigger is really 1 statement, remember we changed our end of statement delimiter) we end it with the |INSERT INTO test2 SET a2 = NEW.a1;
DELETE FROM test3 WHERE a3 = NEW.a1;
UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
We can now change back the end of line delimiter to a semi-colon.END;
|
You will now have a trigger on the table ‘test1′ that occurs on every insert.DELIMITER ;
A few notes:
As of MySQL 5, triggers on DELETES will not run if you delete via cascading foreign keys.
On an INSERT, you can only use NEW for column values. On a DELETE, you must use OLD.
Download MySQL Front
Download
| Version 5.1, Build 1.20, 22 Apr 2009 | PAD |
| |
Tutorial RDMS MySQL
Name Last modified SizeParent Directory -
RDBMS-MySQL (uli).pdf 11-Jun-2008 12:04 3.3M
MySQL Presentations File PDF
Index of /MySQL/Meetup/Presentations
Name Last modified Size
Parent Directory -
2008-04-07 MySQL Roadmap 2008-2009.pdf 10-Jul-2008 13:47 1.6M
Free Mysql Download Manual
Index of /MySQL/Downloads/Manual
Name Last modified Size Description
Parent Directory -
MD5SUMS 04-Nov-2006 12:47 595
administrator-a4.pdf 04-Nov-2006 12:47 704K
connector-j.tar.gz 04-Nov-2006 12:47 72K
Subscribe to:
Posts (Atom)
