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

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

Re: Why v3.23.49 does not build on RedHat 6.2 ?????

Hi, What's wrong with GNU-cc 2.96? Why could we use 2.95 (and old 2.91) or above 3.*? 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

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

RE: buggy round()

Hi all, ROUND decimal value is the mis-understood between MySQL internal function and another environment/programming. I found that MySQL-Round is correct within the suitable of itself (you can say it correct in C library or other word it correct in technical term), but it did not use

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 inde

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/20

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\"

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 th

Re: insert into with sub select

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: >

Re: insert into with sub select

r. 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]> wro

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 i

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 cou

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

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 t

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

RE: update data from other table

upports sub-selects. > >Then and only then you can use something like this: >UPDATE t1 SET t1.col = (SELECT t2.col FROM t2 WHERE ) WHERE >; > >As far as I can tell not even in MySQL 4.1 can you use JOIN with UPDATE. > >----- > > >Original Message: >

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 >

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

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

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

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 u

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 (tran

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

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

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

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 ---

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 t

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 wi

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 -

version conflict

Dear List, I was installed mysql-3.23.47 in my Linux box with PHP. I could shown version correctly with mysql command line or any windows client tools. It still shown in phpinfo with version 3.23.37 (old version before upgrade). What wrong? SF -

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 effec

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 summar

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, >Cre

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 na

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 >bo

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 gre

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

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 mk

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) | ++ |

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 - Befor

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 mk

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.

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

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

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 ---

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 & passw

Re: Dedicated MySQL Application Server

t. 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]> > &

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

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 q

Re: Update with WHERE from multiple tables

Could not update from table1 to table2 in 1 statement (MySQL limit: Pls see manual) try select what you want to update in buffer then put it in loop (look slower than 1 statement but try to see how it fast enough) Sommai Fongnamthip At 04:34 30/7/2001 -0400, Steve Prior wrote: >Here are s

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 Fongna

Re: excell text file to mysql table using php admin?

Try this save any file format to .csv and use this statement in your program load data local infile 'c:\\dir-in-harddisk\\filename.csv' into table hr.trn fields terminated by '\,' this command was in MySQL Manual Sommai Fongnamthip At 04:47 27/7/2001 -0400, Glyndowe

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/ 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

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

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 Administrato

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

Re: MySQL too slow....

If you use perl or php you didnot need odbc to connect MySQL. There are built-in function to do this for you and of course it fast. SF At 14:19 7/6/2001 +0500, Muhammad Asif wrote: >I want to use MySQL in web based >applications. Can u tell what other way i can go except ODBC >if i have to que

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 ind

Re: update with 2 table

You have written the following: > > >Dear, > I known that we can not use update table from another table > (update table1 >set table1.field = table2.field). Someone suggestion use select to temp >table before update. I wonder how to do this and how data in temp

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 readfile.php Regards, Sommai Fongnamthip At 22:37 5/6/2001 +0100, Jorge Oliveira wrote: >Hi again, > >You

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

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 --

Re: can not save the .pdf version of MySql manual

If you use IE which associate to PDF file, it may be take a long time to display when you click on the link. Try to use download feature instead display (click right mouse on link and choose save target as or download with getright/if you have one installed) Sommai Fongnamthip At 09:20 2/6

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: > > &g

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

innodb question

. - 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

how to install new version

, 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 unsubscr

newbie question

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

Re: MYSQL performance question

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

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

upgrade or re-install

pache...) 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)

mysql manual

I was d/l mysql manual for latest version in other format in d/l section, but i still got manual only version 3.23.33. How could I do? Regards, Sommai Fongnamthip - Before posting, please check: http://www.mysql.com

recursive select

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:

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 Fongnam