Re: Using 3.23 and Delphi 6

Try zeos lib at http://zeoslib.sourceforge.net/ [EMAIL PROTECTED] wrote: Hi I am currently trying to use mysql 3.23 for a database project and connect to it using a Delphi 6 front end. Can anyone tell me how the connect to a MySQL database and any other tips they might have on using Delphi 6 with

re: phpMyadmin

phpMyAdmin can admin. database that is not on the same machine. The only requirement is that machine can access the MySQL database to be admin. Which usually means that a user name and a ip address on the MySQL user table. However, I don't think that it is appropiate to have a notebook to instal

re: phpMyadmin

Using PhpMyAdmin for administering MySQL, can this product be installed on a remote system? We currently have it installed on the same server as MySQL, but now the programmer wants it on his Laptop. Or is there another product that can manage a MySQL database from either a Windows or Linux lapt

Help needed with SQL...

Hi All, I'm having problems creating a query to return a recordset from the following situation: I have two tables, one which contains member details, and the other which contains details re: the groups to which the member belongs. When a member logs into a particular part of my site, I want to

Re: index questions

If my answers are too basic, please accept my apology. 1: There is no difference: KEY is a synonym for INDEX. 2: In a syntax description, the use of [square] brackets means that the part in brackets is optional. Whether you include it or not doesn't change the semantics. 3: The PRIMARY KEY is

startingMySQL with InnoDB on Red Hat

Hi All, I'm quite a novice with Mysql and more than a newbee with Linux but I managed to install Red Hat on an x86 and installed MySQl too. Now I need to have InnoDB support. I installed MySQl on my notebook too (winxp) and edited my.cnf to start innodb and set all the required params. I use my not

Single Quote messing up WHERE ordering

These two work fine: SELECT * FROM ggSubmissions,ggSubEx WHERE ggSubmissions.GGsID != '1673' AND ggSubmissions.GGsID = ggSubEx.GGsID AND ggEID=51 AND WorkTitle > "Aerial - Manly Beach Surfers 1 - Sydney, Australia, February 2003" ORDER BY WorkTitle ASC LIMIT 1 SELECT * FROM ggSubmissions,ggSubEx

Re: index questions

please someone answer! see below - Original Message - From: "Sheryl Canter" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 7:07 PM Subject: index questions I have some basic questions that are driving me nuts, and I can't find answers anywhere. I've been ba

Re: Reference to a downloadable file

How do you serve up the other data from the database? Are the ZIP files in a directory that is accessible from the web? In the simple case, all you need to do is create an Download Design construct in your output from the php script. So if the column returned from the MySQL query is called ZIPFi

Using 3.23 and Delphi 6

Hi I am currently trying to use mysql 3.23 for a database project and connect to it using a Delphi 6 front end. Can anyone tell me how the connect to a MySQL database and any other tips they might have on using Delphi 6 with MySQL. I have never used MySql before and so the information needs to be

Reference to a downloadable file

I am building a web application for my embroidery business which is basically a catalog program within a members only subscription site. On each line item, I want to have a spot for a zip file for members to click on to download the embroidery design file. I have a field in my mySql database

RE: Question

If you are a TOTAL newbie and need a little programming background, I bought PHP & mySQL for Dummies and it was awesome! Renee :) -Original Message- From: Stefan Hinz [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 6:05 PM To: Jasdeep Singh Cc: [EMAIL PROTECTED] Subject: Re: Qu

Build error (v3.23.55) on Solaris 2.8

When I tried to build a client only version (v3.23.55) on a Solaris2.8 machine, I got the following error: ( while doing make install) I did ./configure -without-server. It works fine. This is the error make gives. ... cc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysqlc\" -DDATADIR=\"/usr/local/mysq

Re: Problem with MySQL, MyODBC, Access 2002 and Japanese.

Don't know, but: Are you using the Japanese Access 2002? What locale is your OS configured for? HTH, Tore. - Original Message - From: "Juan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 6:12 AM Subject: Problem with MySQL, MyODBC, Access 2002 and Japanes

View Warnings

Howdy all! mysql>LOAD DATA LOCAL ->INFILE "/Rob/architecturalScreens/prototype/v1/database/insertPart.dat" ->INTO TABLE part; Query OK, 496 rows affected (0.08 sec) Records: 496 Deleted: 0 Skipped: 0 Warnings: 1494 I am glad it loaded my file (it took me ages to build it)..

Re: decimal type

Stitchin' wrote: Why couldn't you use float(10,2) ... just an example ... where the first number in the parentheses is the total characters for the number and the second number represents how many of those are right of the decimal point?) Computers represent data in binary format at floating po

