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

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

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_dt>curdate-interval 1 day again thanks a lot... and thanks to Jeff too. Sukanto -- MySQL General Mailing L

Re: delete record that passed > 1 day

f 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

Re: delete record that passed > 1 day

ete 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 *

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. Anyo

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

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

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-hosti

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