Re: query

2002-05-27 Thread Mr. Ozette Brown
saraswathy saras wrote: > Hi everybody, > > Can anybody help me? I'll give it a shot. > is there any other specific command instead order by ID DESC to select > all the record from table where the ID is the last ID.The ID is > autoincrement. Try this: select last_insert_id() as ID from TA

Re: myisamchk and table corrupt

2002-03-25 Thread Mr. Ozette Brown
Patrick, Try this from your shell: You want to flush the tables (I'm assuming you want to keep the database up and running), do a recover, safe recover, and check to make sure you don't get the error messages when everything is finished. $ mysqladmin flush-tables $ myisamchk -r -o /var/lib/mys

Conversion from ISAM to MYISAM table format

2002-03-06 Thread Mr. Ozette Brown
I'm in the process of converting all of my database tables from ISAM to MYISAM table format. I'll run the mysql_convert_table_format script which basically does an "Alter table". If during this conversion someone accessed a web page which writes to the database (insert or update), what will