auto_increment nya km ganti IDENTITY(24,1) km hilangin ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=24 ; kalo masih error manual saja , he2 ===============================
" Ketika hidup harus memilih " =============================== --- On Thu, 5/8/10, basroy <[email protected]> wrote: From: basroy <[email protected]> Subject: [ITCENTER] auto_increment di microsoft sql server 2000 To: [email protected] Date: Thursday, 5 August, 2010, 11:36 AM para master-master saya ada trouble dalam membuat database karena saya baru belajar di dalam perkuliahan database ini. saya sebelumnya udah coba di xampp dan berhasil tapi setelah saya pake di sql server 2000 kok ga bisa. ini versi xampp-nya CREATE TABLE IF NOT EXISTS `agenda` ( `id_agenda` int(5) NOT NULL auto_increment, `tema` varchar(100) collate latin1_general_ci NOT NULL, `isi_agenda` text collate latin1_general_ci NOT NULL, `tempat` varchar(100) collate latin1_general_ci NOT NULL, `tgl_mulai` date NOT NULL, `tgl_selesai` date NOT NULL, `tgl_posting` date NOT NULL, `id_user` varchar(50) collate latin1_general_ci NOT NULL, PRIMARY KEY (`id_agenda`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=24 ; nah kodingan diatas setelah di coba di sql tersebut auto_increment nya kok ga bisa ya. yang saya mau tanyakan kepada para master sekalian adalah letak kesalahannya ada dimana, apakah ada kodingan lain selain auto_increment buat pengisian id_agenda secara otomatis? terima kasih [Non-text portions of this message have been removed] ------------------------------------ -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [email protected] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
