order by clause on a left join with 1 record in the main table makes empty result

>Description: table one has only 1 record (table one: ID, some_description; table two IDone), table two has records but none matching one.ID=two.IDone (table two: ID, IDone, some_text, some_int). doing a query like "SELECT one.ID,isnull(two.some_int) AS don

best way to search a col with csv's?

Hi all, I'm a bit of a searching newbie, What sql functions should I be looking at to return any rows containing a search phrase [eg 'Bob Smith'] from a column which may contain 1 OR MORE comma separated values? Take this example table: id speakers date sample data: 1 Joe Blo, Jane Smith 2002

快速有效治疗强直性脊柱炎

mysqlÄúºÃ! Ìì½òÊб±´óҽԺǿֱ¿Æ¼Ì³ÐÖйú´«Í³Ò½Ñ§µÄ¾«Ë裬·¢¾ò³öÁËÇ峯Ãñ¼äÌØЧ ÖÎÁÆÇ¿Ö±ÐÔ¼¹ÖùÑ×µÄ"ÎâÊÏ"ÖÐÒ½ÁÆ·¨£¬ÓÐЧÖÎÁÆÇ¿Ö±¼¹ÖùÑס£ ¸ÃÁÆ·¨²ÉÓöÀÌصĽ«Ö²¡Òò×ӰγöÌåÍâµÄ·½·¨,Ó¦ÓÃÏÊÖвÝÒ©Íâ·óÖÎÁÆ£¬ÎÞ Ðè¿Ú·þ£¬ÎÞ¶¾¸¶×÷ÓÃ, ¸ü²»»áÉ˼°³¦Î¸, Ò»°ãÇé¿öÖ»ÐèÁ½¸öÁƳÌ15Ìì×óÓÒ¼´¿É ʹ»¼Õß½â³ý²¡Í´¡£ ¾­Ö

Re: Need to cleanly uninstall

Hmmm, (mysql, query) > Thanks That's OK. > It's 2.4.18 Sorry, I meant distribution...eg is it RedHat, Slackware ;-? > So, I will try to unistall and install from the > tarball, yes? It wouldn't hurt. How did you install it in the first place? DSL -- Con te partiro, su navi per mari Che

Re: Need to cleanly uninstall

Thanks It's 2.4.18 So, I will try to unistall and install from the tarball, yes? > > > Spiros, > > > linux:/home/db/TMPOUT # rpm -q mysql > > package mysql is not installed > > > > linux:/home/db/TMPOUT # rpm -qa | grep MySQL > > MySQL-shared-4.0.3-0 > > MySQL-client-4.0.3-0 > > MySQL-devel-4.

Re: Can't link with C API

> That path isn't where mysql is installed. I checked the paths; my makefile > has the correct path. CC can find the header files, and the linker can find > the lib (using truss I can see the linker open the file). > > I'm not sure where the --prefix cam frome. Is that a compile-time option? > I

can't install mysql-4.0.3 with innodb

Hello I just installed mysql 4.0.3-beta for innoDB 1.I deleted my existing mysql4.0.3, my.ini and my.cnf files 2.I created a new my.cnf file and copied to c:\winnt directory The contents being # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all lon

Re: Replications...

Jeremy Zawodny ([EMAIL PROTECTED]) wrote: > >> >http://jeremy.zawodny.com/mysql/managing-mysql-replication_files/slide0121.htm >> > >> >Just make B a slave of A, C a slave of B, and A a slave of C. >> >> This is a good approach. > >Except that it's fragile. One machine can go down and "break the

Re: Need to cleanly uninstall

Spiros, > linux:/home/db/TMPOUT # rpm -q mysql > package mysql is not installed > > linux:/home/db/TMPOUT # rpm -qa | grep MySQL > MySQL-shared-4.0.3-0 > MySQL-client-4.0.3-0 > MySQL-devel-4.0.3-0 > MySQL-4.0.3-0 > linux:/home/spiros/TMPOUT # Ok. > mypc@linux:~> /usr/bin/mysql > ERROR 2002:

