Move a column

Hi! Is it not possible to move a mysql column to after another existing Column by using the CHANGE statement in ALTER TABLE? I have the following columns: id ostron newCol_2 And I'd like to move the ostron-column to after the newCol_2 column. Is this not the syntax? ALTER TABLE

RE: rename table

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

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

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

RE: password assign for localhost

You must, after updating the user table, FLUSH PRIVILEGES And you should also set the password using the PASSWORD-command. update mysql.user set password = PASSWORD('abc') where user = 'root' and then FLUSH PRIVILEGES /d -Original Message- From: Alice

RE: Binary

03:28 To: David Lidström; MYSQL LIST Subject: Re: Binary At 9:16 AM +0200 5/29/01, David Lidström wrote: Is there some kind of pattern in fields containing binary data - so you can be sure that is really IS binary!? I.e. if I in my database have a BLOB-field and sometimes write a string

RE: Servlet SELECT Query syntax error

hi try to use ' around the new value. I.E. rs = stmt.executeQuery(SELECT * FROM MyTable WHERE title_name=' + request.getParameter(title_name) ) + '; /david -Original Message- From: Lucy [mailto:[EMAIL PROTECTED]] Sent: den 30 maj 2001 15:09 To: [EMAIL PROTECTED] Subject:

Binary

Is there some kind of pattern in fields containing binary data - so you can be sure that is really IS binary!? I.e. if I in my database have a BLOB-field and sometimes write a string, and sometimes a file?! Regards David -

RE: MySQL++ for Visual Basic

I use an Open Source mySQL API. [homepage] http://www.icarz.com/mysql/index.html / d -Original Message- From: Cyber Monkey [mailto:[EMAIL PROTECTED]] Sent: den 29 maj 2001 11:20 To: [EMAIL PROTECTED] Subject: MySQL++ for Visual Basic Has seen an ocx for the MySQL++ to allow

RE: My sql and system time

Hi! Try this: INSERT INTO my_table (myTimeField) VALUES (CURTIME()) [also see] http://www.mysql.com/doc/D/a/Date_and_time_functions.html -Original Message- From: VVM Ravikumar Sarma Chengalvala [mailto:[EMAIL PROTECTED]] Sent: den 29 maj 2001 15:07 To: [EMAIL PROTECTED]

Drop Database

Hi! I was testing some queries and now I've created a database named "#Muffin", and I cannot drop it! I've tried the following: DROP DATABASE #Muffin DROP DATABASE '#Muffin' DROP DATABASE "#Muffin" But it doesn't work! Please help! / David

RE: Drop Database

Yes I've tried that, but it didn't work either... But now I recieved a "Database Muffin doesn't exist"-error instead! /d -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mikel King Sent: den 25 januari 2001 09:14 To: David Lidstrm Cc: Mysql@Lists.