query

hello i hv one query as explained below : Table FIRST contains This is What is this how whom color white Table SECOND contains WHOM THIS IS WHAT WHITE AND BLACK i want the result as This is what is this what whom white WHITE AND BLACK i want a query which searches both table for exact

mysqlinstall-error

hello all i installed red hat linux 9 in my home s/m and i tried to install mysql mysql-standard-4.1.10a-pc-linux-gnu-i686.tar.gz i have followed the steps for installation. the installation dir is /usr/local/mysql installation will go smoothly. but when i try to start, it stars and ends

regarding cron

hi i have a prgrm which dumps the data extracted from the txt file to database. i want to run it using cron daily.i m using mysql as backend. when i run this program using my shell script it will run and insert data into the database. but when i give the same in cron it will not work ? what

groupbyorderby

hello, can we give the same field name in group by and order by ? Eg. select count(*) from table group by filedname1 orderby filedname1 desc; = kavi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

orderbymonths

hello, is there any way so that months r ordered as that of calender year. means . i have a month field of 3 chars. like Jan, Feb, Mar etc when i select distinct months , the result will be displayed in the calender year month order. but if i use order by mon then this order jan,feb,mar will

backup of database

hello, how to take a backup of database? i have a database with name1 now i want to move all the tables into another database? how to do? kavi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

free graphing tool for perl and mysql

hello, thank you for info. but i want one graphics tool which is free. i m using perl and mysql. i am also searching for the graphics tool which i can use for the data in mysql table or the output by my perl program. if anyoneknow abt this please do reply

redirectingerror

hello, the questn may be simple.but i m still in learning stage so please dont get angry. thank you how to redirect every single error cmg in program with database connection to other place than standard error log. my error log is growing so fast so want to avoid error log for any type of

distinctSelection(veryUrgent)

hello, i m using mysql 4.0.18-standard version it is not accepting subqurries. problem is: i have 2 tables: First(id,Flower,Color); = color is char(2); Second(Shop,Date,Flower,Color); first table will contain only unique flowers , and colors, id is autoincrement. second

manyaccesses

hello, if a progm read difft tables for some 10 times for one run each day..how will be the load on mysql server. usually how many table accesses per run will be there if a company is maintaining an export business and daily read and write will be there on tables.

DBI-connect does not work in crontab but works interactively

hello, i have a shell script with 6 programs. if i run it directly as : sh first.sh all progrms with get executd and everything works fine. but if i give this script in crontab using 0 10 * * * /two/three/name.sh Only progs without database connection will get executed . but database

selection

where code='NP'; it works; why is it so bcoz of the Space between 2 words, the problem arises ? How to retrieve such fields then by giving specific value? can anybody help me N. Kavithashree

copy2diffdatabase

hello, i hv a database ONE with some 10 tables; i want to have a backup so how can i copy these tales to another database in the same server and also to any other server? N. Kavithashree

how to select last records

to select from particular row no to othereg. row 10 to row 30 ? like this? N. Kavithashree === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Query--SelectionFromSameTable

which have flower entries for the same date , same regno and same codeno. 3) To retrieve records which doesnt hv a flower entry for the same date as that of perfume N. Kavithashree === -- MySQL

writing subquries in 4.0.18 version

where id IN (select id from table as T2 where one = 4 ); this syntax will not work.how to go ahead or which version documentation i can refer? N. Kavithashree === -- MySQL General Mailing List