Re: Single User Application Install

Can't your deployment package include all the required files? Visual Basic does this nicely. .b -- ben joyce // [EMAIL PROTECTED] // +44 (0)7958 933718 Quoting Aaron <[EMAIL PROTECTED]>: > I wrote an application that will be using MYSQL as the backend database. > The software will be meant

Re: LOAD DATA LOCAL INFILE "not allowed this version"?

I'm not doing that. I'm doing C:>mysql -r -N fall02 < \mysqluw\mysql.txt (i.e. using the "mysql" command from DOS, and running a batch file) And I didn't change any configuration defaults since installing mySQL on this machine. - Original Message - From: "Sqlcoders.com Programming Dept

Re: Can't link with C API

rm said: > Steve, > > in this line: > MYSQLLIBS = -L /work/doctools/mysql-3.23.52/lib -lmysqlclient > > Try eliminating the space between -L and /work/ > that format always works for me using gcc. > > Other than that, I don't see anything that looks wrong. Thanks for the suggestion.

Re: Can't link with C API

Ben Goodwin said: [Charset iso-8859-1 unsupported, filtering to ASCII...] > Based on the prefix for your MySQL installation (--prefix=/usr/local/mysql > '), you're not using the right paths. You need to set the -I to > be where your mysql.h file is, and the -L to be where your > libmysqlclient.so

Re: MySQL inserting into db (used load data)

I had that once and it was due to the fact that the data I was trying to put into the database was bigger the 1M (1M is the default) per insert I had to start mysqld with ' -O max_allowed_packet=3M' On Mon, 9 Sep 2002, louie miranda wrote: > I got the file using load data infile (transfer) > >

Re: NEWBIE: normalization question/help/lost :)

> After a year of doing database programming, try to actually normalize. Read > a couple online tutorials (phpbuilder, devshed) and the book mysql 2nd > edition and it just can't seem to stick. Understanding the concept/theory > but freeze up every time I try to implement. Trying to go from 0NF

Re: Replications...

On Sun, Sep 08, 2002 at 11:53:41PM +, Sam Przyswa wrote: > Jeremy Zawodny ([EMAIL PROTECTED]) wrote: > > > >> Does multi-master mean master to master, imagine you have 3 MySQL > >> servers, A, B, C, with a load balancer in front end, if we make an > >> update on A, is it possible to replicate/

Re: Replications...

Jeremy Zawodny ([EMAIL PROTECTED]) wrote: > >On Sun, Sep 08, 2002 at 03:30:35AM +, Sam Przyswa wrote: >> Jeremy Zawodny ([EMAIL PROTECTED]) écrivait: >> > >> >On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote: >> >> Hi, >> >> >> >> Does the next MySQL 4.x version will support cross r

Escaping characters in select query problem...

I am having trouble with an sql query. I have a table with a column that has an '#' sign in the name. The problem is I can't seem to escape the column name to be able to select it. IE: select test#1 from test or select `test#1` from test Both don't work and i get the error Unknown column 't

RE: LOAD DATA LOCAL INFILE "not allowed this version"?

One can disable all LOAD DATA LOCAL commands in the MySQL server by starting mysqld with --local-infile=0. In the case that LOAD DATA LOCAL INFILE is disabled in the server or the client, you will get the error message (1148): The used command is not allowed with this MySQL version http://www.m

LOAD DATA LOCAL INFILE "not allowed this version"?

The command LOAD DATA LOCAL INFILE "C:\\MO10.txt" INTO TABLE stud1 fields terminated by "/" lines terminated by '\r\n'; produces: ERROR 1148 at line 1: The used command is not allowed with this MySQL vers Could someone explain why?? I'm running version "MYSQL Ver 11.18 Distrib 3.23.51,

Single User Application Install