Re: Is there a way to time queries?

On Tue, Feb 25, 2003 at 04:36:23PM -0600, databarn wrote: > Folk, > > Two or three years ago, I was using ASP to access SQL Server 7 and MS > Access databases. There was a stopwatch dll made by CapRock Software > that allowed me to time various elements of my ASP scripts, > particularly the datab

index questions

I have some basic questions that are driving me nuts, and I can't find answers anywhere. I've been banging my head against the wall for hours and hours. I've searched everywhere on the internet and looked in every book I own. I can't find the information. Here are my questions. In the CREATE TABLE

Full Text Index Performance

I wanted to created a searh engine for our site with indexed content of the pages being stored in MYSQL full text index. I wanted to know how fulltext index scales if I have about 200,000 pages indexed. Is it wise to use MYSQL for this or go with other options like SWISH-e etc. --

Re: Question

Jasdeep, > Could you recommend me a book for learning MySQL for the beginner. Have a look at a variety of books recommended by MySQL AB: http://www.mysql.com/portal/books/index.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH Heesestr. 6, 12169 Berlin (G

Re: Question

http://www.amazon.co.uk/exec/obidos/ASIN/0735712123/qid=1046214226/sr=1-7/re f=sr_1_3_7/202-4962738-0968635 - Original Message - From: "Jasdeep Singh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 11:01 PM Subject: Question > Dear Sir: > > Could you recomme

Question

Dear Sir: Could you recommend me a book for learning MySQL for the beginner. Thanks Jasdeep - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archiv

Is there a way to time queries?

Folk, Two or three years ago, I was using ASP to access SQL Server 7 and MS Access databases. There was a stopwatch dll made by CapRock Software that allowed me to time various elements of my ASP scripts, particularly the database queries. I found several SQL problems that way, and made my qu

Re: mysql:Question about definition and index for performance

alter table tableA add index(key1, acct) creates a single index across the two columns. Trying to visualize the index as a sorted list (of course it is a b-tree), it will look something like: (key, acct:) 1,1 1,2 1,3 1,5 1,8 2,1 2,4 2,5 2,6 3,2 3,9 ... etc. Therefore, this index is not very use

Re: MySQL v SAB DB

SAPDB doesn't have collation (i.e. case-sensitivity). Be aware of this before you make a choice. While I was trialing it, the support was exceptional with very quick response from actual SAP engineers, but the lack of case-sensitivity was a show-stopper for me. Greg - Original Message -

Simple C API question

Maybe this is a stupid question but I couldn't find suitable sample code or an answer in the manual. mysql_fetch_row() returns a MYSQL_ROW representation of a row of data. According to the manual, this is "an array of counted byte strings". mysql_fetch_field() returns a MYSQL_FIELD with members

Re: mysql 4.0.11

Luc, - Original Message - From: ""Luc Foisy"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, February 25, 2003 9:09 PM Subject: RE: mysql 4.0.11 > > Did I miss the global release message for this version? > I got the InnoDB release message but no other... Lenz has

RE: mysql 4.0.11

Did I miss the global release message for this version? I got the InnoDB release message but no other... > -Original Message- > From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 25, 2003 10:53 AM > To: [EMAIL PROTECTED] > Subject: re: mysql 4.0.11 > > > On F

Re: Continuing problem

Ami, Joseph, > I'm running the Windows mysqld application and attempting to connect to > it using the CygWin libraries without any success. The mysql and > winmysqladmin all connect fine to mysqld. The error I get from my > application is 'Error 2002, cannot connect through socket MySQL' or it's

RE: Start MySQL along with a update statement.

