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) ) ; create table ENV ( USER_CODE INT(8) not null, CODE_ENVVARCHAR(6) not null, primary key (USER_CODE, CODE_ENV), constraint FK_USER foreign key (USER_CODE) references USERS(USER_CODE) ) ; The tables creation are ok, but when I insert values in the table ENV without any data in USERS it works but normally it wouldn't. Something bad in may script ? - 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: 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 feature), its perfectly legitimate to use it without a licence. For Example, if your application uses odbc to communicate with the database, and standard sql to perform database queries, then it should run quite happyly on mysql, postgres, oracle or mssql. In these circumstances I dont see why your application should require a mysql licence, am i wrong about this guys? -Original Message- From: Pål Sollie [mailto:[EMAIL PROTECTED]] Sent: 14 January 2002 05:09 To: [EMAIL PROTECTED] Subject: Re: Licensing Monday, January 14, 2002, 3:11:00 PM, you wrote: Frans Englich writes: I'm writing an adminstrative program for a hotel located in Sweden. This program uses an mysql database as backend(the implementation is not in use yet, but my intention is to use mysql). To be really sure about this: Do the hotel _have_ to get an MySql database License or will they stay legal without one? I know, mySql is released under the GPL license but I need to be really sure about this. I would love to buy an license to support the Mysql team but since the license would be drawn from my payment I'm hesitating.. 200USD is alot of money here in Sweden, atleast for me. regards, Frans Englich [EMAIL PROTECTED] If you are giving your administrative program for free, you do not require a licence. Otherwise, you do ... Even if he uses an unmodified version of MySQL? -- Pål Sollie - [EMAIL PROTECTED] I had a fortune cookie the other day and it said: 'Outlook not so good'. I said: 'Sure, but Microsoft ships it anyway' - 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 - 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
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.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
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 this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: -- -- Table : MY_TABLE -- create table MY_TABLE ( MY_COLUMN_1TEXT not null, MY_COLUMN_2VARCHAR(2) not null, MY_COLUMN_3TEXT not null, constraint PK_TRADUCTION primary key (MY_COLUMN_1, MY_COLUMN_2) ) ; - Dominique TOMASSONI - [EMAIL PROTECTED] SunGard Investment Management Systems 173, Bureaux de la Colline Bâtiment E 92213 Saint-Cloud Tél : +33 1 49 11 31 23 Fax : +33 1 49 11 30 65 - - 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
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 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
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 @script.sql. Thank you for your answers. - 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