Re: Qeury Help - Joining 4 tables!
Join many table with 1 query is the ideal. Because you must sure that there are the valid data integrity. If there is only 1 broken join key (any part of table1.key=table2.key), you'll got the null row. When you need to display all of the first table value and retrieve another information from other table, try to make more than 1 query like this $qry1 = select * from table1;; $result = mysql_query($qry1, $mysql_link) if ($result) { while($row = mysql_fetch_array($mysql_result)) { ... display as you want before check value in another table $qry2 = select * from othertable where code='$row[cid]';; $result2 = mysql_query($qry2, $mysql_link); if ($result2) { $row2 = mysql_fetch_array($result2); if (trim($cname)==) { $cname = N/A; } else {$cname = trim($row2[name]). .trim($row2[surname]); } } else {$cname = N/A;} print $cname\n; } } hope to help you, Sommai, At 23:34 31/3/2002 -0800, David McInnis wrote: Can anyone tell me a more efficient way to structure this query? It works fast enough now, but I don't have that much data yet. I am concerned with future performance. I need all of the rows from the project table that match the first where clause. The other information saves me from having to run a bunch of additional queries to get information that I need to display. select a.clientid, a.pid, a.writerid, a.dt_assigned, b.itemname, c.fname, c.lname, d.company fromprojects a, catalog b, clients c, partners d where a.writerid = 2 and a.sku = b.sku and a.clientid = c.id and c.partnerid = d.id; Thanks, David McInnis - 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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi Benjamin, Uhmm, I have not success with Pre-compiled / Binary code from MySQL. In the other hand (if I was success installed), could it placed all thing like static complied? I have been concern this because I must to install other program or library to use with MySQL. So, I have a little experience with *nix* platform and using MySQL with the basic instruction. By now, I will try the MySQL binary installed to avoid this problem. Thanks any way, Sommai. At 03:05 12/3/2002 +0100, Benjamin Pflugmann wrote: Hi. On Tue, Mar 12, 2002 at 08:20:46AM +0700, [EMAIL PROTECTED] wrote: Hi, What's wrong with GNU-cc 2.96? AFAIK, stability problems have been reported which did go away when using a precompiled binary... Why could we use 2.95 (and old 2.91) or above 3.*? or one of these compiler versions. Is this the junction of MySQL's user to choose which Linux version and review the suitable Hardware and Software? I mentioned this statement because I have more MySQL Server for several purpose in my organization. Of course, I still wait for the better feature from MySQL. How should we do; if the future version need more hardware, latest compiler or migration (3.xx -- 4.xx)? Did we still have the strength feature from MySQL (easy setup, run fast, need low resource)? I am not fully able to follow your concerns... if you use the precompiled binaries, as Sinisa suggested, you have all that, don't you? Usually, there is no need to compile MySQL yourself. To compile yourself is an option, not a must. Bye, Benjamin. -- [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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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: Why v3.23.49 does not build on RedHat 6.2 ?????
If I'd like to upgrade LH 6.2 to LH 7.0+. Would my old data (LH setting, MySQL db) lost? Sommai At 10:59 6/3/2002 -0500, Trond Eivind Glomsrød wrote: Ireneusz Piasecki [EMAIL PROTECTED] writes: Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2. Maybe one did it succesful, so now he has RH.6.2 with glibc 2.2. I still waiting for these persons. Don't do it. You will do bad things to your system. If you want to upgrade to a newer glibc, upgrade it all (newer versions of RHL has mysql included, too :) -- 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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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 somebody help me with round (columna,columnb) ?
Round function was discuss on this group. They tell me that it used round with the C behavior to adjust value near even value. If you need to adjust with upper value after .5, you need to used programming language (PHP, VB, C) instead of MySQL round function. Sommai At 18:44 28/2/2002 +0100, Roger Baklund wrote: * Doug Thompson When you repeated the query, the number of significant places was reduced by one each time. Thus: 100.4235 100.4230 100.4200 100.4000 ah. No, this was a misunderstanding... this is what I did: mysql set @a:=8; Query OK, 0 rows affected (0.00 sec) mysql select @a:=digits,round(number,@a) from testme; ++--+ | @a:=digits | round(number,@a) | ++--+ | 3 | 100.4230 | | 1 | 85.4000 | ++--+ 2 rows in set (0.00 sec) mysql select @a:=digits,round(number,@a) from testme; ++--+ | @a:=digits | round(number,@a) | ++--+ | 3 |100.4 | | 1 | 85.4 | ++--+ 2 rows in set (0.00 sec) (and then I repeated the statement two more times, using @b instead of @a, with first zero and then 1 digit decimals as a result.) Because the number of decimal digits in the result column is decided at parse time, and not for each row, the first query return 8 decimals, because @a was 8 at parse time, and the second return 1 decimal, because @a was 1 at parse time, from the previous select statement: mysql select @a:=digits,round(number,@a) from testme order by number; ++--+ | @a:=digits | round(number,@a) | ++--+ | 1 | 85.4 | | 3 |100.4 | ++--+ 2 rows in set (0.03 sec) mysql select @a:=digits,round(number,@a) from testme order by number; ++--+ | @a:=digits | round(number,@a) | ++--+ | 1 | 85.400 | | 3 | 100.423 | ++--+ 2 rows in set (0.00 sec) It was a bit confusing... :o) -- Roger query - 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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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 query performance
Hi, I was read from this group about LOAD DATA query performance. Someone was tell me that when load large data text file into database which has primary key or index may be slow. The way to make load data faster is drop and create table without index, after load data then create index again. But I found the opposite respond, I have text file (with delimited) about 5 mb (for table 126 fields, 1 PK, 2 indexes, 7500 rows). this is the respond time. - load data with drop-create table-add PK, indexestake 50 second - load data with empty tale (still have PK indexes) take 26 second What's wrong with my environment or load data concept? Sommai -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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
many field insert
Hi, I have to insert data to table which has many fields (252 fields). This table was successful update by the LOAD DATA infile. But when I generate SQL statement with from VB, SQL statment length got more than 1000 byte. I was try many time to re-check SQL syntax but I still can not insert data into mysql table. Is there any problem with my SQL? Sommai -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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: insert into with sub select
Hi Rob, You're right for my problem. I'll hope this solution to be fixed in MySQL someday. thanks anyway. Sommai At 10:28 27/2/2002 +, Rob wrote: I've been having this problem as well, which results from mySQL not allowing you to select and insert from the same table at the same time. This restriction makes some sense even in your case- mySQL wants to insert each row as it finds it in the select, but then that might change what results the select returns. The restriction is less relevant if you are performing a select which can return at most one row, but mySQL still enforces it. There are a couple of solutions to this. The cleanest one is probably just to use temporary tables to implement a true sub-select. (I've put together a framework to do this hidden behind an abstraction layer so that I can do subselects whether I'm using mySQL or a different database with a more robust SQL implementation.) That would go something like: create temporary table TMP_table select table1.* from table1 left join table2 on id where table2.id is null; insert into table2 select * from TMP_table; drop table TMP_table; A much uglier solution involves creating a new permanent table which duplicates the field you are selecting from table2, adding a field to table2, and generating a unique number somehow. You'd set this up with: create table table2_id select id from table2; alter table table2 add column insertion_id int; (you'd probably also want to index table2_id...) and then for each query run: insert into table2 select table1.*, theUniqueNumber from table1.* left join table2_id on id where table2_id.id is null; insert into table2_id select id from table2 where insertion_id=theUniqueNumber; (and then, if you like, you can null out the insertion_id fields) Obviously, this approach is best avoided because it is invasive, it pollutes your database with wasteful and confusing processing information, and it relies on your ability to come up with a unique ID. The main advantage here is that these statements are pure insertions, so you can execute them with the DELAYED flag, which can be very important in reducing UI latency. (Again, a good wrapper library which allows you to submit any SQL commands asyncronously from another thread is also useful in this respect.) Of course, if that is important then you'd probably want to do something substantially more clever than the standard auto_increment database ops to pick your unique number. It also avoids the use of temporary tables, which some claim are not as efficient as simple selects across additional permanent tables. (I haven't done the profiling to test this theory, however.) On 27/2/02 at 9:18 am, Sommai Fongnamthip [EMAIL PROTECTED] wrote: Hi, MySQL has insert into function and sub select (mysql style) but I could not conclude these function togethter. If I want to select not existing row in 2 table, I used: SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id where table2.id is null then I'd like to insert the result row back into table2 by this SQL: insert into table2 SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id where table2.id is null it got this error: ERROR 1066: Not unique table/alias: 'table2' How could I fixed this problem?? Sommai -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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: insert into with sub select
Hi rob, I have another question but still in this solution. How did you delete data which different in 2 table? Sommai At 10:28 27/2/2002 +, Rob wrote: I've been having this problem as well, which results from mySQL not allowing you to select and insert from the same table at the same time. This restriction makes some sense even in your case- mySQL wants to insert each row as it finds it in the select, but then that might change what results the select returns. The restriction is less relevant if you are performing a select which can return at most one row, but mySQL still enforces it. There are a couple of solutions to this. The cleanest one is probably just to use temporary tables to implement a true sub-select. (I've put together a framework to do this hidden behind an abstraction layer so that I can do subselects whether I'm using mySQL or a different database with a more robust SQL implementation.) That would go something like: create temporary table TMP_table select table1.* from table1 left join table2 on id where table2.id is null; insert into table2 select * from TMP_table; drop table TMP_table; A much uglier solution involves creating a new permanent table which duplicates the field you are selecting from table2, adding a field to table2, and generating a unique number somehow. You'd set this up with: create table table2_id select id from table2; alter table table2 add column insertion_id int; (you'd probably also want to index table2_id...) and then for each query run: insert into table2 select table1.*, theUniqueNumber from table1.* left join table2_id on id where table2_id.id is null; insert into table2_id select id from table2 where insertion_id=theUniqueNumber; (and then, if you like, you can null out the insertion_id fields) Obviously, this approach is best avoided because it is invasive, it pollutes your database with wasteful and confusing processing information, and it relies on your ability to come up with a unique ID. The main advantage here is that these statements are pure insertions, so you can execute them with the DELAYED flag, which can be very important in reducing UI latency. (Again, a good wrapper library which allows you to submit any SQL commands asyncronously from another thread is also useful in this respect.) Of course, if that is important then you'd probably want to do something substantially more clever than the standard auto_increment database ops to pick your unique number. It also avoids the use of temporary tables, which some claim are not as efficient as simple selects across additional permanent tables. (I haven't done the profiling to test this theory, however.) On 27/2/02 at 9:18 am, Sommai Fongnamthip [EMAIL PROTECTED] wrote: Hi, MySQL has insert into function and sub select (mysql style) but I could not conclude these function togethter. If I want to select not existing row in 2 table, I used: SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id where table2.id is null then I'd like to insert the result row back into table2 by this SQL: insert into table2 SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id where table2.id is null it got this error: ERROR 1066: Not unique table/alias: 'table2' How could I fixed this problem?? Sommai -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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 error
Hi, Please tell me why this mysql in php error: sql = LOAD DATA LOCAL INFILE \/home/httpds/htdocs/srg/data/tct.csv\ INTO TABLE tct_temp FIELDS TERMINATED BY '\|'; $result = mysql_db_query($dbName, $sql) or die (Can not run: $sql); I try another sql style like these sql = LOAD DATA LOCAL INFILE '/home/httpds/htdocs/srg/data/tct.csv' INTO TABLE tct_temp FIELDS TERMINATED BY '\|'; sql = LOAD DATA LOCAL INFILE 'data/tct.csv' INTO TABLE tct_temp FIELDS TERMINATED BY '\|'; Thanks Sommai -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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 error
sorry for my fault: I forgot $ (dollar sign) before sql variable. Sommai At 09:58 28/2/2002 +0700, Sommai Fongnamthip wrote: Hi, Please tell me why this mysql in php error: sql = LOAD DATA LOCAL INFILE \/home/httpds/htdocs/srg/data/tct.csv\ INTO TABLE tct_temp FIELDS TERMINATED BY '\|'; $result = mysql_db_query($dbName, $sql) or die (Can not run: $sql); I try another sql style like these sql = LOAD DATA LOCAL INFILE '/home/httpds/htdocs/srg/data/tct.csv' INTO TABLE tct_temp FIELDS TERMINATED BY '\|'; sql = LOAD DATA LOCAL INFILE 'data/tct.csv' INTO TABLE tct_temp FIELDS TERMINATED BY '\|'; Thanks Sommai -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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
insert into with sub select
Hi, MySQL has insert into function and sub select (mysql style) but I could not conclude these function togethter. If I want to select not existing row in 2 table, I used: SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id where table2.id is null then I'd like to insert the result row back into table2 by this SQL: insert into table2 SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id where table2.id is null it got this error: ERROR 1066: Not unique table/alias: 'table2' How could I fixed this problem?? Sommai -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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 php - while loops
if you decide to display only first 4 item try to used limit clause after the SQL statement. otherwise use any count variable within your loop. Sommai At 20:33 26/2/2002 -0600, Paul DuBois wrote: At 18:42 -0600 2/26/02, Craig Westerman wrote: The following lists 12 items from a fruits table. $results = mysql_query(SELECT ID, date, appleprice, orangeprice, pearprice FROM fruits); while ($data = mysql_fetch_array($results)) { ? p?=$data[date]? - ?=$data[appleprice]? - ?=$data[orangeprice]? - ?=$data[pearprice]?/p ? } How would I modify the loop to display 4 items then a row of fruit images then 4 more items then another row of different fruit images and then finally finish the loop displaying the final 4 items? That's a good question, given that the query doesn't retrieve any images, nor is it evident where else they might come from. :-) But it sounds like you're talking about three loops, not one. Thanks Craig [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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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: insert into with sub select
I was successful to get result from select (this sub-select appear in MySQL manual). At 21:20 26/2/2002 -0600, Paul DuBois wrote: At 9:18 +0700 2/27/02, Sommai Fongnamthip wrote: Hi, MySQL has insert into function and sub select (mysql style) but I could not conclude these function togethter. If I want to select not existing row in 2 table, I used: SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id where table2.id is null then I'd like to insert the result row back into table2 by this SQL: insert into table2 SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id where table2.id is null it got this error: ERROR 1066: Not unique table/alias: 'table2' How could I fixed this problem?? You can't. You're trying to insert records into a table from which you're selecting them, which is forbidden. At least, I think that's what's happening - though technically, you're not actually selecting columns from table2 to insert into table2. If you run the query without the insert part at the beginning, do you get the same error? Sommai - 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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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: using MySQL
You did not setting privilege for yourself to use MySQL access. See something about Security issue in MySQL manual (online or donwload). If you need the tools to setup MySQL instead of MySQL command prompt try PHPMyAdmin (web based) or MySQLFront (windows based). SF At 16:01 19/2/2002 -0800, Bob Rea wrote: I seem to have forgotten how to get into MySQL and work. (It's been a while but I'm starting up again. I get these errors: bob@sfpetard:~ mysqladmin create library mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'library'' and: bob@sfpetard:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 13 to server version: 3.23.44-Max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases - ; +---+ | Database | +---+ | addresses | | inventory | | libes | | mysql | | sample| | test | +---+ 6 rows in set (0.01 sec) mysql use libes ERROR 1044: Access denied for user: '@localhost' to database 'libes' I am doing this on SuSE 7.3. I know there is a user mysql already set up but I don't knwo the password. -- Bob Rea ** On the side of the box, under 'System Requirements', it said 'Requires Windows 95 or better'. So I installed Linux. ** [EMAIL PROTECTED] http://home.earthlink.net/~sfpetard/ - 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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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
update data from other table
Hi, How to update data in table with data from other table in single SQL command (without using loop)? Sommai, -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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: update data from other table
I want to update existing data not insert new data. sommai At 16:52 15/2/2002 +0700, Kittiphum Worachat wrote: HI Hi, How to update data in table with data from other table in single SQL command (without using loop)? Sommai, insert into table1 select * from table2 Kittiphum Worachat,MT. www.hatyailab.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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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: update data from other table
thank you very much. I have to used loop for this solution, did I? sommai At 04:53 15/2/2002 -0500, [EMAIL PROTECTED] wrote: Sorry its not possible. Here a User Comment from the commented MySql Doc (Chapter UPDATE Systax) -- Comments: Michael Holopainen: I was looking for info on how-to UPDATE with data retrived from another table. aka. UPDATE with JOIN. I noticed many other people were asking the same question so I desided to write this comment. The answer is : You can't. Not until MySQL 4.1 that supports sub-selects. Then and only then you can use something like this: UPDATE t1 SET t1.col = (SELECT t2.col FROM t2 WHERE where clause) WHERE where clause; As far as I can tell not even in MySQL 4.1 can you use JOIN with UPDATE. - Original Message: - From: Sommai Fongnamthip [EMAIL PROTECTED] Date: Fri, 15 Feb 2002 16:37:51 +0700 To: [EMAIL PROTECTED] Subject: update data from other table Hi, How to update data in table with data from other table in single SQL command (without using loop)? Sommai, -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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 mail2web - Check your email from the web at http://mail2web.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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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
storage usage
Hi, I have some text file (10MB per day) might be keep for a year. I have been keep it in compress format (using WinZip). When I need to see detail I have been open it and find something I want to see. If I decide to store these text file in to BLOB field of MySQL. How do you thing about this idea? Sommai - 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
storage usage
Hi, I have some text file (10MB per day) might be keep for a year. I have been keep it in compress format (using WinZip). When I need to see detail I have been open it and find something I want to see. If I decide to store these text file in to BLOB field of MySQL. How do you thing about this idea? Sommai - 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: PHP - MySQL - SQL7 Server - Visual Basic.
Hi bob, I have do everything you need but may be a little diff. I have MS SQL 6.5 on NT, MySQL 3.23.47 on Linux and using PHP / VB 6 for client. The first thing you must define some role of usage and other, how to manipulate your data. I have PHP update routing in some project (transfer via ftp function, read along text file and then update data to MySQL). If you need to access to MS SQL via PHP try to use FreeTDS on Linux (may be they have copy on NT). All you need about MySQL are on the Web. If you need to access MySQL via VB: try to use MyVBQL at www.icarz.com/mysql/. MyVBQL using libmysql.dll to access MySQL and let you used recordset style in your application. Sommai, At 20:53 5/2/2002 +, DL Neil wrote: Bob, I've posted this back onto the list because there are others here who will be much more able to assist. Clarification: I currently have 22 NT workstation that send data to various tables in a SQL7 database running on a NT sever. The visual basic front end organizes this data in to a neat fashion and allows the user to graph and print data and comparisons from the various tables. The front end also responds to e-mail requests for information from the tables. Currently there are only 12 authorized e-mail accounts so it is easy to manage. We are now going to add about 100 workstations, More tables and 200 authorized e-mails accounts. With this addition I have decided to eliminate the e-mail accounts and post all of this information to a secure web server that I will administer. So what I need to do is have a VB program write this data to a MySql database that will only allow users to view the data. I have extensive VB experience and have created and updated many types of databases using it, however I have never used MySql and need some pointers. Can Vb create and write to MySql databases? =yes, using an ODBC or ADO interface. What syntax do I use in PHP to read the MySql database? =PHP has a wide range of interface functions 'built-in'. =Why use two RDBMS'? PHP can access MS-SQL to provide the web service. =dn Hi Bob, Hi, I currently have a very large MS SQL7 database that I need to put on the web. My plan is to use PHP and MySQL to accomplish this. Currently I have a Visual Basic front end on the MS SQL7 Server. I would like to have my VB program write The MS SQL7 server data to a MYSql database and then have PHP read and display the MySql database on a web page. I am new to PHP and MySql so some idea's, samples, pro's or con's would be appreciated. =if you are converting, why not use SQL to 'export' the data from SQL-Server, and import it into MySQL? =Or do you mean that the web front-end is only for users to view the data, but that all updating transactions will be carried out through some VB-based system, and that you are contemplating having two databases/RDBMS-es? - 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
compression
Hi, I need to know that MySQL has any compression method when it store data? If the answer is Yes, How the different compression between MySQL and other tools (zip, gzip)? I asked this question because I need to store some text file for future used (at least 1 Mbyte per day). I was used Winzip in Windows to compress and keep in file server. If MySQL could compress some byte of data I think it better than flat file. Sommai - 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: INSERTing duplicate values to a UNIQUE-indexed table
If you need to update an old record in unique key, try to use REPLACE function. REPLACE could add if there has not existing record and update when it found a same unique key. Sommai, At 19:01 5/2/2002 +, DL Neil wrote: HelloErik, I have a slight dilemma, and was wondering what the standard workaround is. I have three tables: owners (auto_increment primary key is owners_id), objects (auto_increment primary key is objects_id), and owners_objects (which is a foreign key table that I created, under advice from someone on this list a while back whose email address has changed -- there are two columns in owners_objects: owners_id and objects_id, and there are two unique indexes on the table, owners_id / objects_id and objects_id / owners_id -- this is to keep duplicates combinations in this table, since they would only take up extra disk space). I am designing an application in PHP which stores the relationship between an Owner and an Object using the owners_objects table in a many-to-many relationship. When someone adds a new owner, they can choose from an HTML listbox any number of objects to associate with that owner. The PHP code creates an INSERT statement that inserts the data into owners, and then takes the auto_incremented primary key of the last insert (which is the insert into owners) and uses that as the value for the second INSERT statemetn: to insert into owners_objects.owner_id. In this second INSERT statement, the objects_id of the Object(s) selected from the listbox go into the second column of owners_objects. I am sure that many people have done this sort of setup. But what do you do to get around the problem of INSERTing a pair of values that already exist? Because the combinations in owners_objects are UNIQUE (the UNIQUE indexes), MySQL won't accept a pair that is already present. I see two possible options: 1) Check to see if the combination is already present, and if so, do not run the INSERT query 2) run the INSERT query regardless and suppress the error message The disadvantage of the first one is that it adds an extra SQL query to the process. The disadvantage of the second one is that I think it is somewhat tasteless to execute code that will knowingly error -- or should I just stop trying to be such a perfectionist? I would post code but this is all pseudocode right now b/c I haven't solved this dilemma yet -- all experimentation with this has been done from the mysql client. =option 2: whilst native-MySQL will give an errmsg in response to an attempt to INSERT duplicates, PHP doesn't have to pay attention! Check out MySQL_affected_rows(). =dn - 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
sub select
Hi, I know sub select would not work correct in 3.23.xx but I have a question to ask. I'd like to find top 10 ranking of my customer by amount (using order clause desc) but there are some customer have the same amount. I was solve this problem by using group by and insert it into temp table, then i use select function join temp table with main table. Could someone tell me the better way for this problem (i'd like to use only 1 sql statement)? SF example sql 1. insert into temp select *, count(*) from customer group by amount desc limit 10 -- this sql generate only 10 row in temp table 2. select customer.* from customer, temp where customer.amount = temp.amount -- this sql may be generate more than 10 row if there are many customer who has the same amount - 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
join and order by problem
Hi, I have problem with join and order clause. I have 2 table join with amount condition and sort by order clause. The result of this join generate unwanted row to me. example table1 No. Amount Count 1 1000 2 2 2000 3 3500 1 table2 No. NameAmount 1 A 1000 2 B 2000 3 C 2000 4 D 1000 5 E500 6 F 2000 sql=select * from table1,table2 where table1.amount=table2.amount order by table2.amount desc,table2.no result table no nameamount count 2 B 20003 2 B 20003 3 C 20003 3 C 20003 6 C 20003 6 C 20003 1 A 10002 1 A 10002 4 D 10002 4 D 10002 5 E5001 5 E5001 If I did not use order by table2.no in sql it generate result correctly. SF - 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
substring replace
Hi, Please help me to use SQL (with mysql prompt) command to replace any digit in column. Example: Old value 123466 New value 123456 How to replace old value at fifth digit (6) to 5? Thank you, SF - 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: index problem
I was try with explain or describe command. The result in column 'type' show 'ALL' , column ' possible keys' show index name I was created. I wonder that why did not use index it take a long time (look like computer hang). SF At 14:23 22/1/2002 +0700, Kittiphum Worachat wrote: Hi Try to check your query by this command explain select * from holder, management where holder.id=management.id or (holder.name=management.name and holder.surname=management.surname) order by holder.no and let take a look the result if they say the result come from ALL record it mean you can't get the benifit of index Kittiphum Worachat,MT. www.hatyailab.com Hi, I have problem with these query: select * from holder, management where holder.id=management.id or (holder.name=management.name and holder.surname=management.surname) order by holder.no It take a long time (more than 1 minute) with thousand record. I have index within 2 table (name+surname, id). It did not have problem if I check only id or name+surname. SF - 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
index problem
Hi, I have problem with these query: select * from holder, management where holder.id=management.id or (holder.name=management.name and holder.surname=management.surname) order by holder.no It take a long time (more than 1 minute) with thousand record. I have index within 2 table (name+surname, id). It did not have problem if I check only id or name+surname. SF - 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
text file insert
Hi, I prefer to used load data infile command to insert text file (CSV format) to MySQL. I wonder that Could load data use with pure text file (no delimiter)? if not how to insert text file in to MySQL faster than read every line? SF - 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
MySQL and kernel upgrade
Hi, I was read recommendation from MySQL download page to upgrade Linux Kernel for latest MySQL version. I have problem because I must still with Linux Red Hat 6.2 (kernel 2.2.16-3) because it's my production server and Red Hat has many task to upgrade in newer kernel. What will effect my system if I install latest MySQL with current kernel? SF - 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 limitation
Hi, I was ask for some limitation of SQL command for MySQL (may be this is my mistake). Somebody tell me that GROUP BY clause or ROUND function would not work correctly in some case. Should you help me to group or summary data within the less time (I did not like to use loop to summarize)? Other question I could not use derived name in AS clause after select statement in other section (WHERE, GROUP BY, ORDER BY clause), how should I fixed this problem? SF - 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
retrieve data from more db
HI, I have data on more than 1 db to separate in year name like these: cust2000-- contain customer infomation in year 2000 cust2001-- contain customer infomation in year 2001 all db have the same field name. I have put db name and table name in separate file (something like include.php). How I write php code to retrieve my interest value to display in one time? for more help pls describe how to layout compare table in the code. Thank you, SF - 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: VB/MySQL
The better way is use myvbql.dll at http://www.icarz.com/mysql/ . Your code can use both recordset style (ado full syntax only) and sql style (complex but useful). I recommend to use sql style when u need to manipulate data. SF At 14:57 1/11/2001 +0200, M.Ocak wrote: Yes it is possible, Create a System DSN by using Settings-- Control Panel --32 Bit ODBC data Sources. And use ADO to connect MySQL database. Hope this helps. Mustafa - Original Message - From: Quan Bang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 14:44 PM Subject: VB/MySQL Hi, Is it possible to work with VB and MySQL directly using dlls, just like working with VB and SQL Server. QB - 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: Comparing strings as ants^H^H^H^Hints
Some programming language in some platform could compare this string numeric. But, Why not use it in real numeric value (no quote) or use convert method before compare? SF At 13:24 30/10/2001 +0900, Joel Rees wrote: I don't have any experience with SQL, but I'm thinking that zero filling both might work: Although '5' = '40' is false, '0005' = '0040' is true. But since you should be using some glue code to validate the field from the web page anyway, can you just push the form field into a numeric before passing it to SQL? Would that do any good? Joel Rees [EMAIL PROTECTED] PS: Do posts tend to group around themes? Daniel James [EMAIL PROTECTED] wrote: [snipped] Here is the problem another way... select '5' = '6'; = 1 select '5' = '4'; = 0 select '5' = '40'; = 0- eegad. does anyone know how I can get around this? - 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:difficulty compiling v4 --without-innodb
Did you mean V4 must ran with innodb? Oh! I have bad experience with innodb. It ate a lot my hard disk space. SF At 23:30 28/10/2001 -0500, jim barchuk wrote: Hello Heikki! you probably should #undef HAVE_INNOBASE_DB in some file, maybe sql/handler.h Search with grep where the above has been defined. Having difficulty compiling v4-alpha --without-innodb. I am -not- a Sure did have that. A bunch of them in different files which is part of the reason I had such a tough time figuring out what was actually going on. Also had some other files that did *NOT* look familiar from other previous non-Apachetoolkit compiles. Then I found a reference in the toolkit log files stating 'CONFIGURING FOR INNODB.' Well, given that, toolkit apparently writes some config files, *.m4, that autoconf knows how to deal with but I don't know how to massage back to original. So I wiped the mysql subdir, untarred a new source tree, and configured and compiled clean with --without-innodb. Perfect. Guess I should have taken the easy way out right from the start. :) Apachetoolkit is a bit weird. -Sometimes- it asks me if I want to 'edit the php config file,' or the mysql config, or the apache config. -Or- not ask me, with no rhyme, reason, or consistency (as far as I could tell). Oh well, it worked for what I needed it to do. Thanks much. Have a :) day! jb -- jim barchuk [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
mysql 4.0
Hi, If I install mysql-4.0 to upgrade in mysql-3.23.xx with old setting value (use myisam type), Could I need to change or re-load my old db? SF - 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
group by clause
Hi, did someone tell me why group by clause not work? I'd like to group volume of order from my customer at the same price and my supplier. here is my code Select custid, symbol, sum(volume) as sumvol, price, mktid, supplier, supplierflag From confirm WHERE mktid=123 or mktid=456 Group by custid, symbol, supplier, supplierflag, price I got this: row#custid symbolsumvol price mktid supplier supplierflag (char) (char)(int)(double) (char) (char)(char) 1 1234 XXX 100 12 123 1C 2 1234 XXX 150 12 123 2C 3 1234 XXX 200 13 123 1E Why row 3 not follow data in row 1 instead of row 2? How could I correct my SQL statement? SF - 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
time calculate
hi, I'd like to calculate hour usage between 2 time value. Which data type I should to use in mysql? and how to write sql to calculate hour usage especially when the second time is in the next day?? Thanks SF - 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
round function
Hi, I found different round result at below mysql select round(1.235,2); ++ | round(1.235,2) | ++ | 1.24 | ++ 1 row in set (0.00 sec) mysql select round(1.325,2); ++ | round(1.325,2) | ++ | 1.32 | ++ 1 row in set (0.00 sec) What does it mean?? I wonder that round must increase the front value 1 step, but the second command show the wrong value. Please help me correct round function or any idea to fixed with coding. SF - 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
group by clause
Hi, did someone tell me why group by clause not work? I'd like to group volume of order from my customer at the same price and my supplier. here is my code Select custid, symbol, sum(volume) as sumvol, price, mktid, supplier, supplierflag From confirm WHERE mktid=123 or mktid=456 Group by custid, symbol, supplier, supplierflag, price I got this: row#custid symbolsumvol price mktid supplier supplierflag (char) (char)(int)(double) (char) (char)(char) 1 1234 XXX 100 12 123 1C 2 1234 XXX 150 12 123 2C 3 1234 XXX 200 13 123 1E Why row 3 not follow data in row 1 instead of row 2? How could I correct my SQL statement? SF - 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
select data from more db
Hi, I have data on more than 1 database with same schema. How could I use SQL statement to retrieve it for display in 1 time? Pls describe with PHP code. thanks SF - 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
array
Hi, How could I retrieve data from MySQL and put it to data array? here is example Table Sale Field1 -- Date Field2 -- Sale Amount --- DateSale Amount 1/1/20011000 1/2/20012000 1/3/20013000 $data_array=array ( array('1/1/2001',1000), array('1/2/2001',2000), array('1/3/2001',3000) ) Which command I need to use in PHP? SF - 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
join 2 db
Hello, I know this mail group may be not according to my question, so Please help me. I have been use PHP connect to mssql 6.5 with FreeTDS. I'd like to select data from 2 table with separate in 2 database name. How could I do this? here is some example. DB#1 DB#2 |-- Table#1-in-DB#1 |-- Table#1-in-DB#2 |--field#1-in-Table#1-in-DB#1 |--field#1-in-Table#1-in-DB#2 |--field#2-in-Table#1-in-DB#1 |--field#2-in-Table#1-in-DB#2 The result may contain data which the key of any field in Table of each DB. Thanks SF - 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
join 2 db
Hi, I'd like to retrieve data which contain in 2 db. How could I do? db1-table-in-db1-field-in-table-in-db1 db2-table-in-db2-field-in-table-in-db2 I'd not extract data to new table because I'd like to retrieve data only. thanks SF - 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: Security using ODBC
try driver vbmysql.dll at www.icarz.com/mysql/index.html SF At 16:00 24/8/2001 +0800, Jason Kwok wrote: Hi, I want to write a program with VB in win98 box and connect to mySQL in Linux. I think the only way to do is to connect thru ODBC with myODBC. But with using ODBC, all ID password is given when setting up the DSN. And this means everyone using this computer could access the mySQL server with the given right! And this also means I couldn't use my program to control the security of mySQL. I don't think this is true! But please tell me what should I do to avoid this, or what have I missed? == Best Regards Jason Kwok == --- Virus Free Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.273 / Virus Database: 143 - Release Date: 2001/8/16 - 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: Dedicated MySQL Application Server
Sorry, I am not sure to understand with 'interfere with any other instance'. I have more table and application in 1 database (in 1 server) which have a lot of database operation in everyday (insert, delete). and I could backup or restore any table in this database whenever I want. If you mean it may be interfere when you need to config MySQL or upgrade, you should plan to do it after working hour or on holiday. SF At 10:35 3/8/2001 +0500, Grigory Bakunov wrote: Date |Fri, 03 Aug 2001 11:52:00 +0700 From |Sommai Fongnamthip [EMAIL PROTECTED] Hello! SF Why do not use table and user permission separately in 1 database? Cause problem specification says I would not want this database to interfere with any other instance of MySQL that may be running on the same machine. SF SF SF At 07:41 3/8/2001 +0500, Grigory Bakunov wrote: Date |Thu, 2 Aug 2001 12:56:23 -0700 From |Bryan Ross [EMAIL PROTECTED] Hello! BR Hi. BR What I want to do is this: Use mysql as a dedicated database for a desktop BR application, meaning that basically there's only one client allowed to BR connect to it, and that client is the application. Also, I would not want BR this database to interfere with any other instance of MySQL that may be BR running on the same machine. Basically to be completely wrapped and only BR accessible by the application. BR My question is: is there a relatively simple way of doing this? start another mysql daemon with different socket path and configuraton file. in config file set up new path to databases. Also change priveleges in new server for more secure access. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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 ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: MySQL Client Software
Mysqlfront from www.mysqlfront.de and ursql from http://www.urbanresearch.com/ Sommai Fongnamthip At 11:46 1/8/2001 -0700, Faiz Khan wrote: Hi there, I am having problem finding MySQL Client software to connect to Web Hosts server so i can create tables and run queries at their server remotely. I am running windows so any related softwares would be great help. Please reply soon as i need to proceed on project and really need aforementioned piece of software... Thanks, Faiz - 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: Version question...
3.23.40 is stable on Linux too. At 18:46 1/8/2001 -0500, Gerald R. Jensen wrote: Garth: I would go for the current version (3.23.39a). The current version went on the stable list a long time ago, and has a boat-load of function/featur eimprovements that either did not exist in 3.22.xx or were not fine-tuned to the extent they are in the current stuff. Gerald Jensen - Original Message - From: Garth Hansen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 01, 2001 3:29 PM Subject: Version question... Quick question for everyone Which is the most stable version of MySQL for Windows NT Server version 4.0 SP6? I have conflicting information as to which is more stable, and want to be sure I use the most appropriate version for what we are trying to do. Also, if there is some major reasons to go with one version over another, please let me know! Thanks tons in advance! Garth - Garth Hansen Cognitive Concepts Network Engineer 990 Grove Street Suite 300 (847) 570-3617 voice Evanston, IL 60201 (847) 328-5881 fax http://www.earobics.com [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 - 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
tmp table
Dear, I'd like to use some temp table (not establish from create new table and could delete itself when finished job) when I grab data from any real table. Please describe with MySQL console, PHP or programming language with API. Sommai Fongnamthip - 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: Moved MySQL to new machine.
try to see more detail in INSTALL, it tell us about file and directory permission. If you have more problem with /var/any dir why did not use /statedir=/usr/mysql/data while configure to relocate MySQL data directory insteady use in /var/... Sommai Fongnamthip At 11:47 26/7/2001 -0500, Gerald Clark wrote: 13 is access denied. Your /var/lib/mysql ( Or whatever ) is owned by root, and mysql can not create a new directory. Jeremy wrote: I recently moved my MySQL databases from one RedHat Linux 6.x machine to a new RedHat 7.0 machine. Now, I can't seem to add databases. I get the following error message: mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'jrtest'. (errno: 13)' And, I think I lost some sequences. I'm using Phorum for a message board. The sequence table was at 2942, but when I try to write a record to it, it changes the sequence back to 1! Is this a MySQL problem, or a problem with Phorum? Any help that you can render would be greatly appreciated. Jeremy -- Gerald L. Clark [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
last record alert
Dear, I decided to collect data into MySQL for realtime display usage. How could I know there are new records add to table and retrieve them to display? Is there different to do this with VB (Client/Server style) and PHP (Web Bases Style)? Thanks Sommai Fongnamthip - 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
query to display per page
Dear, I am preparing my web page to display search result. How could I use SQL command to handle display specific row per page and next button at the bottom page (like most search engine display result). Sommai Fongnamthip Remark: Could I use this SQL command with PHP or perl? - 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: odbc on WinME
try download full windows odbc setup (not download only .dll). Then, follow with Setup.exe. Sommai Fongnamthip At 07:39 11/6/2001 -0700, Bob Andrews wrote: I recently downloaded the ODBC client software for windows, ran setup, then went into the 'ODBC Data Source Administrator' from the control panel per the readme. I tried to add a new datasource, but MySQL was not in the list so apparently the setup program didn't work as expected. Any suggestions on what to check? (Just saying that this worked for you is not what I am looking for.) Perhaps there's a registry entry I should check? 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 - 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 too slow....
If you use Delphi or VB, VC, there are some API program that let you access MySQL direct. Not worry about ODBC. Sommai Fongnamthip At 01:00 7/6/2001 -0700, Van wrote: Muhammad Asif wrote: i have a table with 1 records in MS Access and MySQL with no index in either database. I query both tables from ColdFusion using ODBC datasources and Data from Access took 13sec to display while Date from MySQL took 23sec to come up MySQL seems to be half way slow should i use index etc comments??? Muhammad: ODBC is slow in MySQL. Make sure you're using a current MyODBC driver. If that doesn't help, don't know what to tell you. Many people use straight network queries which avoid this overhead. Keep in mind, ODBC was a standard M$ put in place because their desktop OS is ubiquitous. Oracle wouldn't need an ODBC layer if M$ didn't have a monopoly on the desktop. There would be better db communications interfaces, instead. Indexing fields you query often is a given. But, you know this, I'm sure... Regards, Van -- = Linux rocks!!! http://www.dedserius.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: Need help on mysql/php
split code for use username and password to connect to MySQL into other file and use include in every php program instead have username and password code. connect.inc.php ? // define database connect variable $hostname = localhost; $username = root; $password = password; $tblname = yourtablename; $dbName = yourdbname; MYSQL_CONNECT($hostname, $username, $password) OR DIE(Unable to connect to database); @mysql_select_db($dbName) or die(Unable to select database); print Succesful connect...; ? readfile.php ? include (connect.inc.php); ... other php code ... ? Regards, Sommai Fongnamthip At 22:37 5/6/2001 +0100, Jorge Oliveira wrote: Hi again, You are right, your username and password will have to be on every PHP script that needs to use database. However, you don't have to be afraid because nobody can access the source of your PHP scripts - unless they are a good hacker! I think you should pay a visit to http://www.php.net to understand how PHP works. Start with the basics and you will see that is reallY VERY simple. Be cool, Jorge Oliveira [EMAIL PROTECTED] © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com -Mensagem original- De: Ed Peddycoart [mailto:[EMAIL PROTECTED]] Enviada: Quarta-feira, 6 de Junho de 2001 0:29 Para: Jorge Oliveira; Mysql@Lists. Mysql. Com Assunto: RE: Need help on mysql/php Thanks...this helped...Just had success in connecting to the MySQL server and dumping the db contents to the screenOne worrisome bit though...My username and password for connecting to the db on my host is my username and password for the web account. If I want to create dynamic webpages by pulling data from my db, won't I have to put this information (usersname and pw) in the php file and leave it on the server? Sounds pretty darn scary to me...maybe I am confused. Ed -Original Message- From: Jorge Oliveira [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 12:47 PM To: Mysql@Lists. Mysql. Com Subject: RE: Need help on mysql/php Hi, Please refer to http://www.php.net/manual/en/ref.mysql.php Jorge Oliveira [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com -Mensagem original- De: Ed Peddycoart [mailto:[EMAIL PROTECTED]] Enviada: Terça-feira, 5 de Junho de 2001 21:31 Para: [EMAIL PROTECTED] Assunto: Need help on mysql/php I recently move my website to FastWebServers.com. MySQL and PHP is provided. I have a control panel which allows me to initialize MySQL for my use. The initialization creates a db, named celticblues_com (my domain is celticblues.com). So far, I have added a table to my database, and added the neccessary fields. Now I am at a total loss at what to do. I want to use PHP scripts to pull info from the db and search the db etc. I have contacted my support from FWS, but they point me to MySQL.com for Mysql commands technical support. Seems to me I would need to know how to set username/password to access the db from script etc. The bottom line question is can someone point me to information on what I need to do to be able to access(open/close) the db, retrieve/store information, etc. in this type of environment (i.e. MySQL provide by my host service, not installed by me)? Ed - 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 - 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: auto start
try to edit rc.local file instead of use cat command because it may be destroy existing code. SF At 00:19 5/6/2001 -0700, Van wrote: Francois Boucher wrote: Somebody install Mysql and apache for me, but forgot to set it auto-boot Each time i reboot i need to do # safe_mysqld --log --user=mysql and # apachectl restart I want it auto-boot, what can i do? François Boucher [EMAIL PROTECTED] Francois: This is a UNIX/Linux question, but, I see your dilemma. It's a shame you're finding it necessary to reboot. The following should save you for now: cat /etc/rc.d/rc.local safe_mysqld --log --user=mysql apachectl restart [ctrl][d] That should take care of it. Mind the double redirect , or you may lose something else. You might want to brush up on the *n*x init process, also. Just a tip. Regards, Van -- = Linux rocks!!! http://www.dedserius.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
which the best
Dear, I know this is not list for ask about OS, but I wonder to know that which OS you choose for database server in your mind? Linux Red Hat 7.1 Linux Mandrake 8.0 Windows NT 4.0 Windows 2000 Server or anything else from these OS! Regard, Sommai Fongnamthip - 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: $dbh-tables, SHOW tables, etc.
I am using mysql 3.23.xx on linux 6.2. I have been use gcc 2.91. I can use show database and show table in mysql prompt. I wonder that why did you cannot use these function and must upgrade gcc. Sommai Fongnamthip. At 11:10 26/5/2001 +, Greg Cope wrote: Daniel wrote: Scratch that, normally egcs and gcc are the same, at least on older redhat distros. Redhat 7.0 gives you compat-egcs package which isn't the same as your gcc. I symlinked (on a 7.1 redhat box) egcs to gcc (2.96-69) and --rebuild 3.23.38 from the .src.rpm. Both show tables, show databases now work. I come across this problem - and its complier / optimisations related. gcc 2.92.3 + pgcc patches works OK for me. 2.92.3 plus optimisations is can fail. YMMY - but ditch 2.96 until its safe ! Greg Thanks for the heads up Colin. Daniel wrote: I'm up to 3.23.37-1 (compiled with gcc 2.96-69). Haven't had one work properly starting with 3.23.32. Gulp...It's been months now. Thanks for the reply though, -- Daniel Bohling NewsFactor Network - 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: MySQL and PHP4
Dear, easy way to install another application with mysql is specify mysql dir and mysql data dir at installation. use this parameter while install mysql ./configure --prefix=/usr/local/mysql \ -- this will install all mysql --localstatedir=/usr/local/mysql/data -- this will keep all data and log when u install php use this command ./configure --with-mysql=/usr/local/mysql This method make clearly install for me. SF At 10:18 25/5/2001 +0300, Andrey Kotrekhov wrote: On Thu, 24 May 2001, Scott Baker wrote: I don't agree. If mysql install in other directory then /usr/local you need use --with-mysql=mysqldir and sometimes --with-mysql-include and --with-mysql-lib options. Do you need to specify a directory? I just did --with-mysql At 01:14 PM 5/24/2001 -0400, Bill Tangren wrote: When I compile PHP4 (4.04pl1) with the option --with-mysql=mysqldir... I get the error 'cannot find mysqlclient library under mysqldir' I did a search through the mysqsl (3.23.38) source code after I compiled it, and I don't find that library anywhere? What am I doing wrong? - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] You may be disappointed if you fail, but you are doomed if you don't try. - Beverly Sills - 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 ___ Andrey Kotrekhov [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
how to install new version
Dear, I was install mysql-3.23.35 or other old version with Apache+SSL and PHP. When MySQL launch new version, How could I do to install new version and do not make corrupt to other application??? (if anyone can help more, how could I do with new version of Apache and PHP). Regards, Sommai Fongnamthip - 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 question
Dear, I have just try to used innodb feature on linux 6.2 box. I have a little confuse to startup but last i can do it. when I started, my server (64M Ram and 3 gb disk space) go slower than without innodb feature. I would like to ask someone who has experience use innodb. - how many ram and disk space match for innodb in linux platform - how could i specific innodb parameter in my.cnf - could i use innodb now for transaction feature or wail until mysql ver 4 Regards, Sommai Fongnamthip - 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
newbie question
Dear, I apologize if this question stupid. I was see many question about MySQL file system with the word INNODB, MyISAM and other. I wonder which the best type to use in Linux because I did not know more about Unix file system. So, I was install mysql by default and I want to know which db type installed in my sytem Sommai Fongnamthip - 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 crash continued
Hello, I am running MySQL (3.23.xx) on Linux RedHat 6.2 and plan to increase volume of data in the near future. So, I would like to know some db schema , total row and your SQL you used to protect my database. Sommai Fongnamthip At 20:56 21/5/2001 +0300, Sinisa Milivojevic wrote: Rui Barreiros writes: hi, i've upgraded mysql server with 3.23.38 from mysql, and i have the same behaviour sinisa if you have some time i could give you access to one of the machines. :/ -- WEBSOLUT - Soluções Internet Emailto: [EMAIL PROTECTED] Personal Info: http://websolut.net/people/rui.html Are tables OK ?? Corrupted tables can still crash sometimes MySQL. If they are and that query or combination of queries always crashes mysql, then please mail to the [EMAIL PROTECTED] so that we may advise you where to upload your tables and queries that always crashes MySQL. Thank you in advance. 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 - 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 performance question
limitation about space and speed according to DBMS featuring. since MySQL still have not full SQL 92 feature (transaction, sub select... I think) make it eat a fewer space than other DBMS (oracle or informix) and it can speed up because it did not need to handle more condition. I did not know when MySQL support all today lack function in version 4, How many disk space and ram will require to handle more data? Sommai Fongnamthip At 18:52 21/5/2001 -0700, Joshua Chamas wrote: Shane Anderson wrote: I would like to know the limitations of Mysql with extremely large tables. I need to store 20+ million records. Each record would contain only 4-6 fields and would not be longer than 128 bytes of information. The records could be divided among several tables, but at what size is the performance hindered enough to need to split records between several smaller tables? Any information leading to an optimal solution would be greatly appreciated. MySQL doesn't have a real limitation on the # of records, but I speak only from 1/2 million record table experience. But there is a point to that, I split my tables to have no more than that number because I don't want to take my system offline for very long if I want to add an index, or recover my database from a server crash. MERGE tables might allow you to break up your large tables nicely. But what I'm saying is true for any database, that if you have 20 million rows, your database maintenance window has to be a lot bigger, so while the query speed may be great on myisam with 20 millions rows, your DBA ( or you? ) may be none too happy when adding that new index. Comparing Oracle vs. MySQL myisam tables, MySQL will save disk space, and provide you with much faster queries, but you have to be aware of the table locking issues if you are doing updates/inserts/deletes mixed with reads. --Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com1-714-625-4051 - 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
upgrade or re-install
Dear, I would like to ask someone who can suggest me about upgrade or re-install MySQL. If I have been install MySQL with other application (PHP, Apache, SSL or anything) by STATIC method (use tar file in Linux-Box). When I'd like to upgrade MySQL (or other application: PHP; Apache...) or Re-Install :: How could I do this to avoid missing or broken relate of all application?? Regards, Sommai Fongnamthip - 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
recursive select
Dear, I have an table which like to use recursive join but I wonder how to use it. Please see the table struc below. emp.id,emp name, emp salary, emp head-id 001,mr. a,1,001 002,mr. b,5000,001 003,mr. c,5000,003 004,mr. d,5000,003 Where emp. head-id is id from emp.id. If I'd like to know which head count name of id 002 (it must shown name from id 001). How could I do with mysql? Regards, Sommai Fongnamthip - 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
upgrade mysql version
Dear All, I was installed MySql 3.22.32 with PHP and Apache and I decide to upgrade to 3.32.32. Could I only install New version of MySql or reinstall all of related software (PHP Apache)?? Thank you, Sommai Fongnamthip - 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