how to create table with unique 2 column tuple
Hello, I'm trying to create a table with columns A, B, C, D such that values in columns A and B are not unique but if you consider them as a paired tuple, then for every row, value in col A, value in col B is unique. Furthermore, I'd like to create a index to use for searching through the database using this unique paired tuple. Does anyone know how to do this without actually merging columns A and B together? Thanks. - 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: how to create table with unique 2 column tuple
ALTER TABLE tblname ADD UNIQUE (column1, column2); The index will automatically be used if you use it in your WHERE clause in that order. If you want to do fulltext searching on those columns, repeat the query with FULLTEXT in place of UNIQUE. Hello, I'm trying to create a table with columns A, B, C, D such that values in columns A and B are not unique but if you consider them as a paired tuple, then for every row, value in col A, value in col B is unique. Furthermore, I'd like to create a index to use for searching through the database using this unique paired tuple. Does anyone know how to do this without actually merging columns A and B together? Thanks. - 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
Perl DBI Error 19
I am having trouble with DBI. I wrote a little script that should update fields in one table (uid_test) based on values in another table (merge). I updates one row and then dies with: os prompt: blah blah 1 1011877 101 Error during processing for table uid_test Error 19 (fetch() without execute()) The selected values (primary_id, other_id) are both INT(12) and so are the fields of the target table (superceded_by, uid_new). Please have a look at the Perl code snippet below. As I said it works for the first row. BTW if there is pure sql code that would do the job, I would be delighted to learn about. Thanks Hannes -snippet- #issue query $sth = $dbh-prepare ( SELECT primary_id, other_id FROM merge ORDER BY other_id ) or bail_out (Cannot prepare query from merge); $sth-execute () or bail_out (Cannot execute query from merge); while (@ary = $sth-fetchrow_array ()) { $counter++; my ($primary_id) = $ary[0]; my ($other_id) = $ary[1]; print $counter\t$primary_id\t$other_id\n; #update the data in the target table $sth = $dbh-prepare ( UPDATE $table_name SET superceded_by=$primary_id, status=\'1\', time=null WHERE uid_new=$other_id ) or bail_out (Cannot prepare sql (UPDATE $table_name)!); $sth-execute () or bail_out (Cannot execute sql(UPDATE $table_name)!); } if (!defined($DBI::err)) { print $counter sequences retrieved from table merge, cleaned out and successfully updated in table niedner.$table_name.\n; }else {bail_out (Error during processing for table $table_name\n); } #clean up $sth-finish () or bail_out (Cannot finish query from database); $dbh-disconnect () or bail_out (Cannot disconnect from database); exit (0) --snippet end - 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: Interupting client-server-link during longlasting queries
Hannes Niedner writes: Thanks Sinisa, So is there any command suffix in mysql that sends the query in the background (letting the server doing the query without talking back to the client) like using the on the unix commandline - resulting in any query being completed after quitting the client. Hannes No, but you can use any of the multithreaded clients available, like mysqlgui. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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:Multiple transactions with innodb
Hi! When you issue a consistent read, that is, an ordinary SELECT statement, InnoDB will give your transaction a timepoint according to which your query sees the database. Thus, if transaction B deletes a row and commits after your timepoint was assigned, the you will not see the row deleted. Similarly with inserts and updates. You can advance your timepoint by committing your transaction and then doing another SELECT. This is called multiversioned concurrency control. User A User B set autocommit=0; set autocommit=0; time | SELECT * FROM t; | empty set | INSERT INTO t VALUES (1, 2); | vSELECT * FROM t; empty set COMMIT; SELECT * FROM t; empty set; COMMIT; SELECT * FROM t; -- | 1|2 | -- Thus user A sees the row inserted by B only when B has committed the insert, and A has committed his own transaction so that the timepoint is advanced past the the commit of B. If you want to see the 'freshest' state of the database, you should use a locking read: SELECT * FROM t LOCK IN SHARE MODE; The advantage in multiversioning is that consistent reads do not set any locks. See also the manual at http://www.innodb.com. Hope this clarifies the issue. Heikki Tuuri Innobase Oy Copied message: ... Hello, does InnoDB fully supports multiple transactions ? ie = transactions over several tables with multiple connexions. My problem is that I do not get a consistent view of the tables after = the inserts or delete : records are missing, or seem to be still =present. - 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
Can't connect throught over server.
Hi, I am not able to connect mysql server through other machine in a network. I have already assign the user using the command of Grant all on *.* to user@ipaddress identified by password. Then, try to connect using mysql -u user@ipaddress -h firstserver -ppassword.But, I got the following error. Warning: MySQL Connection Failed: Can't connect to MySQL server on 'dns1.3dsources.com' (111) in /home/trade-revenues/require/password.php on line 1 Thank you Mark - 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
Can't connect error 111
Hi, I am not able to connect mysql server through other machine in a network. I have already assign the user using the command of Grant all on *.* to user@ipaddress identified by password. Then, try to connect using mysql -u user@ipaddress -h firstserver -ppassword.But, I got the following error. Warning: MySQL Connection Failed: Can't connect to MySQL server on 'dns1.3dsources.com' (111) in /home/trade-revenues/require/password.php on line 1 oh I forgot to tell, I have used a firewall ipchains. what port do I have to open for mysql: tcp or udp Thank you Mark - 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
InnoDB not enabled
Hi I was going to use innodb table handler so i have downloaded "mysql-max-3.23.38-win.zip" because there was said that max installation contains innodb table handler. After intallation I have disabled innodb tables and when i write "select version();" i get 3.23.37 ("mysql-max-3.23.38-win.zip" ). What do I have to do to get innodb? Tomek
bind to specific address
Hi, How to bind mysql to specific address if I am using my.cnf file. etc. [mysqld] --bind-address=xxx.xxx.xxx.xxx Is the above syntax correct ?? Thanks Mark - 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: Can't connect error 111
Hi, I am not able to connect mysql server through other machine in a network. I have already assign the user using the command of Grant all on *.* to user@ipaddress identified by password. Then, try to connect using mysql -u user@ipaddress -h firstserver -ppassword.But, I got the following error. Warning: MySQL Connection Failed: Can't connect to MySQL server on 'dns1.3dsources.com' (111) in /home/trade-revenues/require/password.php on line 1 Hi, I am not able to connect mysql server through other machine in a network. I have already assign the user using the command of Grant all on *.* to user@ipaddress identified by password. Then, try to connect using mysql -u user@ipaddress -h firstserver -ppassword.But, I got the following error. Warning: MySQL Connection Failed: Can't connect to MySQL server on 'dns1.3dsources.com' (111) in /home/trade-revenues/require/password.php on line 1 You tried to connect using the mysql client, and got an error from... php... Try mysql -u user -h firstserver -ppassword, the @ipaddress is your own ip address and is automatically detected, it is NOT part of the username. oh I forgot to tell, I have used a firewall ipchains. what port do I have to open for mysql: tcp or udp Port 3306, tcp. - 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: bind to specific address
Hi, How to bind mysql to specific address if I am using my.cnf file. etc. [mysqld] --bind-address=xxx.xxx.xxx.xxx Is the above syntax correct ?? Close. [mysqld] bind-address=xxx.xxx.xxx.xxx - 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 to .php
hey, i have some sql to create the tables for my small database in a text file at home i can use sql batch mode to runt he sql commands from this text file. id like to take this sql code and run it on the mysql server at my free webhost, but i dont think i can connect to their mysql server with a client. i think the only way to get the sql code from my text file to run on the remote server is if i make a .php file and re-do everything with php stuff wrapped around it. is there a program that will take my text file of sql commands and turn it into a .php file for running, or is there another easy way to do this, other than making the .php :| thanks - Josh [EMAIL PROTECTED] - 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: ACCESS DB, and MySQL which one better to handle database driv en webpage
Just to balance out the conversation, a couple years ago we had developed an e-commerce site which was to be prototyped in Access, then moved to SQL Server for production. The client decided that they didn't want to pay for the move to SQL Server, so we launched with Access as the backend. The database had tables containing from several hundred records, to over 100,000 records. The site grew in popularity and regularly recieved 10s of thousands of page views per day, each page having up to 10 or 15 database queries. Before moving to MS SQL Server a year later, we never had a single problem with Access. Not one. Now, that's not *huge* traffic, and I wouldn't recommend trying it today, but it certainly suprised me. -- Jack Baty Fusionary Media -- Original Message -- From: Tyrone Mills [EMAIL PROTECTED] Date: Fri, 22 Jun 2001 11:43:51 -0700 Sounds like you could be a reference site for Microsoft!! Only 2 corruptions using Access multi-user. That's incredibly good. I've supported systems with only 3 concurrent users who suffered corruption on a nearly daily basis. - Original Message - From: John Meyer [EMAIL PROTECTED] To: MySQL (E-mail) [EMAIL PROTECTED] Sent: Friday, June 22, 2001 10:16 AM Subject: Re: ACCESS DB, and MySQL which one better to handle database driv en webpage It only corrupted your database twice? On Friday 22 June 2001 09:50, Patrick Calkins wrote: MySQL can handle infinately more concurent connections to it, and handle a much bigger load than MDB can even dream of doing. A few years back I used to write database apps in visual basic and MDB. It was running on the network, with only about 5 people accessing it at one time. MDB had corrupted the files at least twice. - 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
Re:InnoDB not enabled
Tomek, have you defined the InnoDB startup options in your my.cnf or my.ini? You can look at the manual at http://www.innodb.com about example settings for InnoDB in Windows. Did you compile MySQL yourself or are you using one of the binaries in the binary distribution? MySQL -Max 3.23.39 is already out, but right now I am not able to access the front page of the MySQL website www.mysql.com, where you could download the latest version. Regards, Heikki Copied message: . Hi I was going to use innodb table handler so i have downloaded = mysql-max-3.23.38-win.zip because there was said that max installation = contains innodb table handler. After intallation I have disabled innodb = tables and when i write select version(); i get 3.23.37 = (mysql-max-3.23.38-win.zip ). What do I have to do to get innodb? Tomek - 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: InnoDB not enabled
is already out, but right now I am not able to access the front page of the MySQL website www.mysql.com, where you could download the latest version. Try here: http://mysql.ht.net.tw/mirrors.html - 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
Indexing only a prefix of the string
If I have a table: CREATE TABLE film ( title CHAR(200) NOT NULL, INDEX title_index (title(5)) ); What is the underlaying reason why it is faster to index only a prefix of the title? Is it always faster? even if i have a trillions of title 200 characters long? what should i think of when deciding of the prefixes' length? thanks! --- Daniel Åkerud [ Don't underestimate the power of stupid people in large groups]
MyODBC through ADO
I am working to develope a software package using MS Visual Basic and MySQL, and so I want know about connnecting MyODBC through ADO (ActiveX Data Object) of VB. The format for ODBC connectivity through ADO is like :: == ' ' Open a connection without using a Data Source Name (DSN). ' Set cnn1 = New ADODB.Connection ' cnn1.ConnectionString = driver={SQL Server};server=bigsmile;uid=sa;pwd=pwd;database=pubs ' cnn1.ConnectionTimeout = 30 ' cnn1.Open ' ' Open a connection using a DSN and ODBC tags. ' Set cnn2 = New ADODB.Connection ' cnn2.ConnectionString = DSN=Pubs;UID=sa;PWD=pwd; ' cnn2.Open ' ' Open a connection using a DSN and OLE DB tags. ' Set cnn3 = New ADODB.Connection ' cnn3.ConnectionString = Data Source=Pubs;User ID=sa;Password=pwd; ' cnn3.Open ' ' Open a connection using a DSN and individual ' ' arguments instead of a connection string. ' Set cnn4 = New ADODB.Connection ' cnn4.Open Pubs, sa, pwd ' Display the state of the connections. ' MsgBox cnn1 state: GetState(cnn1.State) vbCr _ ' cnn2 state: GetState(cnn2.State) vbCr _ ' cnn3 state: GetState(cnn3.State) vbCr _ ' cnn4 state: GetState(cnn4.State) ' Open a connection using a DSN and ODBC tags. ' cnn4.Close ' cnn3.Close ' cnn2.Close ' cnn1.Close ' End Sub (Source MSDN). First I'l install the MySQL in a remote NT server and also MyODBC in Client machine. Then I'll create a File DSN using MyODBC. Now what Provider name (eg For Oracle MSDAORA) and ConnectString should I give ?
RE: sql to .php
Try phpMyAdmin to upload the .sql file in your Database you can get phpMyAdmin @ http://www.phpwizard.net -Original Message- From: Aek [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 24, 2001 5:37 PM To: [EMAIL PROTECTED] Subject: sql to .php hey, i have some sql to create the tables for my small database in a text file at home i can use sql batch mode to runt he sql commands from this text file. id like to take this sql code and run it on the mysql server at my free webhost, but i dont think i can connect to their mysql server with a client. i think the only way to get the sql code from my text file to run on the remote server is if i make a .php file and re-do everything with php stuff wrapped around it. is there a program that will take my text file of sql commands and turn it into a .php file for running, or is there another easy way to do this, other than making the .php :| thanks - Josh [EMAIL PROTECTED] - 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
Re: mysql Digest 24 Jun 2001 00:58:59 -0000 Issue 1353
Does anyone have any recommendations for a good book on MySQL SQL? What about PerlDBI (I noticed that the O'Reilly one is over a year old)? Stay as far away from the O'Reilly book as possible. MySQL and mSQL was really just an mSQL book until a few months before publication when O'Reilly noticed that MySQL was far more popular at that time, so they scrambled and tossed in some stuff for MySQL. It's one of the few O'Reilly books in my collection that was a big disappointment. The *best* book on MySQL that I have ever seen is MySQL by Paul Dubois (New Riders, publisher). Amazon link: http://www.amazon.com/exec/obidos/ASIN/0735709211/o/qid=993401518/sr=2-1/ref=aps_sr_b_1_1/102-6228011-7382510 Paul has a new book that should be available shortly (Amazon says August 13) titled MySQL and Perl for the Web that covers both MySQL and perl (DBI). Having read it, I would say that this book is an excellent tutorial type book that will go hand in hand with MySQL (a reference book) mentioned previously. Amazon.com's link for MySQL and Perl for the Web: http://www.amazon.com/exec/obidos/ASIN/0735710546/qid=993401594/sr=1-6/ref=sc_b_6/102-6228011-7382510 P.S. I would have given bookpool.com links since they usually have better prices, however their site appears to be down this morning. If you are going to buy your books online, I would suggest visiting bookpool.com first. -Bill - 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: bind to specific address
Mark Lo wrote: Hi, How to bind mysql to specific address if I am using my.cnf file. etc. [mysqld] --bind-address=xxx.xxx.xxx.xxx Is the above syntax correct ?? Thanks Mark Hi, I am using : [mysqld] bind-address=xxx.xxx.xxx.xxx in my own /etc/my.cnf, and it works. Regards -- Joseph Bueno NetClub/Trader.com - 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: configure question
But the INSTALL-SOURCE file you get after unzipping the tarred file says you can. And I have been using it the same way as listed there with success on a Red Hat 6.2 machine. Raju This is _not_ a recommended way to use it on a Red Hat Linux system. Get the srpm and do a rpm --rebuild of it (or just get the binary RPMs), and do service mysqld start. -- Trond Eivind Glomsrød Red Hat, Inc. - 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
Re: configure question
[EMAIL PROTECTED] writes: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: This filter is annoying... it's the second time in a few days it rejects valid replies. This answer contains sql without adding value. But the INSTALL-SOURCE file you get after unzipping the tarred file says you can. That doesn't make it the way I would recommend... we deliver it set up a specific way (obviously outside /usr/local), and making it witha similar setup to the one we ship is what I would recommend. -- Trond Eivind Glomsrød Red Hat, Inc. -- Trond Eivind Glomsrød Red Hat, Inc. - 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: mysql Digest 24 Jun 2001 00:58:59 -0000 Issue 1353
You might want to try: http://www1.fatbrain.com/search/searchresults.asp?SearchFunction=keyqtext=m ysql+perlSubmit.x=11Submit.y=11 Fatbrain has it at $35.99 (20% off list). Amazon has it at $44.99. Frank -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 24, 2001 12:56 PM To: [EMAIL PROTECTED] Cc: Chris Petersen Subject: Re: mysql Digest 24 Jun 2001 00:58:59 - Issue 1353 Does anyone have any recommendations for a good book on MySQL SQL? What about PerlDBI (I noticed that the O'Reilly one is over a year old)? Stay as far away from the O'Reilly book as possible. MySQL and mSQL was really just an mSQL book until a few months before publication when O'Reilly noticed that MySQL was far more popular at that time, so they scrambled and tossed in some stuff for MySQL. It's one of the few O'Reilly books in my collection that was a big disappointment. The *best* book on MySQL that I have ever seen is MySQL by Paul Dubois (New Riders, publisher). Amazon link: http://www.amazon.com/exec/obidos/ASIN/0735709211/o/qid=993401518/sr=2-1/ref =aps_sr_b_1_1/102-6228011-7382510 Paul has a new book that should be available shortly (Amazon says August 13) titled MySQL and Perl for the Web that covers both MySQL and perl (DBI). Having read it, I would say that this book is an excellent tutorial type book that will go hand in hand with MySQL (a reference book) mentioned previously. Amazon.com's link for MySQL and Perl for the Web: http://www.amazon.com/exec/obidos/ASIN/0735710546/qid=993401594/sr=1-6/ref=s c_b_6/102-6228011-7382510 P.S. I would have given bookpool.com links since they usually have better prices, however their site appears to be down this morning. If you are going to buy your books online, I would suggest visiting bookpool.com first. -Bill - 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
Compiling MySQL 3.23.39 on HP-UX 11.00.
Hi! Jack == Jack Challen [EMAIL PROTECTED] writes: Jack Hi, Jack First of all, this is irrelevant if you're not using HP-UX. Jack Second, apologies if this isn't the correct list, but I've been unable Jack to find Jack a more suitable one. Jack This is just some info on how I got Mysql-3.23.39 to compile on HP-UX Jack 11.00 using gcc, Jack because I think the configure script may have broken somewhere between Jack 3.23.35 and Jack 3.23.39 Jack Hope this is of some use to someone Jack Compiling MySQL 3.23.39 on HP-UX 11.00 with gcc Jack Notes: Jack -- Jack You'll need to fix /usr/include/sys/unistd.h - See the MySQL manual Jack section 4.2.17 Jack (Beware: Patch PHKL_22589 Breaks this again) Jack System: Jack --- Jack HP-UX 11.00 Jack gcc 2.95.3 Jack binutils 2.11 Jack GNU make 3.79 Jack Configure Command: Jack -- Jack CFLAGS=-D_REENTRANT Jack CXXFLAGS=-D_REENTRANT \ Jack ./configure Jack --prefix=/opt/mysql Jack \ Jack --with-pthread Jack --with-named-thread-libs=-lpthread \ Jack --with-mysqld-ldflags=-L/opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/2.95.3 Jack -lgcc \ Jack --with-client-ldflags=-L/opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/2.95.3 Jack -lgcc Why do you need to include the path to libgcc ? Normally this is an indication that something is wrong. Jack MySQL Source Changes: Jack - Jack ### I believe these could be fixed just by corrected the configure Jack script tests, Jack ### as they're all #ifdef tests Jack edited readline/nls.c to unconditionally #include locale.h Jack edited libmysql/libmysql.c to unconditionally #include pwd.h Jack edited mysys/mf_pack.c to unconditionally #include pwd.h Jack edited include/global.hto unconditionally #include stdlib.h configure should test for the above include files and use these if they exist on your system. Have you any idea why configure didn't include these on your system? I have myself compiled MySQL on HPUX 11.0 with just ./configure and I didn't get any compile errors. cut Regards, Monty - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql Digest 24 Jun 2001 00:58:59 -0000 Issue 1353
Here it is at bookpool.com (my favorite source for tech books) for $31.95 http://www.bookpool.com/.x/nqmc5ymle4/sm/0735709211 And an interesting one on PHP and MySQL that I haven't seen 'reviewed' yet... http://www.bookpool.com/.x/nqmc5ymle4/sm/0672317842 - Original Message - From: Frank J. Schmuck [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: Chris Petersen [EMAIL PROTECTED] Sent: Sunday, June 24, 2001 12:25 PM Subject: RE: mysql Digest 24 Jun 2001 00:58:59 - Issue 1353 You might want to try: http://www1.fatbrain.com/search/searchresults.asp?SearchFunction=keyqtext=m ysql+perlSubmit.x=11Submit.y=11 Fatbrain has it at $35.99 (20% off list). Amazon has it at $44.99. Frank -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 24, 2001 12:56 PM To: [EMAIL PROTECTED] Cc: Chris Petersen Subject: Re: mysql Digest 24 Jun 2001 00:58:59 - Issue 1353 Does anyone have any recommendations for a good book on MySQL SQL? What about PerlDBI (I noticed that the O'Reilly one is over a year old)? Stay as far away from the O'Reilly book as possible. MySQL and mSQL was really just an mSQL book until a few months before publication when O'Reilly noticed that MySQL was far more popular at that time, so they scrambled and tossed in some stuff for MySQL. It's one of the few O'Reilly books in my collection that was a big disappointment. The *best* book on MySQL that I have ever seen is MySQL by Paul Dubois (New Riders, publisher). Amazon link: http://www.amazon.com/exec/obidos/ASIN/0735709211/o/qid=993401518/sr=2-1/ref =aps_sr_b_1_1/102-6228011-7382510 Paul has a new book that should be available shortly (Amazon says August 13) titled MySQL and Perl for the Web that covers both MySQL and perl (DBI). Having read it, I would say that this book is an excellent tutorial type book that will go hand in hand with MySQL (a reference book) mentioned previously. Amazon.com's link for MySQL and Perl for the Web: http://www.amazon.com/exec/obidos/ASIN/0735710546/qid=993401594/sr=1-6/ref=s c_b_6/102-6228011-7382510 P.S. I would have given bookpool.com links since they usually have better prices, however their site appears to be down this morning. If you are going to buy your books online, I would suggest visiting bookpool.com first. -Bill - 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
Re: Good book for MySQL and Perl DBI?
Does anyone have any recommendations for a good book on MySQL SQL? What about PerlDBI (I noticed that the O'Reilly one is over a year old)? Just realizing that there's so much out there that I haven't been told... -Chris Paul Dubois and New Riders are releasing 'MySQL and Pearl for the Web'. If that's what you're interested in, the book is due at the end of July. There's a little information about the book at www.newriders.com. I'm going through a review copy and it looks pretty good. The publisher said that I could say that. :) Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sql query 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
LOAD DATA INFILE + NULL
I get *.csv file like this (1 string) : 7,'Markovic Stevo','NULL','NULL' When I use LOAD DATA INFILE syntax I get word NULL in field (MySQL table) q: I want field to be empty (in table), where the NULL is (in *.csv), how? tomaz, Slovenia
Re: LOAD DATA INFILE + NULL
Drop the quotes (') arround the NULL e.g.: 7,'Markovic Stevo',NULL,NULL Clive Smart WEBServ TomazSa wrote: I get *.csv file like this (1 string) : 7,'Markovic Stevo','NULL','NULL' When I use LOAD DATA INFILE syntax I get word NULL in field (MySQL table) q: I want field to be empty (in table), where the NULL is (in *.csv), how? tomaz, Slovenia - 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: LOAD DATA INFILE + NULL
wow, that was fast, tnx (new on this m. list) why was mysql.com down for 2 days (or more)? lp, tomaz
Re: LOAD DATA INFILE + NULL
At 2:00 AM +0200 6/25/01, c.smart wrote: Drop the quotes (') arround the NULL e.g.: 7,'Markovic Stevo',NULL,NULL No. To load a NULL value into a column using LOAD DATA, you must use \N. NULL, with or without quotes, will insert as the word NULL. Clive Smart WEBServ TomazSa wrote: I get *.csv file like this (1 string) : 7,'Markovic Stevo','NULL','NULL' When I use LOAD DATA INFILE syntax I get word NULL in field (MySQL table) q: I want field to be empty (in table), where the NULL is (in *.csv), how? tomaz, Slovenia -- Paul DuBois, [EMAIL PROTECTED] - 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: Good book for MySQL and Perl DBI?
At 5:38 PM -0400 6/24/01, Bob Hall wrote: Does anyone have any recommendations for a good book on MySQL SQL? What about PerlDBI (I noticed that the O'Reilly one is over a year old)? Just realizing that there's so much out there that I haven't been told... -Chris Paul Dubois and New Riders are releasing 'MySQL and Pearl for the Web'. If that's what you're interested in, the book is due at the end of July. There's a little information about the book at www.newriders.com. I'm going through a review copy and it looks pretty good. The publisher said that I could say that. :) Yes, but publishers will always be in favor of people saying their books are good. :-) The book's not out yet, as Bob says, but the code used for examples in the book is available now, at: http://www.kitebird.com/mysql-perl/ Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sql query database -- Paul DuBois, [EMAIL PROTECTED] - 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: configure question
Sincerely, Trond, don't u feel that making such special provisions would limit the distribution of packages ? IMHO we should be working out to make a unified system capable of delivering the same efficiency while using packages packaged in any format. Raju sql, database - added to avoid rejection - Webmasters please note. - Original Message - From: Trond Eivind Glomsrød [EMAIL PROTECTED] To: CK Raju [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Sunday, June 24, 2001 11:31 PM Subject: Re: configure question On Sun, 24 Jun 2001, CK Raju wrote: But the INSTALL-SOURCE file you get after unzipping the tarred file says you can. That doesn't make it the way I would recommend... we deliver it set up a specific way (obviously outside /usr/local), and making it witha similar setup to the one we ship is what I would recommend. -- Trond Eivind Glomsrød Red Hat, Inc. - 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
conflicts with new version
I am trying to reinstall mysql on a cobalt server I removed the first version but when I go to install the new version I get this message below saying it conflicts with another version could you tell me how I can correct this. I have looked through the entire directory structure and can not find any other files that relate to mysql file /etc/logrotate.d/mysql from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /etc/rc.d/init.d/mysql from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/isamchk from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/isamlog from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/mysql_install_db from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/mysql_zap from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 Best regards, Richard mailto:[EMAIL PROTECTED] - 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
how to prevent inserting duplicate rows?
Hello, I have a table where for each row, the column 1, column 2 tuple is unique (when creating the table, i did a UNIQUE INDEX index1 (col1, col2)) I wrote a perl program to read lines from a file and insert accordingly into the table. How do I prevent insertions of duplicates? (as in during the insertion loop, if duplicates exists do not insert but carry on with the rest of the file) On a similar note, how do I OVERWRITE the previous entry in the table? ie. is there a SQL command to do like INSERT, but if duplicate found, overwrite with the new value. THanks. - 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
deleting a table
Hi, I need to delete a table from a database. I looked through the manual, but it's not listed in the table of content. Thank you for your help. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - 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: deleting a table
connect to your database by mysql -p your_db_name then type drop table your table name; On Sun, 24 Jun 2001, ricky gonzalez wrote: Hi, I need to delete a table from a database. I looked through the manual, but it's not listed in the table of content. Thank you for your help. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - 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
Re: configure question
(sql to fool bad filter... why not just require that posters are subscribed?) Nisha Raju [EMAIL PROTECTED] writes: Sincerely, Trond, don't u feel that making such special provisions would limit the distribution of packages ? There are some options which can't be the same: File locations, to give one example. A sysadmin compiling his own package will typically put it in /usr/local. A distributor, OTOH, isn't allowed to touch this location (FHS). Thus, if you just do a configure you won't upgrade an existing location, you'll get another separate installation. By getting the RPMs, you'll know you'll get the correct paths and the package managed by the package system on your OS. You'll also know that scripts etc. have been tweaked to fit exactly with this system. -- Trond Eivind Glomsrød Red Hat, Inc. - 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: deleting a table
On Sun, 24 Jun 2001 21:06:16 -0700 (PDT), ricky gonzalez [EMAIL PROTECTED] wrote: DROP TABLE table_name; Hi, I need to delete a table from a database. I looked through the manual, but it's not listed in the table of content. Thank you for your help. Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - 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
started over! root and user pw (easy questions?)
where in the manual does it explain how to set up the root password after an install? i understand that should be the first thing done. as the admin of mysql on my server, should the only method i use to login be by root and said password? OR should i make another username/password for myself with full privileges? TIA - 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: deleting a table
hallo mailinglist! With reference to Yee Chuan Loh on 25.06 00:11: connect to your database by mysql -p your_db_name then type drop table your table name; this i want to know too. thanx! Hi, I need to delete a table from a database. I looked through the manual, but it's not listed in the table of content. Thank you for your help. -- Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - 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: MyODBC through ADO
Hi there I am using the same setup as yourself, but developing with MYVBQL.dll which is a DLL that some kind fella put together for dummies like me. Works well and very similar to ADO, couple bugs that I have picked up, but there are workarounds. Check the MYSQL web site for the download. Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Nipanjan Gupta Rajan Sent: 24 June 2001 10:37 To: [EMAIL PROTECTED] Subject: MyODBC through ADO I am working to develope a software package using MS Visual Basic and MySQL, and so I want know about connnecting MyODBC through ADO (ActiveX Data Object) of VB. The format for ODBC connectivity through ADO is like :: == ' ' Open a connection without using a Data Source Name (DSN). ' Set cnn1 = New ADODB.Connection ' cnn1.ConnectionString = driver={SQL Server};server=bigsmile;uid=sa;pwd=pwd;database=pubs ' cnn1.ConnectionTimeout = 30 ' cnn1.Open ' ' Open a connection using a DSN and ODBC tags. ' Set cnn2 = New ADODB.Connection ' cnn2.ConnectionString = DSN=Pubs;UID=sa;PWD=pwd; ' cnn2.Open ' ' Open a connection using a DSN and OLE DB tags. ' Set cnn3 = New ADODB.Connection ' cnn3.ConnectionString = Data Source=Pubs;User ID=sa;Password=pwd; ' cnn3.Open ' ' Open a connection using a DSN and individual ' ' arguments instead of a connection string. ' Set cnn4 = New ADODB.Connection ' cnn4.Open Pubs, sa, pwd ' Display the state of the connections. ' MsgBox cnn1 state: GetState(cnn1.State) vbCr _ ' cnn2 state: GetState(cnn2.State) vbCr _ ' cnn3 state: GetState(cnn3.State) vbCr _ ' cnn4 state: GetState(cnn4.State) ' Open a connection using a DSN and ODBC tags. ' cnn4.Close ' cnn3.Close ' cnn2.Close ' cnn1.Close ' End Sub (Source MSDN). First I'l install the MySQL in a remote NT server and also MyODBC in Client machine. Then I'll create a File DSN using MyODBC. Now what Provider name (eg For Oracle MSDAORA) and ConnectString should I give ? - 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: conflicts with new version
-Original Message- From: Richard Kurth [mailto:[EMAIL PROTECTED]] I am trying to reinstall mysql on a cobalt server I removed the first version but when I go to install the new version I get this message below saying it conflicts with another version could you tell me how I can correct this. I have looked through the entire directory structure and can not find any other files that relate to mysql file /etc/logrotate.d/mysql from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /etc/rc.d/init.d/mysql from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/isamchk from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/isamlog from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/mysql_install_db from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/mysql_zap from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 [ snipped for brevity ] Richard, obviously, you used rpm (or similar) to install 3.22.32-1. you also treid to re-install 3.23.39-1 with rpm (or similar). If so, please do a rpm -f mysql.rpm. This will freshen your current installation, and removes the 3.22.32-1 references from the rpmdb. For more information, please visit man rpm. Cheers, Guus - 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