RE: We have just moved to a new web server where we are runningmysql version: 5.0.45

> We have just moved to a new web server where we are running mysql > version: 5.0.45 > On the old machine, when we gave the following command: > update table1 set passwd = password('xx') where user_name="xx"; Here you're updating 'table1'... > and then gave the following command, > SELECT us

RE: Select form a list

> i have list where I would like make a select, this list look like this > > id Properties Others > * > 11 sss > 22 sss > 32 a etc... > 42 > 52 > 61 > 72 > 82 > 9

RE: changed directory name

This is actually a PHP issue and nothing to do with MySQL. You're correct in that since you renamed the directory, the scripts can't find their includes. Ideally, they should be using relative path names and/or setting the include_path php.ini variable to avoid this. The quick however, answer is

RE: order by in query

> > Hello i use this query: > > select i.item_id > from orders o > INNER JOIN item i ON i.nr=i.nr Should the line above not be ... ON i.nr = o.nr ? > INNER JOIN user_cart u ON u.nr=i.nr > where (i.count !=0 or i.count!=NULL) and i.isactive=1 and i.kolWo>0 > order by i.count DESC > LIMIT 5 >

Finding the 'nearest' text match

I have two datasets that I wish to relate together using the company name. The problem is the same company may have a slightly different name in each the two datasets. What I want to do is for each company name in dataset A, find the 'nearest' n matches to it in dataset B. e.g. If I have 'Alkool

RE: more elegant way to store/find phone numbers

> hi listers > we have a mysql based application, wherein phone numbers may be stored > and searched for. it is not the primary goal of this application to > handle phone numbers. > > phone numbers usually are entered in a form like 099 999 99 99 or > 099-999-99-99, or substings thereof. actually,

RE: How to match a UTF-8 field with acute vowels words in "BOOLEAN MODE"?

