hallo mailinglist!
With reference to Yee Chuan Loh on 25.06 00:11:
> connect to your database by
> mysql -p
> then type
> drop table ;
>
>
this i want to know too. thanx!
>
> > Hi, I need to delete a table from a database. I
> > looked through the manual, but it's not listed in the
> > tab
On Sun, 24 Jun 2001 21:06:16 -0700 (PDT), ricky gonzalez
<[EMAIL PROTECTED]> wrote:
DROP TABLE table_name;
>>Hi, I need to delete a table from a database. I
>>looked through the manual, but it's not listed in the
>>table of content.
>>
>>Thank you for your help.
Mike(mickalo)Blezien
connect to your database by
mysql -p
then type
drop table ;
On Sun, 24 Jun 2001, ricky gonzalez wrote:
> Hi, I need to delete a table from a database. I
> looked through the manual, but it's not listed in the
> table of content.
>
> Thank you for your help.
>
>
Hi, I need to delete a table from a database. I
looked through the manual, but it's not listed in the
table of content.
Thank you for your help.
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-
Andre,
the strange behavior may have been due to the same bug Alex
Baumeister reported, and for which I posted a fix on the mailing
list a few minutes ago.
After you had reloaded the table, did you insert, update, or delete
any rows in the table? Or did you just do selects? Did you have any
othe
Heikki, here are more details ...
I' am running mysql-3.23.37 on a hp-ux11 box (with actual patches)
I used the following configure options to compile MySQL:
CXX=gcc
CFLAGS="-fomit-frame-pointer -O6 -fpic"
CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti -O6"
./configure --with-low-m
Andre,
it might be a bug in the multiversioning code in InnoDB.
Can you describe in detail the situation:
- What is the CREATE TABLE statement?
- How many rows there are in the table?
- How did you import the table?
- Are you able to repeat the bug if you delete and drop the table,
and create
Hi,
I accidently delete all my records from a table, but I always make backups!!!
Okay, I deleted the (empty) table with drop table.
Than I recreate the table and all the data mith a mysql batch job (from
mysqldump) .
No problem. Than I started the mysql UI and make some test queries.
select *
