RE: rename table

2001-06-27 Thread David Lidström ( Cabesa ) 


Try this;

ALTER TABLE old_table_name RENAME TO new_table_foobar

\david


-Original Message-
From: Michael Ott [mailto:[EMAIL PROTECTED]]
Sent: den 27 juni 2001 09:19
To: MySQL-Mailing-List
Subject: rename table


hallo

i want to change the name of a table. what must i do?

--
Gruß  bye

Michael Ott

-
- Siemens AG - IS IT PS 51 ERL -
- Werner-von-Siemens-Strasse 60 -
- 91050 Erlangen-
- Tel. +49 91 31 7 42 0 54  -
- [EMAIL PROTECTED]   -
-

open-source and you have much fun

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Can only create 127 records in a table :o(

2001-06-15 Thread David Lidström ( Cabesa ) 


 most probable is that the auto-inc field is of a type
 that will not allow higher values than 127!!
 What is the field-type?

\d

-Original Message-
From: Mette Møller Madsen [mailto:[EMAIL PROTECTED]]
Sent: den 15 juni 2001 13:46
To: mysql listserver
Subject: Can only create 127 records in a table :o(


Hi there!

When I try to insert more than 127 rows/records in a table I get this error:

ERROR 1062: Duplicate entry '127' for key 1
(the key is an auto incremented primary key)

Does anyone know how to store _more_ than 127 rows in a table?

My guess is that I need to change to settings of my db, but I cannot find
anything in the manual. (I'm running version 3.23.38 which should be a
stable one.)

best regards,
Mette Madsen


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php