Do you know that you can run mysql in batch mode? So you can achieve what you want by this. Read the below: http://www.mysql.com/doc/en/Batch_mode.html Regards, Joseph >-Original Message- >From: g gnanaraj [mailto:[EMAIL PROTECTED] >Sent: Tuesday, February 25, 2003 7:31 AM >To: [EMAI

Re: Starting MySQL Server

Try: safe_mysqld --user=user & Bill Jeremy Whitlock wrote: MySQL List, In Linux, I use: [EMAIL PROTECTED] bin]$ safe_mysqld --user=user to start the MySQL Server where user is a user in the database. When this happens, the terminal that I start it in become unusable. Is this by desi

MySQL/InnoDB-4.0.11 is released

Hi! InnoDB is a MySQL table type that supports transactions, foreign key constraints, and a non-free hot backup tool. This is a bugfix release of the branch 4.0 which will soon be declared stable. For InnoDB the only change in 4.0.11 is the following: * Fixed a bug introduced in 4.0.10: SQL que

mysql:Question about definition and index for performance

mysql, tableA, definition: key1 char(17) not null, acct char(12), other char (5) tableB is same definiton like tableA. I add index for both tableA and tableB like: alter table tableA add index(key1, acct) I will do left join with tableA and tab

RE: Query from a PHP Form

Thanks to al that repsonded and helped out. i dicovered that the form itself was not quite right and not posting the variables doh anmy way that is now fixed all but some cosmetics :) so the problem now returns to the query in companies.php if someone can have a little look and I am sure this wi

my_error.c

I'm not able to successfully complete make on mysql, I think I'm using mysql version 3.23. I'm using gnu's complier and make, I'm not using the Compaq C++ compilier. Thank you very much. Tru64 v5.1a CC=GCC CXX=GCC gcc version 2.97 GNU Make version 3.79.1 my_error.c: In function `my_error': my_er

Starting MySQL Server

MySQL List, In Linux, I use: [EMAIL PROTECTED] bin]$ safe_mysqld --user=user to start the MySQL Server where user is a user in the database. When this happens, the terminal that I start it in become unusable. Is this by design? Also, is there a way to make it where anyone that starts t

mysql.sock

Hi friends, I'm just starting to use MySQL for Linux. I installed it yesterday and it worked, but after restarting the computer it doesn't work anymore. When I type mysql at the linux prompt it says:"ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'". I'v

two servers on the same machine

Hi all, I have two servers on the same machine (Windows 2000). In the file my.ini i need to write new group for mysqld2. 1) Do i need to change the name of mysqld itself (to mysqld2)? 2) On Windows, is it enough that the port will be different between the servers, or there is something else need t

re: mysql 4.0.11

On Friday 21 February 2003 19:05, Reetz Wendy wrote: > Does anyone know when the release date for the mysql 4.0.11 version? I > was just about to rebuild everything (apache,php,etc), but if it's next > week, I'd rather wait for it. You can find 4.0.11 at: http://www.mysql.com/downloads/m

re: RE: Replication problem (alter table fails)

On Tuesday 25 February 2003 16:36, Floyd Wellershaus wrote: > Egor, > I am sorry, my bad. I misrepresented the versions of mysql I am using. Must > have been a typo. > Here is what I am using. > > Master: Sparc Solaris 7 MySQL 4.0.9-gamma-log > Slave: RedHat Linux 7.2 MySQL 4.0.8-gamma-log

re: Re: table row result spool to file

On Tuesday 25 February 2003 15:50, g gnanaraj wrote: > Thanks but I'm not getting the expected result. See the following: > > [quote] > [EMAIL PROTECTED] godson]$ cat chk5.sh > mysql -e "select * from baa into outfile \"/home/godson/run.sh\";" test > [EMAIL PROTECTED] godson]$ ./chk5.sh > ERROR 1

re: Different User, Different datadir

On Sunday 23 February 2003 02:19, Robert Mark Bram wrote: > I would like to create a user that will only access my current project's > database. Use GRANT command to give grants to user only for certain database. >I would also like to store the data for my current project's > database in a parti

re: Newbie question...

On Tuesday 25 February 2003 15:28, Fernando Morais wrote: > > I'm running Mysql Server 4.0.10 in Win XP. > And every time i shutdown the service, i loose all data inside the tables? > Is this normal, i've i forget something? What table types do you use? HEAP or any others? -- For technical sup