I wrote an application that will be using MYSQL as the backend database. The software will be meant to run on a single non networked, Windows machine. Does anyone have any ideas on how I might install the MYSQL server software and the odbc drivers without having the user installing it and configur

RE: Upgrading

Update: Now, after rebooting the server, the site can't connect...that's more like it ;) -Original Message- From: Richard W. Berriman [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 08, 2002 4:43 PM To: [EMAIL PROTECTED] Subject: Upgrading Hi! I have a number of tables in developme

Upgrading

Hi! I have a number of tables in development in 3.22.32 (running in apache_1.3.12 on a linux kernel) I'd really like to upgrade to 3.23.49a but my installs in both rpm and binary have not succeeded in "taking over" from my previous install. I've read quite a bit at the mysql.com site, but hav

How to retrieve "Insert Into Select From" records effected

Hello, How can I determin what erros occur from an "Insert into select from" statement? Namely, I'm looking for any duplicate record errors. It is important to inform the user (in a web browser) whether or not a particular insert would fail. Must I perform a lookup first, or is there a way to

newbie questions...

Hi, I'm new to this list, and have a few basic MySql questions: * Is it safe to convert a timestamp field to a datetime one? ie: will this 'touch' each row and stuff up the ordering (hopefully not!). * I'm building a BBS application that needs to keep track of 'child counts'. Currently, I'm usi

MySQL inserting into db (used load data)

I got the file using load data infile (transfer) [root@atsome host]# mysql -uroot db < file.sql ERROR 2006 at line 1: MySQL server has gone away When i try to do this command it issues this error, whay is that? I also tried doing integritycheck on my db. No problem actually. Thanks, Louie...

Re: MySQL Manager Connection Config Problem

Odds are you have not granted your 'root' user rights to login from a node on the network. Instea dof using root, I would suggest you create another user with rights to login across the network. - Original Message - From: "John Hanley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sun

RE: MySQL Manager Connection Config Problem

Hi Generally root is only allowed access from local host for security. Either use a GRANT statement to give access from the host you are using or create another user with the appropriate permissions. Not sure about the IP missmatch. HTH Peter --- E

MySQL Manager Connection Config Problem

Hello. I'm running MySQL 3.23.29a-gamma on RH Linux 7.0. I would like to administer my database from a Win98se client on the same network and installed EMS's MySQL Manager 1.8. This appears to be an excellent tool and can't wait to get started. Unfortunately I'm having a problem getting the conne

Reindex a table.

Well I am glad for the help :). I am get an old table clean up but need to re-index my table. I think there is on small problem. It's is ISAM table and not myISAM. Chuck Payne Magi Design and Support Mysql and sql - Before p

RE: Null to a value...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chuck, If you need to change NULLs to a value all you need do is: UPDATE table_name SET field_name = 'your_value' WHERE field_name IS NULL; HTH, Bryant Hester - -Original Message- From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]] Sent:

Re: Replication problem: slave can't log into master

On Thu, Sep 05, 2002 at 09:52:05AM -0400, Jamie Beu wrote: > > I am attempting to setup MySQL replication between the ctiadb1 (master) > server and the ctiadb2 (slave) server. > > When I look at the mysql.log file on the slave, I see the following > (repeated every 60 seconds): > 020904 12:00:30

Null to a value...

Hi again, I need to change cross 600 records that have 'Null' in the field and I need to change it a value. What is the sql statement that will let me change that field. Chuck Payne Magi Design and Support - Before posting, pl

LOAD DATA not a valid command?

I just installed Max v3.23.52-nt and it is working. However, in following the tutorial, I created a text file and tried to use the Load Data command, which returned an error: "ERROR 1148: The used command is not allowed with this MySQL version" I need to convert a large Access DB to mySQL and I

Re: Need to cleanly uninstall

