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