pb with integrity constraint

Hi the list, I try to create tables with integrity constraint but it seems no running. I've got the next script : create table USERS ( USER_CODE INT(8) not null, USER_NAME VARCHAR(30)not null, primary key (USER_CODE) ) ; cre

RE: Licensing

I agree with Sean. -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoyé : Monday 14 January 2002 2:25 PM À : [EMAIL PROTECTED] Objet : RE: Licensing i was under the impression that unless the application will 'only' run under mysql (ie uses a mysql specific featu

Remove PRIMARY KEY attribute

Hi the list, I use MyISAM tables. How to remove the primary key attribute from a column, without removing the column itself ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.my

Load ODBC Data

Hello the list, Is it possible to import ODBC data into a mysql database ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request thi

Problem creating primary key on blob column

Hello the list, I try to create a table with a TEXT primary key, and this error message appear : ERROR 1170 : BLOB column 'MY_COLUMN' used in key specification without a key length. What is the syntax to settle a key length ? Here is my sql code to create my table: -- =

SQL String max length ?

I stored a sql string in a file and when I launch it, it doesn't perform because the string is truncated before the end. Does mysql limit the length of an sql string ? How do I do to execute my all sql string ? - Before postin

Execute a file containing a sql script

Hi, I'm a beginner in MySQL (also in english) so sorry for my uninterristing questions. I've installed MySQL 3.23.43 on a Linux RedHat 7.0 system, and it seems to work normally. How to execute a sql script which is inclus in a text file (ex : script.sql) ? With Oracle, you know, it's done with