re: Installation and Configuration

On Saturday 22 February 2003 22:48, Bruce Feist wrote: > I'm a newcomer to MySQL, and I'm having trouble. I've installed MySQL > under RedHat 7.1 Linux, and I can't actually use it; I get authorization > error messages when I try. In particular, I understand that initially a > 'root' user is set

Re: CPUUsage

On Tuesday 25 Feb 2003 3:27 pm, Juan Enrique Gómez wrote: > I have a very intensive traffic MySQL server, with a average usage of > cpu of 70%, and i think is time to upgrade this machine, my questions > are about will help adding a second processor to this machine?, or mysql > will not take the ad

CPUUsage

Hi! I have a very intensive traffic MySQL server, with a average usage of cpu of 70%, and i think is time to upgrade this machine, my questions are about will help adding a second processor to this machine?, or mysql will not take the advantage of this second processor. Upgrading from 3.23.43 (cu

Trouble with db ID

Hi guys, I was wondering if you can help me or push me in the right direction with this query. I have two databases; a db of "recording_global" data and a db of "dj_global" data. What I want to do is sort the "recording_global" data by "dj_global_name" which I will source from the "dj_global" db

Re: Newbie question...

OK! Thankz... It worked. I dudn't realized that issue when i read the mySQL manual. - Original Message - From: "Simon Green" <[EMAIL PROTECTED]> To: "Mysql (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 1:45 PM Subject: FW: Newbie question... > The table type HEAP is i

RE: Replication problem (alter table fails)

Egor, I am sorry, my bad. I misrepresented the versions of mysql I am using. Must have been a typo. Here is what I am using. Master: Sparc Solaris 7 MySQL 4.0.9-gamma-log Slave: RedHat Linux 7.2 MySQL 4.0.8-gamma-log. Could you continue to help me with this ? Thanks, floyd -Original

Nearly solved - Strange Bug with a working table - Silent col-def-change !

OK, I found out, why the table grows that extraordinary. After 'CREATE TABLE new_1 SELECT * FROM output_1'; All columns of new_1 are CHAR(255) instead of VARCHAR(255) like in output_1 ( see below). Now my simple questions are: 1. Why , I saw something about silent changes in the docs,

RE: redirect mysql output to file

echo " MYSQL_STATEMENT" | mysql -u user_name -p>> /path/to/file this should work fine on command line . cheers David Ziggy Lubowa Network Engineer One2net (U) web: www.one2net.co.ug Tel: +256 41 345466 --- Every minute is an occasion to change your l

Re: Starting mysqld within SuSE 8.0

Thomas Spahni wrote: > > Starting it manually with safe_mysqld runs fine. But I didn't find a way > > in YaST to start the daemon on boot, and manually adding it to the > > /etc/init.d/boot.d/ lead me into a crash. > You may enable the start of mysql with the yast2 runlevel editor. Works > fine for

FW: Newbie question...

The table type HEAP is in MEMORY table so if you turn off or cash you loss your data. The up side is speed. Try table type = MyISAM Simon -Original Message- From: Fernando Morais [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:43 To: Simon Green Subject: Re: Newbie question... Well i

Query from a PHP Form

I have a query that is extracting records from a MySQL DB at the moment the query is just pulling 'all' records and not the selected records from a drop down :( I am using php too. the query I have is this: $result=mysql_query('select distinct items.* from items,city,category where items.CityID=

Re: table row result spool to file

Hi Thanks but I'm not getting the expected result. See the following: [quote] [EMAIL PROTECTED] godson]$ cat chk5.sh mysql -e "select * from baa into outfile \"/home/godson/run.sh\";" test [EMAIL PROTECTED] godson]$ ./chk5.sh ERROR 1045 at line 1: Access denied for user: '@localhost' (Using pass

Fw: Newbie question...

Well i've created the tables using the MySQL control center. The program that is inserting the data, is a program develop by me in delphi. But it work fines. If i insert some data and go to mySQL Control Center the data is there. All fields with no problem. I installed mySQL server in 2 diff

RE: Newbie question...

No this is not right. How are you creating the tables? How are you entering the data? Where are you putting them? e.g. /mysql/var/your_table.frm What type of table are you using? Simon -Original Message- From: Fernando Morais [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:29 To: [EMAI

Re: Starting mysqld within SuSE 8.0

On Tue, 25 Feb 2003, Markus Gerwinski wrote: > Hello, > > can someone tell me how to start mysqld at boot on a SuSE 8.0 system? > > Starting it manually with safe_mysqld runs fine. But I didn't find a way > in YaST to start the daemon on boot, and manually adding it to the > /etc/init.d/boot.d/ le

Newbie question...

Hi ppl!. I'm running Mysql Server 4.0.10 in Win XP. And every time i shutdown the service, i loose all data inside the tables? Is this normal, i've i forget something? Thankz, Nando - Before posting, please check: http

re: Replication problem (alter table fails)

On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote: > Coud you, please, give an advice to solve following problem: > > I've got two Mysql Servers: > > * Master: Sparc Solaris 8, MySQL 3.23.32 > * Slave: RedHat Linux 7.2, MySQL 3.23.32 > > Replication of data runs fine, all "in

re: BUG: Format function fails when query ordered

On Monday 24 February 2003 20:22, Karl Stubsjoen wrote: > I am reporting a bug. The format number function fails when a query is > sorted. I have included an example page to look at (the error is > reproduced here): > http://www.meetscoresonline.com/test_format.asp > > You'll see there are 2 res

Re: 4.0.10 rpm doesn't include POSTIN script

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 24 Feb 2003, Christopher Hicks wrote: > The 4.0.10 MySQL-server rpm's don't include the POSTIN script. I'm > guessing this is because of moving the server to a subpackage and the > POSTIN scripts being spec'd for the main package. It's

Re: MySQL v SAB DB

On Tue, Feb 25, 2003 at 11:29:23AM +, Richard Morton wrote: > Hi, > > My fledgling product is based around a MySQL database, my _first_ customer is > asking me to use SAB DB. Obviously this means a bit of re-engineering work and > extensive testing. I am looking for peoples experiences of SA

Re: Starting mysqld within SuSE 8.0

Hi Lutz, > The easiest way would be using Yast, then choosing System, > Runlevel-Editor. There you find Runlevel-Properties > ("Runlevel-Eigenschaften" if you choose German Language for Yast). In > the upcoming window for the services ("Dienste") you can set markers, at > which runlevels mysql sho

Replication problem (alter table fails)

Dear gurus, Coud you, please, give an advice to solve following problem: I've got two Mysql Servers: * Master: Sparc Solaris 8, MySQL 3.23.32 * Slave: RedHat Linux 7.2, MySQL 3.23.32 Replication of data runs fine, all "insert into" and "delete from" made on master successfully change the

Re: How do I select 'all related' in a many-to-many relation?

Harald Fuchs wrote: > That's easy: [Excellent MySQL code example snipped] Thanks, that was exactly what I was looking for. /mac - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://li

MySQL v SAB DB

Hi, My fledgling product is based around a MySQL database, my _first_ customer is asking me to use SAB DB. Obviously this means a bit of re-engineering work and extensive testing. I am looking for peoples experiences of SAP DB, so that I can build a case for continueing with MySQL, (other than

Problem with MySQL, MyODBC, Access 2002 and Japanese.

Help!, I am developing a multilingual site in English, Spanish and Japanese. I am using MySQL with PHP in the server side, and Access 2002 in the local side, using MyODBC to communicate MySQL with Access 2002. MySQL and PHP works toguether ok in Japanese, English and Spanish (using EUC_JP in both

table row result spool to file

Hi I need to create a file from the row of a table. I have done the following but it does not create a file but only display it on screen. What am I missing? Thanks. [EMAIL PROTECTED] godson]$ mysql -e "select * from baa;" --pager=t.sh test +--

Re: Starting mysqld within SuSE 8.0

Hi Markus, > can someone tell me how to start mysqld at boot on a SuSE 8.0 system? > Starting it manually with safe_mysqld runs fine. But I didn't find a way > in YaST to start the daemon on boot, and manually adding it to the > /etc/init.d/boot.d/ lead me into a crash. The easiest way would be us

Starting mysqld within SuSE 8.0

Hello, can someone tell me how to start mysqld at boot on a SuSE 8.0 system? Starting it manually with safe_mysqld runs fine. But I didn't find a way in YaST to start the daemon on boot, and manually adding it to the /etc/init.d/boot.d/ lead me into a crash. Thanks in advance, Markus ---

error 2003

hi listers i have a c program that connects to a myssql db. for some reason or another, every now and again i get the following error message ERROR in mysql_real_connect() Number: 2003 Message: Can't connect to MySQL server on 'softdistqa' (10048) i find enough info on mysql website about

RE: Problem with unique index on InnoDB

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Harald Fuchs > Sent: Tuesday, February 25, 2003 10:52 AM > To: [EMAIL PROTECTED] > Subject: Re: Problem with unique index on InnoDB > > The second record is different because it has another model_id

È«ÃæÖ§³ÖJSP/ASP/PHP/ASP.NETÆóÒµ½¨Õ¾¿Õ¼ä³ÏÑû´úÀí.

È«ÃæÖ§³ÖJSP/ASP/PHP/ASP.NETÆóÒµ½¨Õ¾¿Õ¼ä³ÏÑû´úÀí. ÎÒ˾ÍƳöÆóÒµ½¨Õ¾×¨Óÿռ䣬ȫÃæÖ§³ÖJSP¡¢ASP¡¢PHP¡¢ASP.NET£¬ÏÖÕýÃæÏòÈ«¹ú¸÷µØ³ÏÑû´úÀí£¬ÀûÈó¿É´ï40%£¡ * ÉêÇëʱ´´ÍøÂçµÄ´úÀí£¬³ýÁË¿ÉÒÔÏíÊÜÈ«·½Î»µÄ»¥ÁªÍø²úÆ··þÎñ£¬»¹¿ÉÒÔÃâ·Ñ»ñµÃÓòÃû¡¢¿Õ¼ä¡¢ÖÇÄܽ¨Õ¾¡¢¶¯Ì¬IPµÈµÄÔÚÏß×¢²á´úÂ룬·½±ãÄú¼°Ê±¿ªÕ¹ÒµÎñ¡£ * Ìṩ

Re: MySQL codes

On Mon, Feb 24, 2003 at 07:37:21PM -0800, DiAnNe iRiS aLeRta wrote: > i am to make a feature for mysql which is horizontal aggregation for our thesis. > > is this existing already? if not, is vertical aggregation existing? > can you show me the codes for it? i need it to have a basis for > develo

Re: Large table or several tables ?

gregory lefebvre wrote: Hye the list, There is my problem. I have to register about 400 large arrays (~1 lines each) in my MySQL database and I don't know which of the following choices is better. Either create a large tables as a stack, which contains all arrays Either create as many tables

Re: Start MySQL along with a update statement.

On Tue, Feb 25, 2003 at 01:30:52AM -0500, g gnanaraj wrote: > I need to start MySQL using a script which does the following: > > 1. login to MySQL > 2. use a specific database > 3. run a update statement > 4. exit > > > I have been able to achieve 1 & 2 by doing the following but not the others.

IIC¿µ·ðÂ×˹2003ÉϺ£ÑÐÌÖ»á

IIC Conference尊敬的贵宾(mysql)您好:  冒昧打扰，祈请见谅！以下是关于IIC Conferences上海最新研讨会的信息，分别将于2003年2月26-27日、3月6-7日、3月26日、4月9-10日在上海斯波特酒店举办。详情请进入以下连接：  【2003品牌行销与管理研讨会】http://www.iicconferences.com/sh200303.htm 【连锁加盟经营与管理研讨会】 http://www.iicconferences.com/sh200304.htm 【整合行销传播研讨会】http://www.iicconferen

Problem with unique index on InnoDB

Hello group, My table look like this: CREATE TABLE `mda_models` ( `model_id` int(10) NOT NULL auto_increment, `make_id` int(10) NOT NULL default '0', `model_name` varchar(100) NOT NULL default '', `model_phase` varchar(100) default NULL, `model_phase_no` int(4) default NULL, `model_man