Re: referential integrity for MyIsam
CanIt Vote for ID 62298InnoDB still has the major issue about the slow access of database... I use mysql database for website.. - Original Message - From: Daniel Kasak To: starofframe ; [EMAIL PROTECTED] Sent: Friday, July 02, 2004 11:08 AM Subject: Re: referential integrity for MyIsam starofframe wrote: Hi All, I've read that MyIsam type table doesnt have the referential integrity function... I hav tried to find other 3rd party s/w that can solve the issue. Finally I read from PhpMyAdmin documentation that recently PhpMyAdmin can check referential Integrity but I still dont know how to do it after reading the documentation for some times So anyone ever face such issue?? Thanx Flame Don't like InnoDB? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- -- The following links have been inserted by the NUS Consulting internal spam filter and are for NUS Consulting staff only Spam Not spam Forget previous vote
referential integrity for MyIsam
Hi All, I've read that MyIsam type table doesnt have the referential integrity function... I hav tried to find other 3rd party s/w that can solve the issue. Finally I read from PhpMyAdmin documentation that recently PhpMyAdmin can check referential Integrity but I still dont know how to do it after reading the documentation for some times So anyone ever face such issue?? Thanx Flame
delete record that passed 1 day
Hi all, I have mysql table that has a field named 'crea_dt' (it records the creation date of data)... I want to delete records that have passed for more than a day description like this : if now()-crea_dt 0 then delete But I just can't find the suitable mysql command for this function. Anyone can help me, thanks a lot. By regard; Sukanto
Re: delete record that passed 1 day
Hi Jeff, you mean I can use sql like this DELETE FROM table where date_sub(crea_dt, interval 1 day) thanks a lot Sukanto - Original Message - From: Jeff Smelser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 8:55 AM Subject: Re: delete record that passed 1 day -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 07 June 2004 08:36 pm, starofframe wrote: description like this : if now()-crea_dt 0 then delete select date_sub(crea_dt, interval 1 day) - -- If you're like me, and I know *I* am... -- Joel Robinson -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFAxRymld4MRA3gEwYRAubCAKCZQMtmxe04LtcOAND/u1I7GJOYtQCfdj1/ 48Ab3kxyB3zrYmZsudqgXvQ= =G+Ew -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: delete record that passed 1 day
Yes, I did found out just now... but delete from table where date_sub(crea_dt, interval 1 day)crea_dt should delete all data right??? All I want is compared to date_now eg : now is 2004-6-8 and all I want to delete is data that hav passed 1 or more days... such as L 2004-6-7,2004-6-6, etc.. so what's the suitable command then.. again thanks a lot Sukanto - Original Message - From: Jeff Smelser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 9:41 AM Subject: Re: delete record that passed 1 day -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 07 June 2004 09:22 pm, Jeff Smelser wrote: On Monday 07 June 2004 09:25 pm, starofframe wrote: Hi Jeff, you mean I can use sql like this DELETE FROM table where date_sub(crea_dt, interval 1 day) Add: crea_dt Could be .. Damn, I always have to do a select first.. I get them backwards some times. - -- In nature, there are no rewards or punishments, only consequences. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFAxSdFld4MRA3gEwYRAqvaAJ956TjRnblPfJLMWw3pUIiQV+ba4wCfbeVy o56hnpxuB5FnVqGmPMYhbC0= =um6f -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: delete record that passed 1 day
Thanks a lot Mike... what's a clear explanation... Actually I have used WHERE crea_dt + interval 1 day curdate() before I read ur reply ...but now I guess I better change it to WHERE crea_dtcurdate-interval 1 day again thanks a lot... and thanks to Jeff too. Sukanto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql error
Hi all, I have a problem when I'm trying to connect to mysql server at my web hosting... appears error message like this : Could not connect to MySQL server! 2002: Can't connect to local MySQL server through socket '/usr/home/greatdynamic/mysql/mysql-greatdynamic.sock' (2) never appeared such problem before... I guest that I need to restart mysql (maybe mysql hang after left running all the time).. so how to restart mysql ... I've tried this command : mysql/bin/safe_mysqld (not work) By regard; Sukanto
InnoDB weird thing!!
Hi, I wanna ask about InnoDB... I've been trying InnoDB for sometimes and I found out one thing weird that is : When I make an InnoDB tables and filled it with some records ..it took about 2 Mb of file's capacities.. but when I delete all the records... the file's capabilities just still 2 Mb... If I'm not wrong, Micro Access has such problem too but we can use compact database to refresh it... So how to compact innoDB databases??? By regard; Nicholas Kho
Mysql Linux can't auto flush-tables
Hi, I have problem with Mysql 3.23.58 on Linux Mysql can't auto Flush-Tables I work with Mysql 3.23.58 windows version on my local computer... Then I upload to web-hosting that working with Mysql 3.23.58 on Linux.. Everytime I add some record on my local computer then upload to web-hosting... The table can't auto flush-tables... I have to ssh to server then type in mysql/bin - mysqladmin -u root -p flush-tables Then the table refresh... So anyone know how to configure Mysql to auto run flush-tables?? Thanx Nicholas Kho -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql_server cannot auto-refresh...
Hi someone plz help me... I got a problem here with mysql I made a table with 4 fields in local comp then uploaded to my web-hosting... it's all fine 'till I added 1 field to my table so the table now have 5 fields... then uploaded to my web-hosting... but the problem is that the table just still the same ..with 4 fields I think that mysql not refresh itself.. I have try to download new table that I uploaded to my web-hosting .. and the result just the right one, table with 5 fields.. My web-hosting is Linux based server, and I install mysql 3.18 (source code mode) then I configure there myself... What's the problem then ??? How to refresh mysql??? Thanx Sk2 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]