On Saturday 07 September 2002 10:48, you wrote: > You could do something like: > > linux:/home/db/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm > > error: package MySQL-4.0.3-0.i386.rpm is not installed > > Don't add the RPM on the end. > > Also, what does: > > * rpm -qa | grep MySQL > > ...show. It w

Problem compiling a MySQL client in C language

Hello, Is anyone using Borland's C compiler with Windows (XP) ? I am trying to compile/link a very simple MySQL client written in C, using MySQL include files and mysqlclient library, but it does not want to work. What command line(s) should I use to have it compiled right ? By advance, thank you

Re: select * into outfile

Yes, I can do that, but the subroutine is the same that execute other SELECT-like statements. It does: prepare execute fetch result print Then it must understand when SELECT * INTO OUTFILE must be executed and do not try to fetch data. Is there any criteria that say that there is no data to fetch?

Re: Problem compiling mysql-3.23.52

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sunday 08 September 2002 02:25, Javier Suarez wrote: > Im having a problem compiling the version of the subject, the problem is > with the gethotsbyname function and the message is the next: > > libmysql.c: In function `mysql_real_connect': > libm

Re: Have A problem

Hi Chuck, or take a look at the LEFT() function. =dn > Try : > > SELECT * FROM yourtable WHERE word LIKE 'D%'; > > Regards, > Jocelyn > - Original Message - > From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, September 08, 2002 2:42 AM > Subject: H

build error on hp-ux 11.00

I think the report is in rather good detail so not to lose any more of your time here it is. bug> uname -a HP-UX student B.11.00 U 9000/800 122901547 unlimited-user license bug> pwd /var/tmp/vsurlan bug> ll total 0 bug> wget -c ftp://ftp.ntua.gr/pub/databases/mysql/Downloads/\ > MySQL-4.0/mysql

Re: select * into outfile

you need to execute your query first you can avoid execute by using the just 'do' or else you'll need to execute your query before getting results Tom - Original Message - From: "edatanew.com" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 09, 2002 12:35 AM Subject:

select * into outfile

Hello! I have one subroutine in Perl (DBI) that prepares and executes SELECT-like queries and fetches the output from them. When I submit SELECT * INTO OUTFILE query, then $sth->fetchrow_array() generates Error: Error 19 (fetch() without execute()) How to avoid it? How can this subroutine distin

Re: FREE traffic to your website !

Doesn't this figure... the spamming bastards are now wasting time in user groups. What a dumbass. Matt - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 08, 2002 7:26 AM Subject: FREE traffic to your website ! > Hi, > > My name is Mike and

Binary install failure on SCO 5.0.6 - missing dynamic link libraries

Neither of the two binary mysql-max 3.23.41 from the MySQL website will run on my system after installation. Both configure and mysql_install_db fail due to missing dynamic link libraries /usr/lib/libdl.so.1 and libnsl.so.1. The system does have libdl.so and libnsl.so. The source distribution

FREE traffic to your website !

Hi, My name is Mike and I have visited your web site at: http://www.mysql.com/downloads/gui-mysqlgui.html I love it. So I have decided to write to you. I thought that because generating traffic is so critical for any website, you could be interested in some information I have about FREE

Problem with compiling a MySQL client in C language

Hello, Is anyone using Borland's C compiler with Windows (XP) ? I am trying to compile/link a very simple MySQL client written in C, using MySQL include files and mysqlclient library, but it does not want to work. What command line(s) should I use to have it compiled right ? By advance, thank you

Please help with weird sorting problem

I have a bit of a problem. I need to do something kinda odd that I'm hoping to get help with...except for any suggestions of changing my table structure. This might seem weird but I need to try and make it work as it is. I have a table called pwdata that looks like the following: id fiel

MySQL Manager Connection Config Problem

Hello. I'm running MySQL 3.23.29a-gamma on RH Linux 7.0. I would like to administer my database from a Win98se client on the same network and installed EMS's MySQL Manager 1.8. This appears to be an excellent tool and can't wait to get started. Unfortunately I'm having a problem getting the conne