> Hi. > > Using mySQL 4.1.22, I'd like to carry out an SQL query to find a > string containing acute vowels. > > mytable: > - item1: > --- firstname: Antonio > --- lastname: Fernández > --- comments: he's from Spain > > My SQL query: > -- > SELECT id FROM mytable WHERE MATCH(firstname, lastnam

Re: Does this MySQL client exist?

Christoph Boget wrote: I did a search and couldn't find anything like what I'm looking for and though I doubt something like this does exist, I figured I'd ask anyway. Is there a client (not phpMyAdmin) that can connect to a server (that is running MySQL) using SSH and connect to the database th

RE: MySQL DateTime Source on CentOS 5

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 13 September 2007 15:32 > To: mysql@lists.mysql.com > Subject: MySQL DateTime Source on CentOS 5 > > > I'm running Apache/MySQL/PHP5 on a CentOS 5 server and have > started to get > some strange date and time i

RE: changes in tables (developemnt -> production)

> what steps do you recommend to do the tables update on the production > database? When I work on our site DB, I follow the following steps: 1. Trash the existing dev DB and replace with the current live version 2. Develop! 3. Dump all the tables I have changed (structure and/or data) using mys

RE: LOAD DATA INTO doesn't work correctly with utf8

> I would like to import data from a utf8-coded comma seperated file. I > created my database with "DEFAULT CHARACTER SET utf8 COLLATE > utf8_general_ci" and I started my mysql-client with the > --default-character-set=utf8 option. Nevertheless, when I input primary > key fields, which differ only

RE: Import file into MySQL Database..

> -Original Message- > From: Jason Pruim [mailto:[EMAIL PROTECTED] > Sent: 09 August 2007 14:16 > To: Gary Josack > Cc: mysql@lists.mysql.com > Subject: Re: Import file into MySQL Database.. > > > > On Aug 8, 2007, at 5:19 PM, Gary Josack wrote: > > >> > > Try: > > > > |load data local in

RE: MySQL in read-only mode

> -Original Message- > From: Clyde Lewis - DBA [mailto:[EMAIL PROTECTED] > Sent: 03 August 2007 16:55 > To: MySQL List > Subject: Re: MySQL in read-only mode > > > The idea here is to perform this change without restarting the > server. Is that possible? I know that by updating the config f

RE: left join, right join failure with mysql4

> hi > > i am experimenting with sql for getting lists of friends. > > select friend.* > from user >left join link on user.id=link.id and user.id = $MYID >right join user friend on link.friend_id = friend.id > where user.name is null; > > on my local windows machine running mysql 5

RE: Hiding columns used in GROUP BY and HAVING clauses

> -Original Message- > From: Baron Schwartz [mailto:[EMAIL PROTECTED] > Dan Nelson wrote: > > In the last episode (Jun 18), Edward Kay said: > >> From: Dan Nelson [mailto:[EMAIL PROTECTED] > >> > >>>>>> At the moment, I have thi

RE: Hiding columns used in GROUP BY and HAVING clauses

> -Original Message- > From: Baron Schwartz [mailto:[EMAIL PROTECTED] > Sent: 18 June 2007 15:53 Sent: 18 June 2007 15:11 > > > > > > > > At the moment, I have this and it works: > > > > select * from contact_address > > group by primary_entity_id > >

RE: Hiding columns used in GROUP BY and HAVING clauses

> -Original Message- > From: Dan Nelson [mailto:[EMAIL PROTECTED] > Sent: 18 June 2007 15:11 > > > > At the moment, I have this and it works: > > > > > > > > select * from contact_address > > > > group by primary_entity_id > > > > having count(primary_entity_id)

RE: Hiding columns used in GROUP BY and HAVING clauses

> -Original Message- > From: Dan Nelson [mailto:[EMAIL PROTECTED] > Sent: 15 June 2007 19:24 > To: Edward Kay > Cc: MySQL List > Subject: Re: Hiding columns used in GROUP BY and HAVING clauses > > > In the last episode (Jun 15), Edward Kay said: > >

Hiding columns used in GROUP BY and HAVING clauses

I have a table of addresses. Each address is associated with a primary entity and a primary entity can have n different addresses. For each primary entity, one address is marked as the main address. I need a query to return all addresses that are the only address associated with the primary entity

RE: Administrative Tools

> Check out http://www.sqlmanager.net/en/products/mysql > http://www.sqlmanager.net/en/products/mysql > > AndrewMcHorney wrote: > > > > Hello > > > > I am looking for the tools that I would use to be able to do > > administrative duties and to be able to create and update databases > > (table

RE: selecting second last row

> SELECT * FROM news WHERE display='yes' ORDER BY id desc limit 1 > > Think this would get the lastest article that is to be displayed > but how do I get the second one. > Just add an offset to the LIMIT clause: SELECT * FROM news WHERE display='yes' ORDER BY id desc limit 1,1 Edward -- My

RE: a function to convert a uk date to and from mysql date

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 22 May 2007 15:47 > To: mysql@lists.mysql.com > Subject: a function to convert a uk date to and from mysql date > > > Hi, > > My UK dates are this format DD/MM/ I want it reversed and > then the seperator

RE: Network address functions in MySQL?

> -Original Message- > From: js [mailto:[EMAIL PROTECTED] > Sent: 15 May 2007 15:31 > To: MySQL List > Subject: Network address functions in MySQL? > > > Hi. > > Today I found postgresql's neat feature, inet operators, > which allows you to do > > inet '192.168.1/24' >> inet '192.168.1.

RE: adding 3 values

> > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: 10 May 2007 10:08 > > To: mysql@lists.mysql.com > > Subject: adding 3 values > > > > > > Hi, > > > > I have 3 integer values in the table single_rooms, double_rooms, > > twin _ooms but want to add th

RE: adding 3 values

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 10 May 2007 10:08 > To: mysql@lists.mysql.com > Subject: adding 3 values > > > Hi, > > I have 3 integer values in the table single_rooms, double_rooms, > twin _ooms but want to add them all up to do a co

RE: Enforcing Data Format

> > Is it possible to enforce data formatting in fields using > something like > > a regular expression? > > varchar is great but does not stop someone putting in the wrong > > reference number. > > Dates should be in a DATE column, not a varchar. The OP says 'data' not 'date' :) He is talking ab

RE: MySQL Workbench

> -Original Message- > From: Mogens Melander [mailto:[EMAIL PROTECTED] > Sent: 01 May 2007 21:44 > On Tue, May 1, 2007 21:36, Afan Pasalic wrote: > > Hi, > > I'm looking for database modeling tool form MySQL. Anybody used the > > MySQL Workbench? I know the Workbench is in Alpha productio

RE: ORDER BY multiple columns

> From: Baron Schwartz > Hi Edward, > > Edward Kay wrote: > > Hi, > > > > I have a query that returns data from a join of two tables, person and > > company. The results look like: > > > > FIRST_NAME | LAST_NAME | COMPANY_NAME > > -

ORDER BY multiple columns

Hi, I have a query that returns data from a join of two tables, person and company. The results look like: FIRST_NAME | LAST_NAME | COMPANY_NAME - NULL | NULL | Toy Co Mark | Smith | NULL NULL | NULL | Big Corp NULL | NULL

RE: character_set_xxx

> How can I change character_set_xxx variables in MySQL 4.1.x in Linux? SET NAMES '' http://dev.mysql.com/doc/refman/4.1/en/charset-connection.html Edward -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]