Re: MySQL Query Help Needed

I think the most difficult ( if not impossible with just using mysql query) is the part where you apply your logic as to the "most relevant" keyword. You need to be able to have a mechanism of telling the query which keyword is the most relevant, ie, human logic says, the one that matches the searc

Re: MySQL Query Help Needed

Not sure I understand what you need? Can you create a dummy output table of what you would like your result to look like? At first glance, from reading your question, it sounds like you simply want this: select * from ppc_keywords where keywords like "%job%" [group by keywords] order by bid; whe

RE: SELECT only unique records

Sorry for "hijacking" this question, but while we are on this topic: How can one select unique rows based on a set of fields select distinct state_ID from financial_master where category_id='1' only returns rows based on the uniqueness of one field. what if there is another field that COMBINED w

Re: "table is read only" after copying table files to new server

Hi Bennett I had a similar problem on my system a while back. With my particular case, the problem was the the default priv's on the new server for it's users did NOT include INSERT rights. Basically what I'm saying is: these are the reasons for a table to be (or appear to be) read-only: 1) Table

RE: help to structure query without using subselects

t to make sure that you (or anyone else interested in this thread) understands exactly what the question is ( believe me, after a while thinking of it myself, I sometimes lose the entire question completely inbetween all the "if" "and" and "or"'s flying through my

help to structure query without using subselects

Hi List Can anyone help me to do the following without the need of subselects: I have a table that contains rows where mostly, the only common field is the "name". The rest of the data fields, even though they are related to the "name", differs from row to row ( they are things like the address

Re: Re: Re: cant connect to mysql server through socket

Don't stare too long at the Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) , it will blind you after a couple of minutes ;p Seriously, the fact that the sock file is not there simply tells me that mysql is not running, ie, even if you could "copy" a mysql.sock f

Re: Re: cant connect to mysql server through socket

isted processes. I checked mysql folders > under several > directories , they are owned by root. Also mysql start/mysql stop etc. commands dont > work producing the > same warning "Cant connect.." What can i do more? > Thanks > Devrim > > Petre Agenbag <[EM

Left Join multiple tables

Hi List Me again. I'm trying to return from multiple tables, the records that have field "information_sent" between two dates. The tables are all related by means of the id of the entry in the main table, ie.. main id entity_name ... fof id_fof id information_sent ... pub id_pub

subselects or join?

Hi List, My head is not on right today. I have something like this: main_table id namemain_type 1 joe type1 2 johntype2 3 jacktype1 table type1 id_type1id action 1 1 2003-07-01 2 1 2003-08-03 3

Re: cant connect to mysql server through socket

1) make sure mysql is running [and as user mysql] do a ps -aux to see. 2) make sure that the mysql folder and files are owned by mysql (ls -l) On Sun, 2003-07-27 at 10:38, D. K. wrote: > Hi; > I have installed suse 8.2 a short while ago and at my first attempt to connect mysql > (via shell and

Mysql lockups

Hi List Been trying to help out with this problem on a SunOS5.8 box running 3.23.56 It experiences periodic lockups of mysql. It does not seem that this server has a my.cnf file for mysql, and I'm not sure if that matters (what are the defaults mysql use when it cannot find the .cnf file?) Anywa

Re: any help with my.cnf plz?

Lenz Thanks for the reply, will go to the link immediately. I would just like to clarify something: I have 3.23.56 , your's is 4.x, does it matter? I should obviously just leave out the stuff that is not relevant like InnoDB support etc... CAn you give me possibly pointers to the absolute cru

any help with my.cnf plz?

HI Is there ANYONE that can help me with a my.cnf for a large site for version 3.23.56, or even just where I can download one? I am trying to download that version and then get my own, but the dl times out... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

my.cnf for 3.23.56

HI List Need advise on a suitable my.cnf for 3.23.56 on SunOS5.8 MySQL is installed on a virtual machine with plenty of ram and swap space. However, there is no my.cnf file currently, and mysql seems to lock up completely from time to time even though system seems fairly stable (although I saw som

Find entry with max date.

Hi I have a relational db with a couple of tables holding things like comments and complaints and actions. In the "main" table, I have the contact details. What I'd like to do is to query the db with a php app and to display the entries in the result set with a "last action/comment/contact" done

Re: import from MySQL into MySQL

If you cannot get file system access on the webserver, then you will need to dump the contents of the tables into a text file with the appropriate dump commands. If the webserver has something like phpMyAdmin, you can use that to easily create a text file that you can then import into your mysql o

Re: "reset" id of tables - SOLVED

Nevermind, found it: truncate table; On Mon, 2003-06-23 at 15:59, Petre Agenbag wrote: > Hi List > > Probably a stupid question, but I want to know if there is a quick way > to reset all the id's on my tables to 0? > I ran a whole bunch of "tests" on the ap

"reset" id of tables

Hi List Probably a stupid question, but I want to know if there is a quick way to reset all the id's on my tables to 0? I ran a whole bunch of "tests" on the app; writing and deleting to the tables, and would like to "reset" all tables to start at 0 when I make the app "live". Thanks -- MySQL

ETA on 4.1

Hi List Is there any way to get an estimate of the release date of the next stable version of MySQL? The reason I'm asking; I am currently busy configuring new webservers, but it is not crucial as to the exact time I deploy them ( they will replace currently running servers), so if I knew 4.1 woul

Re: Getting the row back with the highest ID.

Thanks, I presume that subselects is not yet featured in MySQL 4.0.13? ( Sorry, can prolly get this by RTFM ), If it does, how would the query look? Thanks On Thu, 2003-06-05 at 11:44, Egor Egorov wrote: > Petre Agenbag <[EMAIL PROTECTED]> wrote: > > > > I think I'm

Getting the last entered row from a relational table

Hi List. I think I'm having a very off day and need some confirmations on how MySQL works with it's result sets. I have a couple of relational tables , the first holding the person's name and address for instance, and the other tables holds comments and complaints respectively. Each table has it'

Getting the row back with the highest ID.

Hi List. I think I'm having a very off day and need some confirmations on how MySQL works with it's result sets. I have a couple of relational tables , the first holding the person's name and address for instance, and the other tables holds comments and complaints respectively. Each table has it'

unique results

Hi I am having trouble with a query to return only one instance of a name in a table. For instance: id nametowndate 1 jacktown1 2002-12-12 2 johntown2 2002-12-13 3 jacktown4 2002-12-21 4 jacktown5 2002-12-30 5 johntown2 2002

distinct and distinctrow

sql,query Hi List Please can someone help me with this: I need to "filter" duplicate entries from my result query, but there's a twist... The table has something like this: id namekey 1 name1 key1 2 name2 key2 3 name3 key3 4 name1 key1 5 name 1 k

search through entries

HI can someone help me with general search syntax. I want to search a table with a search string obtained from a form input ( PHP/Mysql app) The problem is: Lets say there is an entry in the table: "John Doe" When I search for that, with something like: select * from table where name like '%$

Linux conf files in mysql tables

mysql,query Hi List Not sure if this is the right list to post to, might need a cross posting on a general Linux list as well, anyway; I would like to explore the possibilities of having (or "converting") all Linux services use mysql tables for their configuration files instead of the usual flat-

slow queries

mysql,query Hi List I have a couple of slow queries listed in my slow log, but I don't know what to do from here to make them "fast". Here is an "EXPLAIN table": mysql> explain w3t_Users; ++--+--+-+-++ | Field | Type

Re: How to port MS Access to MySQL ??

myodbc works fairly OK for me. On Fri, 2002-11-08 at 14:17, tmb wrote: > Is there a tool for doing a quick port from MS Access > to MySQL? > > Or must you manually create all the tables & sql > statements in MySQL and then export the MS Access data > to a comma delimited file... then import it in

unique data sets

Hi just out of interest, How can I create unique "data sets", or rather, set a set of data as unique, to prevent another entry in the table that meets the same criteria, for instance: id namesurname address 1 johndoe 1 street 2 maryjane

re: Last row in table

Hi I want to "barge" in on this question, as it has bothered me in the past as well. The reason being: I did the last write to the table maybe a day ago, but I want to write a script that can give me some "stats" on the table at any time, so it also makes sense to me to be able to have a get_last_e

Re: lost connection inquery : ODBC

ike to know for future what causes this, as I'm to decide soon what to upgrade to, 7.3 or 8.0, at this point, I'm leaning heavily towards 7.3 as my gutt tells me this might be some kind of a bug. Thanks for the help so far. On Tue, 2002-10-22 at 22:07, walt wrote: > On Tuesday 22 October

Re: lost connection inquery : ODBC

t; for the host name. YET, when I try to connect from the localhost, it denies permission, only accepts connections from remote location ( not ODBC though, I used a php script on another host to test connection) Any ideas? Thanks On Tue, 2002-10-22 at 21:37, walt wrote: > Petre Agenbag wrote:

lost connection inquery : ODBC

query , sql Hi Any known issues with RH8.0 and ODBC? I keep getting lost connection messages when trying to connect from a windows box to mysql, it worked 100% on a 7.3RH box. There is no firewall. Any workarounds? - Before p

rolling over mysql logs

HI Probably a silly question, but how can I roll the logs for mysql? I started it with safe_mysqld --log-slow-queries --log & So it created two logs in my /var/lib/mysql folder, one holding ALL queries, and one for only the slow queries. The "general" log is growing quite rapidly, and I would lik

RE: loggin all calls made to mysql from php

ilename is not given, `hostname-s`-slow.log will be used. > > -- > Chung Ha-nyung > Sayclub <http://www.sayclub.com> > NeoWiz <http://www.neowiz.com> > > > > -Original Message- > > From: Petre Agenbag [mailto:internet@;boesmanland.com] &g

RE: loggin all calls made to mysql from php

Ha-nyung > Sayclub <http://www.sayclub.com> > NeoWiz <http://www.neowiz.com> > > > > -Original Message- > > From: Petre Agenbag [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, October 17, 2002 4:05 PM > > To: [EMAIL PROTECTED] > > Subj

loggin all calls made to mysql from php

HI I posted this question on PHP list as well. I would like to be able to log all mysql queries made from php scripts. I have had a couple of strange mysql lockups on my RedHat server, where mysqld process won't even be killed, and since no user works with mysql except through PHP, the normal mys

RE: and & or in query

or (field = "x" and (field = "a" or field = "b" or field = "c")); > > assuming that you want a record with "x" in field having either > > y or z in field or a or b o c in field > > HATH > > -Original Message- > From:

and & or in query

Hi I would like to issue a logical query as follow: select * from table where field1 = "x" and ((field2 = "y" or field2 = "z") or (field3 = "a" or field3 = "b" or field3 = "c")); But this syntax is not returning what I expect. Plz help me with syntax ---

Beta training program

Can someone plz send me the posting from mysqlab concerning the beta training , I deleted it accidentally... Thanks sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.

Re: MAX vs plain vanilla mysql

h, and why do I always get a returned mail when posting to this list, yet my message still seems to reach it? Thanks Petre Paul DuBois wrote: > At 19:31 +0200 7/2/02, Petre Agenbag wrote: > >> Thanks, >> So, if you install MySQL MAX, you can use either myisam OR innodb / >>

Re: MAX vs plain vanilla mysql

Thanks, So, if you install MySQL MAX, you can use either myisam OR innodb / bdb tables, ie, if I install ONE mysql max server, then different users on the server can use different types of tables(innodb/myisam) as they choose?, also, if you create one db, can you have different types of tables

Mysql vs MySQL max

Hi Probably a stupid question, but which is best to have on ones server, the "old" mysql, or max. I.O.W, if you install MAX and never use innodb or berkeley tables, will it be equivalent to a normal mysql installation wrt performance and stability? I'm asking from an ISP's point of view, if tha

MAX vs plain vanilla mysql

Hi Probably a stupid question, but which is best to have on ones server, the "old" mysql, or max. I.O.W, if you install MAX and never use innodb or berkeley tables, will it be equivalent to a normal mysql installation wrt performance and stability? I'm asking from an ISP's point of view, if tha

Re: Thank you!I need your help!

I think the problem is that the mysql package is still tarred. You need to tar -xvf mysqlx.tar This will extract the archive into a new folder, and from within that folder you should run the commands as listed in your original mail (./configure .) So in short, the commands you are tr

Frontend and report tool

Hi Can anyone tell me if they know about a good frontend for mysql with reporting facilities, or alternatively only a report generator? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual)

mysql backup ahead of re-install

Hi, Im running Linux 7.0 with mysql 3.23.35 installed via rpm. I have some very strange problems where web forms submitted to my php insert page seems to trigger an insert but only the new row's id gets inserted and nothing else. I have tried everything to reproduce the error from my side ( ov

insert problems

Are there any documented reasons why mysql would only enter certain fields and "skip" others? I am having some strange problems where it seems that data are randomly "dropped" from inserts via web forms. Have posted before stating a possible cache or proxy problem, but I am still at a loss...

Proxy server problems

Hi I have recently had some problems with web forms not updating the website ( use PHP and the insert page should first enter the form data into a table and then update the status field in a second table correlating to the entry just made), hoever, only the first sql seemed to go through and t