Search the Community
Showing results for tags 'php; mysql;'.
Found 1 result
-
I have table like this : CREATE TABLE IF NOT EXISTS `hari_libur` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tgl_libur` date NOT NULL, `keterangan` varchar(64) NOT NULL, `ulangi` int(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- Dumping data for table `hari_libur` -- INSERT INTO `hari_libur` (`id`, `tgl_libur`, `keterangan`, `ulangi`) VALUES (1, '2010-12-25', 'Hari Raya Natal', 1), (2, '2010-08-17', 'Proklamasi Kemerdekaan RI', 1), (3, '2010-01-01', 'Tahun Baru Masehi', 1), (4, '2012-08-19', 'Hari raya Idul Fitri', 0), (5, '2012-08-20', 'Hari Raya Idul Fitri', 0); I want to auto insert for "ulangi" = 1 is repeat every year when i call a storeprocedure. How to make it? So i dont entry data every start year. thanks