Query problem: UNION in subquery

15.Form15SampleTube6RnaBarcode AS ObjectId, f15.Form15PatientID AS PtId FROM form15 f15 WHERE f15.Form15SampleTube6RnaBarcode IN ('01D2V','01DH6')) I tried many combinations and got various syntax errors. Any ideas? Thanks, Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query problem: UNION in subquery

A big "Thank you" goes to you! That was it! Looks like I tried with too many parentheses i.e. /this is wrong/ SELECT FROM ... ( (SELECT FROM ...) UNION (SELECT FROM ...) ) AS abc Regards, Luke - Original Message - From: "Neeraj" <[EMAIL PROTECTED]

Scripting Issues

the database through scripts which can then be deleted instead of writing an app. Any help would be greatly appreciated Thanx, Luke

mysql_real_connect crash

When I try to run mysql_real_connect my program crashes. If anyone could help me understand why I would be eternally grateful. I've tried looking at all the documentation regarding this situation and tried many different things, but I am still stumped with the same crash. I've tried this on cu

Re: innodb vs myisam

L default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> \_ Thanks. Kind regards. In theory, theory and practice are the same; in practice they are not. On Thu, 13 Ap

importing a dumpfile from with the mysql client

e same original session now, cause problems? Thanks. Kind regards. Luke. -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Output to a file

t I get an error. Payne -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: importing a dumpfile from with the mysql client

one I have wondered about myself. Is there a way in mysql to "attach" to session to issue a commit? -Original Message- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 3:02 PM To: Luke Vanderfluit Cc: MySQL List Subject: Re: importing a dumpfile f

updates during database dump

dump, close? Thanks. Kind regards. -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Searching "IN" a comma separated list

Hi, Have struggled with this all day, and didn't know where else to ask. If it's not appropriate to the list, I apologise - and advice or pointers would be brilliant, as my head is now hurting! So here's the situation: 3 tables. f_u_groups f_groups and f_images f_u_groups contains the user's

Re: Searching "IN" a comma separated list

On 25/06/05, Mathias <[EMAIL PROTECTED]> wrote: > I then write you this query which should give you the idea, and i think the > solution : > > mysql> select gid,ugid,FIND_IN_SET(gid,ugid) from groups,groupsList > -> where FIND_IN_SET(gid,ugid) > 0; > +--+-+---+

Re: How to edit part of a field?

On 28/06/05, Brian Dunning <[EMAIL PROTECTED]> wrote: > Hi all - > > I have an urgent need to update several million records. There is a > URL stored in a MySQL 'text' field. Many of the records contain > "1234" like this: > > http://www.domain.com?etc=etc&arg=1234&etc=etc > > Any occurence of "

configuration directives 4.0.18

Hi. Where can I find a good explanation/description of the configuration directives for mysql as they appear in my.cnf? I've downloaded the 4.1 manual but can't seem to find a description of the directives. BTW. Is there a manual for 4.0.18 or 4.0 version? Thanks. Kind regards

database won't load after machine reboot

Hi. I have a database that is used with wordpress blogging software. Yesterday the server that it's running on reset itself. Since then I can't access the database. What could be going on here? Any ideas? Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list arch

Re: database won't load after machine reboot

Hi. For clarity, I'm running mysql 4.0.20 And I did start the mysql daemon. Luke Vanderfluit wrote: Hi. I have a database that is used with wordpress blogging software. Yesterday the server that it's running on reset itself. Since then I can't access the database. What co

Re: database won't load after machine reboot

