Column definition: The EXTRA column

2001-09-10 Thread Ralof


I am trying to use the EXTRA column that exist
in mySQL (  DEFAULT
EXTRA
FIELD
KEY
NULL
PRIVILEGES
TYPE), but I do not understand how to put a
value into it, I can get the value with SHOW COLUMNS,
but I can not set it, andd it seem to be totally 
ignored in the manual. 

Does anyone know anything about this?


Thankful for any help

Stefan



-
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: ASP MySQL

2001-09-10 Thread Ralof

I usually use MySQL with MyODBC, then it is just like any other database,
but faster :)

Stefan


 -Original Message-
 From: L_U_I_Z [mailto:[EMAIL PROTECTED]]
 Sent: den 10 september 2001 22:08
 To: [EMAIL PROTECTED]
 Subject: ASP  MySQL


 I'm developing an application and I have to choose a good database
 server.

 I'm considering MS SQL Server and MySQL.
 I haven't heard very much about MySQL, but from I've read on the web I
 think MySQL is Unix/Linux orientated and works well with PHP.

 I'm going to use a NT platform, with the IIS as web server, and I
 wanted to use ASP. Does MySQL fit good with IIS and ASP?

 Thaks.

  ___
 Consigue tu e-mail gratuito TERRA.ES
  Haz clic en http://www.terra.es/correo/


 -
 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




The EXTRA field

2001-09-09 Thread Ralof

Hi, I would like to use the EXTRA field for 
sorting and maybe caption, but I find no way
of setting it.
I tried like:

Alter table myTable 
change  myField myNewField varchar(255) DEFAULT 'a' EXTRA '3'

But that does not work.
I can not find anything in the documentation about this.

Thanks

Stefan

-
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