Thank you Jasper
It works, with a little change but it works
yvan
Jasper Bryant-Greene wrote:
Yvan Strahm wrote:
I have a varchar column 's1' in table t1. And a varchar column 's2'
in table t2.
Do you know how one could do something like this:
select * from t1,t2 where t1.s1 like %t2.s2
Yvan Strahm wrote:
I have a varchar column 's1' in table t1. And a varchar column 's2'
in table t2.
Do you know how one could do something like this:
select * from t1,t2 where t1.s1 like %t2.s2
SELECT * FROM t1, t2 WHERE t1.s1 LIKE CONCAT('%', t2.s2)
(untested)
--
Jasper Bryant-Greene
Freela
Hello,
I have a varchar column 's1' in table t1. And a varchar column 's2'
in table t2.
Do you know how one could do something like this:
select * from t1,t2 where t1.s1 like %t2.s2
Thanks for your help
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
hi,
i am Installing My Sql -Standard-4.0.26-pc-linux-gnu-i686 Of Linux Machine
But Facing some Problem
i am Getting thius Error " ERROR 2002: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2)"
while i start MYSQl
Plzz Reply me Giving t he Solution For it
Hi Friends,
Can you please help me on this.
regards
anandkl
-- Forwarded message --
From: Ananda Kumar <[EMAIL PROTECTED]>
Date: Sep 20, 2005 9:46 PM
Subject: connect from oracle to MYSQL.
To: mysql@lists.mysql.com
Hi All,
Can you please help me in connecting from oracle databas
I'm not an SQL expert and have a subquery problem. I have a query that
consists of a query inside of a query inside of a query. The two inner
subqueries work fine together and give me a list of "ids" for matching
records. And they do it very quickly. If I then take their results and
feed them to th
todd hewett wrote:
mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER)
mysql> VALUES(36534);
ERROR 1216: Cannot add a child row: a foreign key constraint fails
Can you please post the output of:
SHOW CREATE TABLE BOARD_SERIAL_NUMBER;
mysql> SHOW CREATE TABLE BOARD_SERIAL_NUMB
>> mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER)
>> mysql> VALUES(36534);
>>
>> ERROR 1216: Cannot add a child row: a foreign key constraint fails
>Can you please post the output of:
>SHOW CREATE TABLE BOARD_SERIAL_NUMBER;
>> mysql> INSERT INTO BOARD_TYPE (BOARD_TYPE) VALUES(INPUT
On Sep 16, 2005, at 11:07 AM, Jeff wrote:
There shouldn't be a problem if:
server A is ver 4.0.x
server B is ver 4.1.x
should there?
There will totally by a problem here... The 4.1 server will take the
4.0 feed without issue. The 4.1 server however puts all sorts of
information into the
> Are your two tables in the same database ?
> If yes only one connection if enough, and you could use a join query
> to do it, thus having a speed improvement of several magnitudes.
I've just downloaded another 2 mysql manuals and have been sit on my chair all
day reading them, but still do not
Todd Hewett wrote:
mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER)
mysql> VALUES(36534);
ERROR 1216: Cannot add a child row: a foreign key constraint fails
Can you please post the output of:
SHOW CREATE TABLE BOARD_SERIAL_NUMBER;
mysql> INSERT INTO BOARD_TYPE (BOARD_TYPE) VALUE
SNIP---
You need to end each INSERT INTO statement with a semicolon (;), not a
comma (,). Also pressing after each one will allow you to easier
diagnose any problems that might come up.
-
I have run th
I'm unable to use the MySQL official HP-UX binaries, because they don't
contain shared libraries in their DEPOT distribution that I need for things
like PHP and DBD driver for PERL. I also have problems because the MySQL
binaries are compiled using HP's own C++ compiler, which causes all kinds of
Todd Hewett wrote:
I currently am failing with the following:
mysql> INSERT INTO VCS_PO_NUMBER (VCS_PO_NUMBER) VALUES(899234),
-> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) VALUES(36534),
-> INSERT INTO BOARD_TYPE (BOARD_TYPE) VALUES(INPUT MODULE N12310),
-> INSERT INTO RE
Howdy Folks I hope this is not too much information.
I have
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
I have multiple tables.
All are innoD Tables.
All AI on a Primary key integer
All Columns are varchar 255 that are not keys.
Table VCS_PO_NUMBER
Has
> -Original Message-
> From: Devananda [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 20, 2005 17:13
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: Circular Replication
>
>
> Jeff wrote:
> >>-Original Message-
> >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> >
Jeff wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, September 19, 2005 10:10
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Circular Replication
Sid Lane <[EMAIL PROTECTED]> wrote on 19/09/2005 15:02:58:
stupid ?:
what keeps
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 19, 2005 10:10
> To: [EMAIL PROTECTED]
> Cc: mysql@lists.mysql.com
> Subject: Re: Circular Replication
>
>
> Sid Lane <[EMAIL PROTECTED]> wrote on 19/09/2005 15:02:58:
>
> > stupid ?:
> >
The other day i asked about the proper column to store UUID's in. After
thinking about it some more, i still think that a BINARY(16) is a better way
to store a UUID. I'd need to strip the dashes from the formatting, but the
storage would only be half as much (slightly less actually) as the sugge
If you want to join a table more than once, you need to refer to it
AS something else.
select sum(PlaceNo)
from boxes
inner join car using (boxID)
inner join load using (TravelID)
left outer join load AS Load2 on car.BoxNo=Load2.BoxNo
Where load.TravelID=1 AND Load2.BoxNo is null
On Sep 20, 2
Download mysql-4.1.4.tar.gz
extract the contents into /usr/local/mysql-4.1.14
now delete the data dir
stop the mysql server running (4.1.13)
copy the whole data dir from the old version 4.1.13 ( use cp -pR to preserve
perms) to the new one
create a symbolic link like ln -s /usr/local/mysql-
>it sounds like you need to look at, and potentially cleanup (or make
>your mysql access entries match) what's in the inverse-map record for
>the IPnumbers of your machines.
>when you connect mysql takes the IPnumber on the inbound connection,
>looks it up in DNS and then checks the result against
Hallo,
>
> in a very small representation the program is this
>
> *** dbmail and dbmail2 open 2 different connections, one accesses
> DBM_ADDRESSES table and the other accesses DBM_NAMES table. The first one
> retrieves addresses from the table DBM_ADDRESSES, the second one a relationed
> names
>Note that if you set the password by directly editing (UPDATE) the
>mysql.user table like this, you will have to run
FLUSH PRIVILEGES;
Thank you. That solved the problem connecting from the mysql client.
It changed the problem connecting via the 'Test' button from the ODBC
Administrator, t
[EMAIL PROTECTED] wrote:
Gerald Williams <[EMAIL PROTECTED]> wrote on 09/20/2005 10:49:22 AM:
MySQL 5.0.12, P2P Microsoft network
I cannot get the manual's instructions (24.1.9.6) to work for
connecting from a mysql client on a windows machine to a mysql
server running on another windows ma
all,
does anyone know of any GPL'd equivilent to an Oracle Name Server
(essentially DNS for SQL*Net)?
I am considering writing such a thing but wanted to see if someone had
already invented this particular wheel.
essentially I envision a server (probably redundant pair) to which
application s
Gerald Williams <[EMAIL PROTECTED]> wrote on 09/20/2005 10:49:22 AM:
> MySQL 5.0.12, P2P Microsoft network
>
> I cannot get the manual's instructions (24.1.9.6) to work for
> connecting from a mysql client on a windows machine to a mysql
> server running on another windows machine (xp and w2kpr
First - thank you. I want to again thank this list, which in general is the most
tolerant to people new to database use and theory in general, and me in
particular. I mostly got your point from an earlier answer. Hopeful your example
quashes my ignorance, relative to NULL at least.
I think I under
MySQL 5.0.12, P2P Microsoft network
I cannot get the manual's instructions (24.1.9.6) to work for connecting from a
mysql client on a windows machine to a mysql server running on another windows
machine (xp and w2kpro repsectively)
The client machine can ping the server machine by name or IP ad
Hi All,
Can you please help me in connecting from oracle database to mysql database.
I am trying to setup the hetrogenious service provided by oracle, but i am
not able to complete all the steps.
I am failing at this step
*cp MyODBC-3.51.06-sun-solaris2.8-sparc/libmyodbc3* lib*
# *mv etc/odbc.i
> > I have 2 different result sets, since are two different connections to
> > the server, simultaneous but independent (two handles, two connections,
> > two different queries)
>
> what is the code you're using ?
in a very small representation the program is this
*** dbmail and dbmail2 open 2 di
In the last episode (Sep 20), Hugh Sasse said:
> This got as far as the test phase, and tested successfully. I did it
> this way because of the solaris settings being collected together.
> However, when I installed, parts of the installation overwrote
> /usr/local/mysql despite my --prefix. I al
Hi Mark,
First set up an ODBC data source for your MySQL database, using MyODBC.
How do i do this.
regards
anandkl
On 9/19/05, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> Hi Mark,
> Thanks for the email. Yes i also read about this.
> But the problem with this approach is since our oracle db is
Hi
how can i retrieve string value contains in a longblob column ?
i test CAST and CONVERT mysql function but don't work.
Doesn't seem hard but don't see howto do that
select * FROM table
Thank's for any help
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
sorry for this monologue-thread, but...
Nico Sabbi wrote:
[snip]
If it can help, seems that the largest value I can store in a blob field
without triggering that error is 192 characters long.
I just read the restrictions on Innodb tables, and I'm not convinced
that what is going on is expe
MySQL is generally limited by the OS you are running it on. If you
start having thousands of table, the OS is probably going to get
bogged down in trying to keep track of all the file handles needed
for all those tables and indexes. The practical limit to the number
of tables is far lower t
On Tue, 20 Sep 2005, Hugh Sasse wrote:
On Tue, 20 Sep 2005, Pooly wrote:
Hi,
gmake: *** [all] Error 2
neelix hgs 57 %> ls /usr/lib/*pthread*
/usr/lib/libpthread.so /usr/lib/llib-lpthread
/usr/lib/libpthread.so.1 /usr/lib/llib-lpthread.ln
neelix hgs 58 %>
[...]
I guess you'r
If some users can add data, then I think that is problem that the clients,
you should check headers response in your php.ini, the flag charset-type
should have a value that your clients support. I've had that king of
problems, when I use header() function in php.
:: ISC Edwin Cruz Garcia ::
IT Fac
Hi
I'm running MySQL 4.0.25 on a Linux machine dual xeon 3.0GB Ghz(32 bit)
with 6 GB RAM
the data is connected to a SAN storage
I wander what is the best tablespace configuration (except RAW) of
configuraing?
my configuration is as follows:
innodb_data_file_path=ibdata1:10G;ibdata2:10G;ibdata3
Hi, all
I have 2 questions:
1) Is there any limit on the number of tables I can create in MySQL and
how large I can hold in a database?
2) Does MYSQL support to save binary data file in the table. I can't just
save paths to the files. They files reside in another machine.
Thanks for reply.
X.C
Hi!
Just some explicit addition:
[EMAIL PROTECTED] wrote:
[[...]]
So in the following query:
select * from new_payments where closed<>1;
it is desired that null=1. DeMorgan's law takes a vacation here.
You use two-valued logic here, where statements are either "true" or
"false". (DeMorg
Hello,
My log file is getting filled with these. How do i start debugging this?
Thanks
Randy
//-snip-//
050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries'
host: `local.flanders' (Got an error reading communication packet
Nico Sabbi wrote:
Hi,
with mysql 4.1[234], importing a dump of Innodb tables containing at
least a blob field
I invariably get_
ERROR 1030 (HY000) at line 21027: Got error 139 from storage engine
I read in the bugzilla that this problem is due to low memory
conditions, but
surely it's not m
Richard,
In my instructions, the chowns are as follows:
shell> chown -R root /usr/local/mysql/.
shell> chown -R mysql /usr/local/mysql/data
shell> chgrp -R mysql /usr/local/mysql/.
Note no slash after data. However, you have world read and write on the data
f
hello
i installed mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz, i followed
the instruction on the INSTALL-BINARY file. after that i installed
httpd-2.0.54.tar.gz followed the instruction on the INSTALL file. also
installed php-5.0.4.tar.gz
followed the install intruction in the INSTALL file
Hi,
with mysql 4.1[234], importing a dump of Innodb tables containing at
least a blob field
I invariably get_
ERROR 1030 (HY000) at line 21027: Got error 139 from storage engine
I read in the bugzilla that this problem is due to low memory
conditions, but
surely it's not my case: the server h
On Tue, 20 Sep 2005, Pooly wrote:
Hi,
gmake: *** [all] Error 2
neelix hgs 57 %> ls /usr/lib/*pthread*
/usr/lib/libpthread.so /usr/lib/llib-lpthread
/usr/lib/libpthread.so.1 /usr/lib/llib-lpthread.ln
neelix hgs 58 %>
Any suggestions as to how I get around this and get the whole thing
i
On Tue, 20 Sep 2005, David Logan wrote:
Hugh Sasse wrote:
On solaris 9 Sparc I built originally by modifying
mysql-4.1.14/BUILD/compile-solaris-sparc thusly
[...]
gmake -j 4
neelix hgs 82 %>
and I invoked the script directly, and also tried with bash.
I have:
GNU Make version 3.79.
Hi,
> /usr/local/bin/ld: cannot find -lpthread
> collect2: ld returned 1 exit status
> gmake[4]: *** [mysql_tzinfo_to_sql] Error 1
> gmake[4]: Leaving directory `/scratch/hgs/mysql-4.1.13/sql'
> gmake[3]: *** [all-recursive] Error 1
> gmake[3]: Leaving directory `/scratch/hgs/mysql-4.1.13/sql'
>
Hugh Sasse wrote:
On solaris 9 Sparc I built originally by modifying
mysql-4.1.14/BUILD/compile-solaris-sparc thusly
neelix hgs 81 %> display_diffs.rb .
--- ./compile-solaris-sparc.orig 2005-08-17 18:06:41.0 +0100
+++ ./compile-solaris-sparc 2005-09-06 18:36:25.386697000 +0100
@@ -11,6
On solaris 9 Sparc I built originally by modifying
mysql-4.1.14/BUILD/compile-solaris-sparc thusly
neelix hgs 81 %> display_diffs.rb .
--- ./compile-solaris-sparc.orig2005-08-17 18:06:41.0 +0100
+++ ./compile-solaris-sparc 2005-09-06 18:36:25.386697000 +0100
@@ -11,6 +11,6 @@
hi
how can i clean uninstall mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz i
would like to install mysql-4.1.14.tar.gz i tried make clean, make distclean
etc. only error encountered. thank you very much.
rgds,
Joeffrey
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Versio
hi,
> I have 2 different result sets, since are two different connections to the
> server, simultaneous but independent (two handles, two connections, two
> different queries)
>
> Today was probing one of my programs with just one single connection and
> mysql_free_result() still crashes even wi
Blue Wave Software wrote:
I'm getting an error from the following SQL Syntax. Can anyone guide me on
what I am missing. It's probably obvious but I can't see it I have even
resorted to rereading the section on the update command.
The CustID Field is the unique Identifier and primary key of the
I'm getting an error from the following SQL Syntax. Can anyone guide me on
what I am missing. It's probably obvious but I can't see it I have even
resorted to rereading the section on the update command.
The CustID Field is the unique Identifier and primary key of the table. The
Updated field is a
55 matches
Mail list logo