restarted 050914 4:44:53 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 050918 0:27:35 Aborted connection 30 to db: 'unconnected' user: 'luke' host: `loc alhost

Re: database won't load after machine reboot

Hi David. Logan, David (SST - Adelaide) wrote: Hi Luke, According to the log 051019 19:46:20 mysqld started 051019 19:46:20 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 mysqld is sit

Re: database won't load after machine reboot

Hi David. Thanks for your help. Logan, David (SST - Adelaide) wrote: Hi Luke, Have you tried doing another GRANT statement to ensure the name and password are indeed correct? That would be my next step. That way at least you are sure that the name/password combination are correct. I

Re: database won't load after machine reboot

Hi David. Logan, David (SST - Adelaide) wrote: Hi Luke, Yep, there is a procedure in the manual http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html here. This has all the steps you will need to get root back. Hope it all ends up ok! That went well (resetting the root

copy database other than mysqldump

is around 5GIG, so takes around an hour to restore. Is there a quicker way to copy a database other than to do a dump. Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Huge table

processes are taking place during the lag? Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [rt-users] Huge Attachments table in 3.4.4

Hi. Ruslan Zakirov wrote: On 10/25/05, Luke Vanderfluit <[EMAIL PROTECTED]> wrote: Hi. I have upgraded RT from 3.0.11 to 3.4.4. Mysql 4.0.18, Apache 1.3.27 (with static modperl module). The database we are using is quite large. The main problem we are having is when a user ne

Re: [rt-users] Huge Attachments table in 3.4.4

Hi. Jesse Vincent wrote: On Tue, Oct 25, 2005 at 04:14:46PM +0930, Luke Vanderfluit wrote: Hi. I have upgraded RT from 3.0.11 to 3.4.4. Mysql 4.0.18, Apache 1.3.27 (with static modperl module). The database we are using is quite large. The main problem we are having is when a user needs

binlogs

any replies. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

dropping a database to reclaim space

right? I've already tried drop database and that doesn't show reduced disk space either. I'm doing this on a solaris 9 box. Any input appreciated. Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.0.18 restore dump file 'max_allowed_packet' error

ew machine and I'm getting a 'max_allowed_packet' error: ERROR 1153 at line 162: Got a packet bigger than 'max_allowed_packet I've tried different settings for this in my.cnf, from 32 up to 1024M, and I still get the error. Is there anything I can do to remedy this? Kind regard

DBD::mysql::st execute failed: MySQL server has gone away

quest.pm:1249 If anyone can help, I'd appreciate it. Kind regards. -- Luke

Re: DBD::mysql::st execute failed: MySQL server has gone away

' port: 3306 Source distribution = Your help is appreciated. Thanks. Kind regards. Luke -Sheeri On 3/24/06, Luke Vanderfluit <[EMAIL PROTECTED]> wrote: Hi. I'm getting the following error running apache2 with modperl, mysql 4.1.18 and RT 3.4.5 *error:*

Re: DBD::mysql::st execute failed: MySQL server has gone away

Ravi Prasad LR wrote: Luke, Yup. Basically if I do a particular query from the command line, I get the following error: === InnoDB: Error: tried to read 16384 bytes at offset 1 3469819904. InnoDB: Was only able to read -1. 060327 8:25:41 InnoDB: Operating

innodb vs myisam

on the disk smaller? Does an innodb table take up less disk space than myisam? Is an innodb table compacter and would therefore require less disk seek time or I/O than myisam? Kind regards. Luke. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Counting number of values in a SET column

Okay so I'm stumped. What I want to do is run a query that can tell me the average number of selected values in a set column. With the column: mySetCol SET ('cat','dog','mouse','giraffe','lion') A row with the value "dog,mouse,lion" would return 3 A row with the value "cat,giraffe" would return 2

Raiserror in MySQL? Raising a user exception in a script

Hi, I'm trying to raise an error in a MySql query, in the same way that would be done in an MSSQL script: RAISERROR('My error message', 16, -1) Is there a way to do this in MySQL? Thanks, Luke Venediger. -- Get Firefox Browser! Reclaim the web. http://getfirefox.com/ --

Re: Raiserror in MySQL? Raising a user exception in a script

Hi Paul, Thanks for the information. Is there an alternative? Are there plans to add this in the future? Cheers, Luke Venediger. On Thu, 21 Oct 2004 08:46:04 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote: > At 15:29 +0200 10/21/04, Luke Venediger wrote: > >Hi, > > >

Conditional statement: IF

m getting syntax errors). I'm using MySQL 4.0.18. Any help would be greatly appreciated. Thanks, Luke Venediger. -- Get Firefox Browser! Reclaim the web. http://getfirefox.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Conditional statement: IF

statements with code checks in-between, where I would rather only execute one query. Cheers, Luke Venediger. On Fri, 22 Oct 2004 18:49:54 +0200, Anders Karlsson <[EMAIL PROTECTED]> wrote: > I don't know why you want to do this, but looking at your sybtax, it > seems like y

Re: **[SPAM]** Conditional statement: IF

Hi, Apologies, yes I have RTFM, and should've clarified my question. I actually need to do something more like this: IF(@SomeValue = 1) BEGIN THEN SELECT "Data" as Column1, "MoreData" as Column2 ELSE SELECT "SomeValue is not = 1" as E

Select with an IF statements

ilable". However, if the product name doesn't work the query doesn't return any rows. I would like it to return "Not Available" if the product isn't found. Is there a better way to do this? Thanks, Luke Venediger. -- Get Firefox Browser! Reclaim the web

Re: Select with an IF statements

Thanks Paul! Luke Venediger. On Wed, 27 Oct 2004 16:17:51 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote: > At 22:58 +0200 10/27/04, Luke Venediger wrote: > >Hi, > > > >I'm trying to do the following: > > > >SELECT > > IF((ProductSta

Re: Select with an IF statements

Hi Rhino, I don't think that answer solves the problem. I do use a programming language, and doing a query like this means I can make use of the database engine and not add overhead to my application. Cheers, Luke Venediger. On Wed, 27 Oct 2004 17:26:56 -0400, Rhino <[EMAIL PROTECTED

Re: Row level security requirements, can I still use MySQL?

Hi, I think Peter's suggesting you implement that security model in your application, rather than in the database server. Apart from probably not supporting such a security model, it's easier to audit user activity if you are controlling the security model. Cheers, Luke Venediger.

REGEXP and word boundary match

urce where name regexp '[\b](searchText)[\b]; Does anyone know whether this is supported? I've also tried writing my own boundary check with limited success. Any help would be greatly appreciated, Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: REGEXP and word boundary match

to look in the MySQL manual. :-) http://dev.mysql.com/doc/mysql/en/Regexp.html sweet, just what i needed :) Thanks! Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

pattern matching - but in reverse

Hi everyone, ok, so I know how to use RLIKE to match regular expressions. However, let's say I have an isbn number of: 0-06-430022-6 saved in the database but someone wants to search for it by entering: 0064300226 or even 006-430-0226 So the search query needs to have its dashes removed

Re: pattern matching - but in reverse

ive some variations of this a try, thanks for the quick reply. Luke Oh, I think I know this one. Copied from my console: mysql> select * from test; ++-+ | id | myvalue | ++-+ | 1 | 12 | | 2 | 15 | | 3 | 3 | | 4 | 10 | | 5 | 10 | | 6 |

mysql install

thanks in advance christmas cheers, -- Luke Vanderfluit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-ma

RE: help with big table search

Jaime: Have you tried creating a FULLTEXT index? If so, I'd like to hear about how well it works on such a large database. http://www.mysql.com/doc/F/u/Fulltext_Search.html Best of luck. -luke Luke Muszkiewicz Pure Development, LLC http://puredev.com > Hi, > > I have a table

GUI compiling on OSX

Greetings. I'd really enjoy having a SQL GUI for my Mac laptop, is it likely that one of BSD sources will compile under OSX? I haven't compiling anything yet, so I thought I'd should ask if it has been mentioned before. -

Aborted connection XXX to db.... (Got an error reading communication packets)"

om/doc/C/o/Communication_errors.html But I have no idea how to fix it. Anyone? Luke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Re: Basic details...

Just a point. The limit might be high, but accessing a table as such will not be as quick... if possible, should normalise your data. the whole idea behind RDMS. If this has been done, ignore me :) Luke - Before posting

Aborted connection XXX to db.... (Got an error reading communication packets)"

om/doc/C/o/Communication_errors.html But I have no idea how to fix it. Anyone? Luke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Re: Aborted connection XXX to db.... (Got an error reading communication packets)"

d found a possible cause at http://www.mysql.com/doc/C/o/Communication_errors.html > > I used to suspect memory leaks but thats has been checked with > > LeakTracer, and passed! > > What about your Apache error log? "Premature end of script headers" Luke

Re: C API problems

MYSQL_RES *results1; MYSQL_ROW row; MYSQL DBsession; mysql_init ( &DBsession ); mysql_real_connect ( &DBsession, PRI_HOST_IP, PRI_USER_NAME, PRI_USER_PASSWORD, PRI_DB_NAME, PRI_PORT_NO, "", 0 ); sprintf ( sql, "SELECT filepath FROM filepath WHERE charset = '%s' AND location = '%s'",

Re: Update

do a simple script to read, parse and edit then finally update based on c1 Luke - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 20, 2001 11:34 PM Subject: Update > Hello there, > > could you please help to a novic

Aborted connection...to db...(Got an error reading communication packets)

om/doc/C/o/Communication_errors.html But I have no idea how to fix it. Anyone? Luke Link to the site http://202.126.131.88/cgi-bin/ecx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

Re: msql client , C++ , compiler ,mysql header files , and mysql client library

e is a MySQL++ class that you can use, but you will still require these packages. I left out the full packages' name as I cannot recall them. Hope it helps. Luke - Before posting, please check: http://www.mysql.com/manual

ORDER BY bug; must also select column that is being ordered by

- -++ 18 rows in set (0.00 sec) So my workaround is to go ahead and select created even though I don't need that piece of data in my result set. One obviously shouldn't have to select unneeded data just to get it to sort correctly. >Submitter-Id: ? >Orig

re-starting safe_mysqld after the server re-starts

runs safe_mysqld. I would assume that many of you have implemented a like solution to this problem. I would appreciate any advice, information, or actual programs that I could use to solve this problem. Thank you all in advance! -luke Luke Muszkiewicz Pure Development, LLC http://puredev.com 3946

extended insert limit?

what is the limit to the number of records that can be inserted via an extended insert statement. I know mysqldump creates a new insert statement every X records, but I forgot what that number is, and I'm trying to duplicate the action. thanks, -L

RE: extended insert limit?

thanks much. exactly what I needed. -L -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 11:22 AM To: Crouch, Luke H. Cc: mysql@lists.mysql.com Subject: Re: extended insert limit? "Crouch, Luke H." <[EMAIL PROTECTED]

ulimit effects on mysql user?

if I have changed my /etc/security/limits.conf file to include these lines: mysqlsoft nofile4096 mysqlhard nofile63536 and then done: [EMAIL PROTECTED] root]# su mysql [EMAIL PROTECTED] root]$ ulimit -n 8192 [EMAIL PROTECTED] root]$ ulimit -n 8192 does this n

lost connection DURING query?

does anyone know if this is the error ODBC gets when trying to use a connection that has been killed by the MySQL server? if that is so, it may be that I just need to put the wait_timeout back up. any help would be great! thanks! -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]

RE: lost connection DURING query?

this query is "select * from ogcount" which is a table containing 1 record, so probably not the packet size, though that's very good info to know. I'm going to see if I get the same error if I use a JDBC driver instead of ODBC. -L Luke Crouch 918-461-5326 [EMAIL PROTEC

strange user permissions error

e explicit domains in addition to the wildcard. anyone know what may have caused the user permissions to go flaky like that? -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]

log_slave_updates without restarting

is there a way to turn on log_slave_updates on a server without having to restart it? -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]

super-smack installation problem

/mysqlsource/mysql-4.0.20/libmysql/libmysqlclient.la I have installed the MySQL-compat and the MySQL-devel for 4.0.20 any ideas? thanks, -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]

replication binary log files location

directory to be owned by mysql (and am running mysqld_safe --user=mysql) any ideas? thanks, -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]

Re: replication binary log files location

/host-name which will now create /logging/host-name-bin.001 and /logging/host-name-bin.index and since mysql has ownership of the logging directory, this is okay... -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]

auotmate read queries for replication

every application's queries to different datasources by hand. is there some kind of connection router than can filter the reads to one of the slaves and the writes to the master? if so, is the performance hit not worth it? thanks, -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]

replication threads on different CPUs

matically. we have the same machines in use for the slaves...so can I make the slave IO thread execute on one processor, and the slave SQL thread execute on another? does this happen automatically as well? thanks, -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]

replication vs. c-jdbc

summarize the pros and cons of using the standard MySQL replication or the 'mirror' configuration of c-jdbc? we may look at going with c-jdbc mirroring rather than MySQL replication if there are no significant drawbacks... thanks, -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]

Best field type for ID?

? Should one use INT instead? Regards Luke van Blerk (mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: Best field type for ID?

Thanks! Thats a great help. I didn't know that about the performance advantage. I was using INT but thought SMALLINT might be better cos it uses less space. Much obliged. - Original Message - From: "Madscientist" <[EMAIL PROTECTED]> To: "'Luke van B

InnoDB tables

ll foreign keys have a slow down effect? And are there any issues I need to know about before switching to InnoDB tables? Thanks in advance Luke van Blerk mysql - Before posting, please check: http://www.mysql.com/manual.php (

Re: InnoDB tables

sers_towns' which stores the ID of each entity and thereby the relationship is maintained. But if I can have the foreign keys operating this would cut out the need for such a table and all the extra coding work which goes with it. I hope that explains why I'd like to use foreign ke

Char vs Varchar field types

Hi everyone, When is it appropriate to use Char instead of Varchar and vice versa? Thanks Luke mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

mysql.host doesn't exist error ... even though it does

i've been running mysql on a redhat linux machine for about two months w/o need for a restart. unfortunately this morning, the machine started acting really odd and i decided to perform a restart. when restarting, the system actually froze and i was forced to perform a hard restart. after restart

mysql.host doesn't exist error ... even though it does

i've been running mysql on a redhat linux machine for about two months w/o need for a restart. unfortunately this morning, the machine started acting really odd and i decided to perform a restart. when restarting, the system actually froze and i was forced to perform a hard restart. after restar

FW: mysql.host doesn't exist error ... even though it does

permissions on the data directory and all sub directories / files i still get the same error thanks a lot. > -Original Message- > From: Luke Andrew Cassady-Dorion > Sent: Friday, January 12, 2001 2:04 PM > To: '[EMAIL PROTECTED]' > Subject: mysql