Administrator Software
The English version of KaneyanMySQLAdmin currently exhibited in Japan was made. Please use, although it does not know whether to operate normally since there is no English development environment. This software is free software. http://sql.jnts.ne.jp/english/ http://database.jnts.ne.jp/download/KMYENG113.lzh #If it can do, I want you to introduce by Contributed software of MySQl Site. #Is it useless? -- Kaneyan mailto:[EMAIL PROTECTED] Join Ntwaork Total Service, - 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: default password?
Do not include "-p". Then it won't ask you a password David Loszewski wrote: After intsalling mysql is there a default password assigned to root? I type "./mysqladmin -u root -p password 'new-password'" Well, I don't know what the old/default password is deermind for the american How do I fix it? thx, DAVE - 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 -- Guray Sunamak \\\|/// [EMAIL PROTECTED] \\ - - // computer turtle @Samtek-Itc Ankara/Turkey ( 0 0 ) ICQ# 73827870 -oOOo-(_)-oOOo-
Cant't connect through /var/lib/mysql/mysql.sock
Hi My PHP Websites all terminate with that error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in lib.inc.php on line 255 I already set User rights, but what can i do against that. On my CGI modules that error occurs: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Apache/1.3.12 Server at dbtest Port 80 PLEASE HELP ME!! mfg, andy --- In memoriam - Jacques Olivier Plasevisit www.amdclan.de/jaques --- - 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: Cant't connect through /var/lib/mysql/mysql.sock
On 14 Apr 2001 09:56:41 +0200, Andreas Iwanowski wrote: Hi My PHP Websites all terminate with that error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in lib.inc.php on line 255 I already set User rights, but what can i do against that. Please read the manual about common errors. This question is FAQ and this error means that you - do not have MySQL running - it is running but socket in another place You can fix situation with /etc/my.cnf file. Tnu - 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 I return select (sub query) in array?
Hello,select ... in (select ) dosn't work, can I return the second query in array and use it in the first? Thanx ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.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: Multiple Querie or Long- Speed
On 13 Apr 2001 18:02:19 -0400, bryan wheelock wrote: Is a more complex single query going to run faster on a server than several smaller queries where the results are set to variables and then used as criteria in tertiary queries. Usually yes as you do not have network and parsing overheads. Tnu - 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 can be used with QNX Neutrino?
On 13 Apr 2001 07:30:23 -0500, Das Lekha wrote: Could you please let me know whether MySQL database can be used with QNX Neutrino Realtime Platform ? If so, what version? I believe we do not have such version of MySQL. But if this platform have decent threads and compiler we can try to make it. But for this we should have some kind of access to it. Tnu - 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: Does MySQL support sub queries ?
Well I have managed to rewrite alot of my coding from MS SQL in a downward and more portable style using MySQL and ASP. I too have now hit apon where I need to have Sub queries on some basic searching of products. Rather than just telling people "the manual says..." that Sub Selects are missing, would anyone else like to show how to recreate the original example that Yen showed in his post, will work in MySQL (and with no giggery pokery with piping in from temporaty files)? I was wondering if a temporary heap table could be created and all done in multi line sql command (thus making it useable from an ADO recordset call in ASP and equivalent in php). Yens original code example: select ref from tool1 where detail = 'xxx' and ref in (select ref from tool1 where detail='yyy'); Seems so innocent and simple but I cant get my head around it Many thanks C
ADO RS.Update problem
Hello! I am using mysql with VB ADO under Windows 2000 Proffesional. I add data with: RS.Open "Query WHERE 0=1", Cn, , , adCmdText RS.AddNew RS.Fields(Cols).Value = xx . RS.Update After RS.Update RS.Fields(Cols).Value is NULL. If I use Access database, RS.Fields(Cols).Value has value of last inserted record. Would you like to tell me, why mysql works in different way and how to solve this problem to have compatible solution for mysql and Access? Thanks all! Simon
bug - multiple column primary key cannot correctly determine duplicate entry
Dear MySQL experts In the following example I created simple table with two-column primary key ID,IDT. After some inserts there came insert with ID, IDT values, that are not equal to none of the previous couples, but MySQL still reported error "Duplicate entry". In the lines below there is source code that can by used to reproduce the problem. This example was run under local environment of Microsoft Windows 98 4.10.1998 on MySQL Ver 3.23.32 for Win95/Win98 on i32 with user privileges select, insert, update, delete, create, drop, alter and index. Please feel free to answer that this was my fault. I am just a beginner and it would be the best result. Otherwise it would be serios bug. Filip Trojan, Prague, Czech Republic # MySQL dump 8.12 # # Host: localhostDatabase: tourservis # # Server version 3.23.32-log # # Table structure for table 'pobzajturnus' # CREATE TABLE pobzajturnus ( ID int(11) NOT NULL default '0', IDT int(11) NOT NULL default '0', DZAP datetime NOT NULL default '-00-00 00:00:00', DAKT datetime NOT NULL default '-00-00 00:00:00', DZAC datetime NOT NULL default '-00-00 00:00:00', DKON datetime NOT NULL default '-00-00 00:00:00', POCMIST smallint(6) default NULL, POCVOLN smallint(6) default NULL, DOPRAVA varchar(40) default NULL, VEDOUCI int(11) default NULL, POZN blob, PRIMARY KEY (ID,IDT) ) TYPE=MyISAM; # # Dumping data for table 'pobzajturnus' # INSERT INTO pobzajturnus VALUES (-2147483648,1544414423,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-06-09 00:00:00','2001-06-16 00:00:00',NULL,NULL,'vlastn nebo autobusovou linkou (nen za',0,''); INSERT INTO pobzajturnus VALUES (-2147483648,44245749,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-06-16 00:00:00','2001-06-23 00:00:00',NULL,NULL,'vlastn nebo autobusovou linkou (nen za',0,''); INSERT INTO pobzajturnus VALUES (-2147483648,2147483647,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-06-23 00:00:00','2001-06-30 00:00:00',NULL,NULL,'vlastn nebo autobusovou linkou (nen za',0,''); INSERT INTO pobzajturnus VALUES (-2147483648,1338875697,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-06-30 00:00:00','2001-07-07 00:00:00',NULL,NULL,'vlastn nebo autobusovou linkou (nen za',0,''); INSERT INTO pobzajturnus VALUES (-2147483648,1969892214,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-07-07 00:00:00','2001-07-14 00:00:00',NULL,NULL,'vlastn nebo autobusovou linkou (nen za',0,''); insert into pobzajturnus set id=-2154422840, idt=4764690836, dzap=now(), dakt=now(), dzac='2001-07-14 00:00', dkon='2001-07-21 00:00', doprava='vlastn nebo autobusovou linkou (nen zahrnuta v cen)', vedouci='', pozn=''; ERROR 1062 at line 38: Duplicate entry '-2147483648-2147483647' for key 1
Re: bug - multiple column primary key cannot correctly determine duplicate entry
Hi, On Sat, Apr 14, 2001 at 11:53:52AM +0200, Filip Trojan wrote: In the following example I created simple table with two-column primary key ID,IDT. After some inserts there came insert with ID, IDT values, that are not equal to none of the previous couples, but MySQL still reported error "Duplicate entry". One of the rows in your dump is this: INSERT INTO pobzajturnus VALUES (-2147483648,2147483647,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-06-23 00:00:00','2001-06-30 00:00:00',NULL,NULL,'vlastn nebo autobusovou linkou (nen za',0,''); Even though it is not equal to what you try to insert here: insert into pobzajturnus set id=-2154422840, idt=4764690836, dzap=now(), dakt=now(), dzac='2001-07-14 00:00', dkon='2001-07-21 00:00', doprava='vlastn nebo autobusovou linkou (nen zahrnuta v cen)', vedouci='', pozn=''; You can see from the values in the error message that MySQL does try to insert the same values here: ERROR 1062 at line 38: Duplicate entry '-2147483648-2147483647' for key 1 The problem is that your values are outside the valid range for integers. MySQL converts them to the closest value that is allowed. In my opinion it should have given an error message. Anyway, look in the manual for other integer or floating point types to use. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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: bug - multiple column primary key cannot correctly determine duplicate entry
the 'integers' you insert as key are too big to fit in the size of a integer. mysql replaces such a big or small integer by the biggest or smallest value possible. if you look closely at your query, you see that the key returned by mysql are not the same values as you inserted. you have to: or change field type to contain bigger values, or insert integers that fit within a integer field. for example you could use the numeric type. setting integer(11) has no effect, numeric(11) has. gl rene - Original Message - From: "Filip Trojan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 11:53 AM Subject: bug - multiple column primary key cannot correctly determine duplicate entry Dear MySQL experts In the following example I created simple table with two-column primary key ID,IDT. After some inserts there came insert with ID, IDT values, that are not equal to none of the previous couples, but MySQL still reported error "Duplicate entry". In the lines below there is source code that can by used to reproduce the problem. This example was run under local environment of Microsoft Windows 98 4.10.1998 on MySQL Ver 3.23.32 for Win95/Win98 on i32 with user privileges select, insert, update, delete, create, drop, alter and index. Please feel free to answer that this was my fault. I am just a beginner and it would be the best result. Otherwise it would be serios bug. Filip Trojan, Prague, Czech Republic # MySQL dump 8.12 # # Host: localhostDatabase: tourservis # # Server version 3.23.32-log # # Table structure for table 'pobzajturnus' # CREATE TABLE pobzajturnus ( ID int(11) NOT NULL default '0', IDT int(11) NOT NULL default '0', DZAP datetime NOT NULL default '-00-00 00:00:00', DAKT datetime NOT NULL default '-00-00 00:00:00', DZAC datetime NOT NULL default '-00-00 00:00:00', DKON datetime NOT NULL default '-00-00 00:00:00', POCMIST smallint(6) default NULL, POCVOLN smallint(6) default NULL, DOPRAVA varchar(40) default NULL, VEDOUCI int(11) default NULL, POZN blob, PRIMARY KEY (ID,IDT) ) TYPE=MyISAM; # # Dumping data for table 'pobzajturnus' # INSERT INTO pobzajturnus VALUES (-2147483648,1544414423,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-06-09 00:00:00','2001-06-16 00:00:00',NULL,NULL,'vlastn nebo autobusovou linkou (nen za',0,''); INSERT INTO pobzajturnus VALUES (-2147483648,44245749,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-06-16 00:00:00','2001-06-23 00:00:00',NULL,NULL,'vlastn nebo autobusovou linkou (nen za',0,''); INSERT INTO pobzajturnus VALUES (-2147483648,2147483647,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-06-23 00:00:00','2001-06-30 00:00:00',NULL,NULL,'vlastn nebo autobusovou linkou (nen za',0,''); INSERT INTO pobzajturnus VALUES (-2147483648,1338875697,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-06-30 00:00:00','2001-07-07 00:00:00',NULL,NULL,'vlastn nebo autobusovou linkou (nen za',0,''); INSERT INTO pobzajturnus VALUES (-2147483648,1969892214,'2001-04-14 10:57:56','2001-04-14 10:57:56','2001-07-07 00:00:00','2001-07-14 00:00:00',NULL,NULL,'vlastn nebo autobusovou linkou (nen za',0,''); insert into pobzajturnus set id=-2154422840, idt=4764690836, dzap=now(), dakt=now(), dzac='2001-07-14 00:00', dkon='2001-07-21 00:00', doprava='vlastn nebo autobusovou linkou (nen zahrnuta v cen)', vedouci='', pozn=''; ERROR 1062 at line 38: Duplicate entry '-2147483648-2147483647' for key 1 - 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
MyODBC Silent Install
MyOdbc Silent Install is available for download at: http://www.avukatpro.com/mysql.html Regards Avukatpro Limited Sirketi Stupid Robot :) database mysql vb asp
Re: ADO RS.Update problem
Unfortunately, it doesn't seem like all ADO methods and properties and supported when working with MySQL. Update, as you know, is one of them, along with others like RecordCount. I would recommend using a connection object and then passing an SQL statement to run. If need be, you can add the results to a recordset object. You can write it like the following, where objConn is a ADO connection object: % strSQL = "SELECT * FROM Foo" objConn.Execute(strSQL) % Obviously, the above is ASP syntax, but you get the idea for VB :). Good luck, Dennis **' Beridney Computer Services [EMAIL PROTECTED] http://www.beridney.com - Original Message - From: "Simon Abolnar" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 4:46 AM Subject: ADO RS.Update problem Hello! I am using mysql with VB ADO under Windows 2000 Proffesional. I add data with: RS.Open "Query WHERE 0=1", Cn, , , adCmdText RS.AddNew RS.Fields(Cols).Value = xx . RS.Update After RS.Update RS.Fields(Cols).Value is NULL. If I use Access database, RS.Fields(Cols).Value has value of last inserted record. Would you like to tell me, why mysql works in different way and how to solve this problem to have compatible solution for mysql and Access? Thanks all! Simon - 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
MySQLGUI version 1.7.5
Hi! New version of mysqlgui, version 1.7.5 has been released at it's usual place. An excerpt from readme for this version : Regarding bug fixes, foremost of all, some of FLTK widgets have been updated, which has caused some changes in mysqlgui source code. Some users have reported problems with X 4.0.* when using some widgets. This has been fixed. Beside that, column resizing in spreadsheet now works. Also, editing (in order to scroll text) and zooming is not automatic, but you should press F2 or Ctrl+E in order to scroll a cell or to zoom it. This has resulted in faster scrolling of the spreadsheet. Some aesthetic changes have been implemented in some widgets. Also, process dialogue display is now more readable. Also, this version contains some speed and aesthetic enhancements. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: ADO RS.Update problem
Just a quick note about RecordCount. RecordCount only returns the number of records or rows from the recordset that have been 'seen'. Therefore it is only reliable if you have traversed the entire recordset before calling it. I agree, however, that direct SQL calls will generally produce a more predictable result Sorry for the interruption... Pat... - Original Message - From: "Dennis Salguero" [EMAIL PROTECTED] To: "Simon Abolnar" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 7:21 AM Subject: Re: ADO RS.Update problem Unfortunately, it doesn't seem like all ADO methods and properties and supported when working with MySQL. Update, as you know, is one of them, along with others like RecordCount. I would recommend using a connection object and then passing an SQL statement to run. If need be, you can add the results to a recordset object. You can write it like the following, where objConn is a ADO connection object: % strSQL = "SELECT * FROM Foo" objConn.Execute(strSQL) % Obviously, the above is ASP syntax, but you get the idea for VB :). Good luck, Dennis **' Beridney Computer Services [EMAIL PROTECTED] http://www.beridney.com - Original Message - From: "Simon Abolnar" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 4:46 AM Subject: ADO RS.Update problem Hello! I am using mysql with VB ADO under Windows 2000 Proffesional. I add data with: RS.Open "Query WHERE 0=1", Cn, , , adCmdText RS.AddNew RS.Fields(Cols).Value = xx . RS.Update After RS.Update RS.Fields(Cols).Value is NULL. If I use Access database, RS.Fields(Cols).Value has value of last inserted record. Would you like to tell me, why mysql works in different way and how to solve this problem to have compatible solution for mysql and Access? Thanks all! Simon - 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: Trying to build mysql-3.23.36 on RedHat 6.2
N6REJ writes: I've having a HORRIBLE time compiling this new version of MySql. Can someone please tell me what could be wrong? I have upgraded glibc to 2.96 per recommendations on the website, with no change in results. Here is the error I get 6 -DDBUG_OFF -c my_error.c my_error.c: In function `my_error': my_error.c:104: Internal error: Segmentation fault. Please submit a full bug report. See URL:http://bugzilla.redhat.com/bugzilla/ for instructions. make[2]: *** [my_error.o] Error 1 make[2]: Leaving directory `/usr/src/mysql-3.23.36/mysys' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/mysql-3.23.36' make: *** [all-recursive-am] Error 2 [root@kahoolawe mysql-3.23.36]# make test cd mysql-test ; ./mysql-test-run /bin/sh: ./mysql-test-run: No such file or directory make: *** [test] Error 126 Troy [EMAIL PROTECTED] "I do not understand what I do, for what I want to do I do not do but what I hate I do" Rom 7:15 NIV Hi! unless your computer is based on IA-64, please use gcc 2.95.2. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: BLOB in mysql_create mysql++
xuan li writes: Hello all, When I use mysql_create to create the struce to access table, I have a question about the BOLB type. My table defined as follow: drop table ClipBoard; #4-13 create table ClipBoard( # added 4-12 xuan li id INTEGER NOT NULL, data blob, primary key(id) ); Then I use mysql_create_2{ ClipBoard, 1,2, int,id, string, data }; If I use this clipBoard class to access table. Sometimes there is a error. I think string (the data type i am using) is not ok for blob. So what is the right datatype for blob. I know string is ok for text. Thanks Xuan Li Hi! As you can see from this excerpt from type_info.cc, string is the right type : sql_type_info("LONGBLOB NOT NULL", typeid(string), 17), Do not forget to use row_data() to access binary data from the columns. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 I return select (sub query) in array?
Sofiane Sakhri writes: Hello,select ... in (select ) dosn't work, can I return the second query in array and use it in the first? Thanx Yes, you could. SELECT ... WHERE column IN (1,2,3,4,5); You have to fix it in your application. Most of the nested selects, like yours above can be reduced to a JOIN query. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: UTF-8 supported, compatible or plain won't work ?
UTF-8 is just another encoding scheme. You can store UTF-8 just fine in MySQL (using BLOB, or perhaps even CHAR), however you cannot do much more with it beyond storing. Comparisons aren't likely to work, character-length calculations will not work, etc. So if all you wanna do is store and retrieve pieces of text, then it'll work just fine. If you want the database to do operations on the text then you'll have to find another one... -S -Original Message- From: S A [mailto:[EMAIL PROTECTED]] Sent: 13 April 2001 03:02 To: List MySQL Subject: UTF-8 supported, compatible or plain won't work ? Can you use UTF-8 with MySQL ? Is UTF-8 supported now, just compatible or plain won't work ? I've read conflicting discussion on this topic. thanks, - Sam. - Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. - 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: ADO RS.Update problem
Fist of all thank you for your help!!! Sorry, but I disagree with you.Record is inserted correctly in database. The only problem is that Resultset remains empty after RS.Update. Any solution how to get Id of that inserted record without using MySQL specific solution? Thanks all! Simon - Original Message - From: "Dennis Salguero" [EMAIL PROTECTED] To: "Simon Abolnar" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 1:21 PM Subject: Re: ADO RS.Update problem Unfortunately, it doesn't seem like all ADO methods and properties and supported when working with MySQL. Update, as you know, is one of them, along with others like RecordCount. I would recommend using a connection object and then passing an SQL statement to run. If need be, you can add the results to a recordset object. You can write it like the following, where objConn is a ADO connection object: % strSQL = "SELECT * FROM Foo" objConn.Execute(strSQL) % Obviously, the above is ASP syntax, but you get the idea for VB :). Good luck, Dennis **' Beridney Computer Services [EMAIL PROTECTED] http://www.beridney.com - Original Message - From: "Simon Abolnar" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 4:46 AM Subject: ADO RS.Update problem Hello! I am using mysql with VB ADO under Windows 2000 Proffesional. I add data with: RS.Open "Query WHERE 0=1", Cn, , , adCmdText RS.AddNew RS.Fields(Cols).Value = xx . RS.Update After RS.Update RS.Fields(Cols).Value is NULL. If I use Access database, RS.Fields(Cols).Value has value of last inserted record. Would you like to tell me, why mysql works in different way and how to solve this problem to have compatible solution for mysql and Access? Thanks all! Simon - 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
Fw: Mail failure
Troy [EMAIL PROTECTED] "I do not understand what I do, for what I want to do I do not do but what I hate I do" Rom 7:15 NIV - Original Message - From: "WHSSB/ERNE/POSTMASTER" [EMAIL PROTECTED] To: "N6REJ" [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 17:26 Subject: Mail failure [008] Failure delivering user mail due to mailbag contention. Mail item was not delivered to: whssb/erne/dlun -- Microsoft Mail v3.0 (MAPI 1.0 Transport) IPM.Microsoft Mail.Note From: N6REJ To: [EMAIL PROTECTED] Subject: Trying to build mysql-3.23.36 on RedHat 6.2 Date: 2001-04-14 01:20 Priority: 3 Message ID: 1F7243EE2A2DD511A9B200A024D89C5E I've having a HORRIBLE time compiling this new version of MySql. Can someone please tell me what could be wrong? I have upgraded glibc to 2.96 per recommendations on the website, with no change in results. Here is the error I get 6 -DDBUG_OFF -c my_error.c my_error.c: In function `my_error': my_error.c:104: Internal error: Segmentation fault. Please submit a full bug report. See URL:http://bugzilla.redhat.com/bugzilla/ for instructions. make[2]: *** [my_error.o] Error 1 make[2]: Leaving directory `/usr/src/mysql-3.23.36/mysys' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/mysql-3.23.36' make: *** [all-recursive-am] Error 2 [root@kahoolawe mysql-3.23.36]# make test cd mysql-test ; ./mysql-test-run /bin/sh: ./mysql-test-run: No such file or directory make: *** [test] Error 126 Troy [EMAIL PROTECTED] "I do not understand what I do, for what I want to do I do not do but what I hate I do" Rom 7:15 NIV --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.243 / Virus Database: 118 - Release Date: 03/30/01 - 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.243 / Virus Database: 118 - Release Date: 03/30/01 - 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
Failure to install 3.23.36
I've having a HORRIBLE time compiling this new version of MySql. Can someone please tell me what could be wrong? I have upgraded glibc to 2.96 per recommendations on the website, with no change in results. Here is the error I get 6 -DDBUG_OFF -c my_error.c my_error.c: In function `my_error': my_error.c:104: Internal error: Segmentation fault. Please submit a full bug report. See URL:http://bugzilla.redhat.com/bugzilla/ for instructions. make[2]: *** [my_error.o] Error 1 make[2]: Leaving directory `/usr/src/mysql-3.23.36/mysys' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/mysql-3.23.36' make: *** [all-recursive-am] Error 2 [root@kahoolawe mysql-3.23.36]# make test cd mysql-test ; ./mysql-test-run /bin/sh: ./mysql-test-run: No such file or directory make: *** [test] Error 126 Troy [EMAIL PROTECTED] "I do not understand what I do, for what I want to do I do not do but what I hate I do" Rom 7:15 NIV --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.243 / Virus Database: 118 - Release Date: 03/30/01 - 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 with MyODBC via VisualBasic6 ADO2.6 - Recordset
HELP! I want to get the result of "show table status" into a ADO2.6 Recordset. But the result of my query is EMPTY. But only in VB6. When I use the "admndemo.exe" program it works. Note: "show status" works perfektly, only "show table status" and "show processlist" makes trobble... I need the information from "show table status" in my programm, so HELP!! I hope that anybody can help me... PLEASE - 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 you convert a MS Sql database to MySQL?
Actually, we are looking to do just the same thing for a pretty large database. We've come across a project at sourceforge that claims to do this (upsize bcp) and will be investigating how well it works next week. Sourceforge page is http://sourceforge.net/projects/upsize-bcp/. On Fri, 13 Apr 2001, AJ wrote: Does anyone know any good source of info for the conversion of MS Sql databases to MySql? Perhaps a prog that does this? Thanks for any information in advance, AJ Workman - 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: default password?
it tells me that I'm missing a command if I take away the -p Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Guray Sunamak Sent: Saturday, April 14, 2001 3:27 AM To: David Loszewski Cc: [EMAIL PROTECTED] Subject: Re: default password? Do not include "-p". Then it won't ask you a password David Loszewski wrote: After intsalling mysql is there a default password assigned to root? I type "./mysqladmin -u root -p password 'new-password'" Well, I don't know what the old/default password is deermind for the american How do I fix it? thx, DAVE - 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 -- Guray Sunamak \\\|/// [EMAIL PROTECTED] \\ - - // computer turtle @Samtek-Itc Ankara/Turkey ( 0 0 ) ICQ# 73827870 -oOOo-(_)-oOOo- - 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 you convert a MS Sql database to MySQL?
Can't MS SQL export to an "SQL Script?" I imagine it would be a simple matter of cat'ing said script and piping it into the MySQL CLI client. (Are you on a UNIX box?) On Fri, 13 Apr 2001, AJ wrote: Does anyone know any good source of info for the conversion of MS Sql databases to MySql? Perhaps a prog that does this? Thanks for any information in advance, AJ Workman - 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: default password?
take away the -p AND the password Cal http://www.calevans.com -Original Message- From: David Loszewski [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 14, 2001 10:25 AM To: Guray Sunamak Cc: [EMAIL PROTECTED] Subject: RE: default password? it tells me that I'm missing a command if I take away the -p Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Guray Sunamak Sent: Saturday, April 14, 2001 3:27 AM To: David Loszewski Cc: [EMAIL PROTECTED] Subject: Re: default password? Do not include "-p". Then it won't ask you a password David Loszewski wrote: After intsalling mysql is there a default password assigned to root? I type "./mysqladmin -u root -p password 'new-password'" Well, I don't know what the old/default password is deermind for the american How do I fix it? thx, DAVE - 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 -- Guray Sunamak \\\|/// [EMAIL PROTECTED] \\ - - // computer turtle @Samtek-Itc Ankara/Turkey ( 0 0 ) ICQ# 73827870 -oOOo-(_)-oOOo- - 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: Can you convert a MS Sql database to MySQL?
You can use MS SQL's Scripting tool to produce the table structure, but MS SQL's scripts need to be massaged a bit before you can use them with MySQL to create the database. The data is another story. MS discontinued the 'DUMP' command after SQL Server 6.5 (it is in 7.0 for backward compatability), but I have never been happy with the results. There are other approaches you can take (export to CSV file, etc.), but again, the results leave something to be desired. The only way I have been able to get the data from MS to MySQL is via Access, using the 'Link Tables' option. If you have enough time and programming talent, you could write an app to do the job, but I know of none. G. Jensen - Original Message - From: "Chris Harshman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 10:22 AM Subject: Re: Can you convert a MS Sql database to MySQL? Can't MS SQL export to an "SQL Script?" I imagine it would be a simple matter of cat'ing said script and piping it into the MySQL CLI client. (Are you on a UNIX box?) On Fri, 13 Apr 2001, AJ wrote: Does anyone know any good source of info for the conversion of MS Sql databases to MySql? Perhaps a prog that does this? Thanks for any information in advance, AJ Workman - 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: Problem with MyODBC via VisualBasic6 ADO2.6 - Recordset
Open your datasource (via control panel/ ODBC datasource administrator) and make sure the option "Change BIGINTcolumns to INT" is checked. This will correct your problem with "show table status" and "show processlist" Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Original Message - From: "Schrottemail" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 10:20 AM Subject: Problem with MyODBC via VisualBasic6 ADO2.6 - Recordset HELP! I want to get the result of "show table status" into a ADO2.6 Recordset. But the result of my query is EMPTY. But only in VB6. When I use the "admndemo.exe" program it works. Note: "show status" works perfektly, only "show table status" and "show processlist" makes trobble... I need the information from "show table status" in my programm, so HELP!! I hope that anybody can help me... PLEASE - 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
Outer and left join definition
Hello, I am a translator with quite a good knowledge of programming and of HTML/CGI/Perl/Apache and many other web related topics. I am translating part of a book on PHP and, for the reasons above, I have had no problems so far. I am having problems however, in translating a short section where, discussing interaction with MySQL is discussed, the terms "left join" and "outer join" are mentioned. I would be really grateful to whoever could explain to me, in non technical English, what the two terms above mean, so that I can complete the translation. Thank you in advance, Marco Fioretti - 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
Redirecting Outfile
Redirecting file output (for user bpc) with a command such as select * into outfile 'home/bpc/test.txt' from table gives the error ERROR 1: Can't create/write to file "/home/bpc/test.txt" (Errcode: 13). The documentation recommends setting parameter tmpdir. I have RedHat 7 with MySQL 3.23 and so I added file /home/bpc/.my.cnf with the parameter tmpdir=/home/bpc but that did not fix the problem. --- Brian Cassidy [EMAIL PROTECTED] http://people.unb.ca/~bpc - 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: Redirecting Outfile
since the outfile is being written as the user that owns the mysqld process you'll need to make sure that, that user has write access to the location specified. Brian Cassidy wrote: Redirecting file output (for user bpc) with a command such as select * into outfile 'home/bpc/test.txt' from table gives the error ERROR 1: Can't create/write to file "/home/bpc/test.txt" (Errcode: 13). The documentation recommends setting parameter tmpdir. I have RedHat 7 with MySQL 3.23 and so I added file /home/bpc/.my.cnf with the parameter tmpdir=/home/bpc but that did not fix the problem. --- Brian Cassidy [EMAIL PROTECTED] http://people.unb.ca/~bpc - 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
Too many sleepers?
I've noticed, by doing "show processlist", that a few users end up with dozens (sometimes 50) sleeping processessome are 4 hours old. What is this typically caused by? I believe that most of my users connect using php, and I believe that if they omit mysql_close() that the connection is supposed to be closed automatically when their script ends. Are there other situations that would lead to this many ancient sleeping processes? Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - 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
Help!!
$result=0; $query="select * from users where user_id='$user_id'"; $result=mysql_query($query,$link); if(mysql_fetch_row($result)) $result=1; else $result=0; I use the function of "mysql_fetch_row()" in register2.php and it's output is the follow list: Warning: Supplied argument is not a valid MySQL result resource in /home/shin/public_html/register2.php on line 27