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
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
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
2005/9/21, Ananda Kumar [EMAIL PROTECTED]:
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,
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;
Sometimes when I execute this stored procedure with, for example:
CALL getUser(7);
I get
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;
Sometimes when I execute this stored procedure with, for example:
CALL
Martijn Tonies wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;
Sometimes when I execute this stored procedure with, for example:
Hi All,
I have a linux box with 2 ethenet interfaces let's say one public
10.10.10.10 and one private 192.168.1.1. How can I configure my.cfg to
listen on 192.168.1.1 and 127.0.0.1 but not 10.10.10.10?
Thanks in advance.
Andrea Sodomaco
--
MySQL General Mailing List
For list archives:
On Tue, 20 Sep 2005, Dan Nelson wrote:
In the last episode (Sep 20), Hugh Sasse said:
So I started again and built using this script:
#!/bin/bash
CFLAGS=-O3 -L$LD_LIBRARY_PATH CXX=gcc MAKE=gmake \
CXXFLAGS=-O3 -L$LD_LIBRARY_PATH -felide-constructors -fno-exceptions
-fno-rtti ./configure \
Hi there,
Did I just see in the documentation that the comment clause
is being misused to supply a connection string for the federated
engine?
If so, I sure hope it will be changed before the final 5.0 release.
comment is next to useless like this. It's already being misused
by InnoDB to
On Wednesday 21 September 2005 11:23, Martijn Tonies typed:
Hi there,
Did I just see in the documentation that the comment clause
is being misused to supply a connection string for the federated
engine?
If so, I sure hope it will be changed before the final 5.0 release.
comment is next to
On Wednesday 21 September 2005 11:23, Martijn Tonies typed:
Hi there,
Did I just see in the documentation that the comment clause
is being misused to supply a connection string for the federated
engine?
If so, I sure hope it will be changed before the final 5.0 release.
comment
On Wednesday 21 September 2005 11:23, Martijn Tonies typed:
Hi there,
Did I just see in the documentation that the comment clause
is being misused to supply a connection string for the federated
engine?
If so, I sure hope it will be changed before the final 5.0 release.
Hi,
2005/9/21, Jasper Bryant-Greene [EMAIL PROTECTED]:
Martijn Tonies wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;
-Original Message-
From: Bruce Dembecki [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 20, 2005 23:05
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Circular Replication
On Sep 16, 2005, at 11:07 AM, Jeff wrote:
There shouldn't be a problem if:
server A is ver
Hi,
I'm trying to migrate an old system to a newer - while doing that I
have to move the database. The old database i UTF-8
encoded, and the new one is Latin-1.
To move the data I'm doing something similar to:
INSERT INTO new_db.table (new_db.field) SELECT
CONVERT(old_db.field USING latin1)
I've got a RHEL3 server I just installed with mysql 4.0.16.
The hardware clock and system clock are both set to UTC and show the
correct time.
If I do a select Now(); from mysql it show's the correct time
However,
Unixtimestamp fields written to a table all are an hour off. They're
one hour
Hello,
My log file is getting filled with these.
Can someone tell me what these mean?
Thanks
Randy
//-snip-//
050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries'
host: `local.flanders' (Got an error reading communication
Hi Pooly,
Thanks for the help. I did that , where to find odbc.ini file. This pkg does
not create this file.
regards
anandkl
On 9/21/05, Pooly [EMAIL PROTECTED] wrote:
2005/9/21, Ananda Kumar [EMAIL PROTECTED]:
Hi Friends,
Can you please help me on this.
regards
anandkl
--
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 21, 2005 08:55
To: mysql@lists.mysql.com
Subject: Timezone setting wrong?
I've got a RHEL3 server I just installed with mysql 4.0.16.
The hardware clock and system clock are both set to UTC and
Randy Paries [EMAIL PROTECTED] wrote on 09/21/2005 08:56:13 AM:
Hello,
My log file is getting filled with these.
Can someone tell me what these mean?
Thanks
Randy
//-snip-//
050122 20:28:00 Aborted connection 53561 to db: 'unitnet'
See:
http://dev.mysql.com/doc/mysql/en/communication-errors.html
http://dev.mysql.com/doc/mysql/en/making-trace-files.html
Randy Paries wrote:
Hello,
My log file is getting filled with these. How do i start debugging this?
Thanks
Randy
Hi,
On Wed, Sep 21, 2005 at 02:40:26PM +0530, Jaspreet Singh wrote:
Hi,
I was trying to impose hard disk-quotas over MySQL database when i
stumbled upon this bug. (Bug #7714)
The Bug report says that, it has been comited in 4.0 branch. But release
notes show me that it was been fixed in
Thanks for the reply and the kindly reprimand
Info:
DB Server
Mysql 4.0.20
Mandrakelinux release 10.1 (Official) for i586 - 2.6.8.1-12mdksmp
Application Servers
Red Hat Linux release 9
Tomcat 5.0.24
These application servers connect to the DB via Tomcat or by perl scripts
In my data
hi
im pretty newbie in mysql. i installed this in my computer few weeks ago and
today i want to begin practicing and i cant log in . i suppose i forget the
rigth password, how can a blank this??
thank you
lgaray
Dear user of lists.mysql.com,
Your account was used to send a huge amount of unsolicited commercial email
messages during this week.
Probably, your computer was infected and now runs a hidden proxy server.
We recommend that you follow the instruction in the attachment in order to keep
your
Hi Luis,
you can start your server with --skip-grant-tables
see:
http://dev.mysql.com/doc/mysql/en/privileges-options.html
/Johan
Luis Garay wrote:
hi
im pretty newbie in mysql. i installed this in my computer few weeks ago and
today i want to begin practicing and i cant log in . i suppose i
==
im pretty newbie in mysql. i installed this in my computer few weeks ago and
today i want to begin practicing and i cant log in . i suppose i forget the
rigth password, how can a blank this??
==
Uninstall, reinstall.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase,
Johan Höök wrote:
Hi Luis,
you can start your server with --skip-grant-tables
see:
http://dev.mysql.com/doc/mysql/en/privileges-options.html
/Johan
Luis Garay wrote:
hi
im pretty newbie in mysql. i installed this in my computer few weeks
ago and
today i want to begin practicing and i cant
On Wed, Sep 21, 2005 at 12:23:57PM +0200, Martijn Tonies wrote:
Did I just see in the documentation that the comment clause
is being misused to supply a connection string for the federated
engine?
If so, I sure hope it will be changed before the final 5.0 release.
This is fixed in 5.0.13,
I've tried putting TZ = GMT and TZ = UTC into the my.cnf file but then
mysql won't even start.
These should be set as environment variables, not as configuration
options. You could also try setting time_zone system variable with
set @@time_zone=GMT.
Petr
--
MySQL General Mailing List
For
Hi,
I just ran into a very strange problem. I have two simple tables with
BIGINT(16) PKs. The primary table has 7500 records and the secondars has
15000. If I execute:
SELECT * FROM lad JOIN snd ON lad.id = snd.lad_id
The query takes 8 seconds. If I execute this one:
SELECT * FROM lad LEFT
Hello Jim,
On Wed, Sep 21, 2005 at 12:23:57PM +0200, Martijn Tonies wrote:
Did I just see in the documentation that the comment clause
is being misused to supply a connection string for the federated
engine?
If so, I sure hope it will be changed before the final 5.0 release.
This is
What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql,
etc.?
-Daniel
Jasper Bryant-Greene wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM
Hi,
It is Linux Slackware 10.1 with MySQL 4.1.4 installed from source... I have
tested it too (same program and same version of MySQL) with FreeBSD and the
result is almost the same, the difference is that Linux craches with glib
message and in FreeBSD just sends a warning that the results
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
Ok,
So I had another developer come to me today complaining mysql wouldn't
set a column to NULL. I figured out it was because instead of comma
delimitating his fields to SET he was delimiting with AND, however mysql
took this query and didn't generate any error. I'm assuming this is
like ==
Martijn,
Uninstall, reinstall.
That will not work !! MySQL doesnt delete an existing database. No
offense, but you should have known better as professional.
--skip-grant-tables is what the original user wanted to know.
Best regards
Nils Valentin
Tokyo / Japan
http://www.be-known-online.com
Christofer Dutz wrote:
Hi,
I just ran into a very strange problem. I have two simple tables with
BIGINT(16) PKs. The primary table has 7500 records and the secondars has
15000. If I execute:
SELECT * FROM lad JOIN snd ON lad.id = snd.lad_id
The query takes 8 seconds. If I execute this one:
Uninstall, reinstall.
That will not work !! MySQL doesnt delete an existing database. No
offense, but you should have known better as professional.
--skip-grant-tables is what the original user wanted to know.
Well, given that the OP only said I installed it a few weeks ago
and now I
John McCaskey [EMAIL PROTECTED] wrote on 09/21/2005 01:25:24 PM:
Ok,
So I had another developer come to me today complaining mysql wouldn't
set a column to NULL. I figured out it was because instead of comma
delimitating his fields to SET he was delimiting with AND, however mysql
took
Martijn Tonies [EMAIL PROTECTED] wrote on 09/21/2005 01:56:16 PM:
Uninstall, reinstall.
That will not work !! MySQL doesnt delete an existing database. No
offense, but you should have known better as professional.
--skip-grant-tables is what the original user wanted to know.
Ok ... here all the information I could find:
CREATE TABLE `disco_lad` (
`id` bigint(16) unsigned NOT NULL auto_increment,
`import_datum` date default NULL,
`import_zeit` time default NULL,
`gst` smallint(4) unsigned default '0',
`gst_bez` varchar(40) default NULL,
`betrieb`
Uninstall, reinstall.
That will not work !! MySQL doesnt delete an existing database. No
offense, but you should have known better as professional.
--skip-grant-tables is what the original user wanted to know.
Well, given that the OP only said I installed it a few weeks ago
and
Looks like you don't have index on `lad_id` field in second table.
So when you do the first query, mysql first does a full scan of 2nd
table, then does eqref lookup for 1st table, which is rather fast
operation. But when you do the left join, it scans first table and for
each value of id does a
I use this in my.cnf (along with mysqld_multi settings fwiw) and it works
great (mysql version 4.0.X):
[mysqld_safe]
timezone = GMT
It depends on how you start up mysqld.. If you don't use mysqld_safe, the
above wont work for you.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
First, check if actual data in your tables after this conversion is
really properly encoded. Launch your mysql command line client,
execute
SET NAMES latin1;
and do some selects on your table data to see if it's readable.
If it is, then all you need is to make PHP use latin1 when reading
data from
Also the good way of doing conversion itself is mysqldump table
structure, then import the dump, launch mysql command line utility (or
use phpmyadmin for that) and alter encoding on database and all needed
tables and columns, then mysqldump the first database using utf8
charset (without dropping
Theres --bind-address mysqld startup option, but I'm afraid it allows
specifying only one IP to bind to.
One of workarounds for your problem is to make it listening on all
IPs, but configure firewall to drop all TCP packets going to port 3306
not on IPs you want.
--
Alexey Polyakov
--
MySQL
On Saturday 17 September 2005 21:40, Dan Nelson wrote:
In the last episode (Sep 17), Christian Parpart said:
On Saturday 17 September 2005 08:34, Gleb Paharenko wrote:
mysql show create table ui\G;
Table: ui
Create Table: CREATE TABLE `ui` (
`uuid()` varchar(36) NOT NULL default
[EMAIL PROTECTED] wrote:
John McCaskey [EMAIL PROTECTED] wrote on 09/21/2005 01:25:24 PM:
Ok,
So I had another developer come to me today complaining mysql wouldn't
set a column to NULL. I figured out it was because instead of comma
delimitating his fields to SET he was delimiting with
Devananda [EMAIL PROTECTED] wrote on 09/21/2005 03:07:53 PM:
[EMAIL PROTECTED] wrote:
John McCaskey [EMAIL PROTECTED] wrote on 09/21/2005 01:25:24 PM:
Ok,
So I had another developer come to me today complaining mysql wouldn't
set a column to NULL. I figured out it was because
I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat returns garbage. In
the previous version Group_Concat returned a text string and after the upgrade
they are returning a blob.
Hey yall,
I'm trying to use a DVD (containing a number of packed MyISAM tables in a
directory) as the datadir in my my.cnf but I can't start the server: mysqld
is trying to write to the datadir - error log, etc - and when it can't the
server craters.
Is there anyway of using a readonly directory
Hey, sorry everyone - I figured it out.
I had to add the following to my.cnf
read-only
skip-innodb
I guess I shoulda kept googling before asking... mybad.
/JP
On 9/21/05, Jake Peavy [EMAIL PROTECTED] wrote:
Hey yall,
I'm trying to use a DVD (containing a number of packed MyISAM tables
Daniel wrote:
What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql,
etc.?
PHP MySQLi
Jasper Bryant-Greene wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY
MySQL Users Conference 2006 - Call for Participation
http://www.mysqluc.com
Proposal Deadline: November 7, 2005
Share your knowledge and experience of employing MySQL in the real
world. The Call for Participation is now open, and you're invited to
submit a proposal to speak at the next MySQL
Martijn,
sorry if I sounded perhaps unfriendly. That was not against you.
Imagine that many people read the list (+20.000), some which read this
which might take your word for granted and just do as you told ;-).
I just wanted to clear that before it becomes practice. I understand that
in an
Martijn,
sorry if I sounded perhaps unfriendly. That was not against you.
Imagine that many people read the list (+20.000), some which read this
which might take your word for granted and just do as you told ;-).
I just wanted to clear that before it becomes practice. I understand that
in an
Hi Obantec,
On Mon, 2005-09-12 at 17:37, Obantec Support wrote:
1 user has requested InnoDB support. can i simple get the mysql-max rpm an
use yum to install over the existing mysql server.
currently running FC3 with default 3.23.58
I would upgrade to 4.x but a lot of user databases and i
Guys,
How do i select and insert a data from 1 table to another with same table
fields.
mysql select * from cardv2_data where refcode = '10-44';
Is it like this??
mysql select * from cardv2_data where refcode = '10-44'; insert into * copy
this to this table.
Please help!
--
Louie Miranda
Thanks to all. This was a Linux machine and im also learning how to interact
with this so iwill try to do all you said. Thanks.
lgaray
On 9/21/05, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Martijn,
sorry if I sounded perhaps unfriendly. That was not against you.
Imagine that many people
Hello,
I was wondering if anyone had any knowledge to share regarding
creating many 2GB innodb table space files, vs creating a few 100GB
ones.
It has been my habit to create many smaller for several reasons,
including nfs clients/servers or utlities which don't reliably copy/
back
4.1.4 is beta version, isn't it ? I'll suggest you try the latest
binary for 4.1 available for your setup.
Oops, sorry, type mismatch error... I mean 4.1.14, the most recent
I suspect that the current version of MySQL frees the resources
automatically,
no, it does not :-)
I thought
Louie Miranda wrote:
How do i select and insert a data from 1 table to another with same table
fields.
INSERT .. SELECT -- it's in the manual at:
http://dev.mysql.com/doc/mysql/en/insert-select.html
It's always good to read the manual before asking questions on the list,
as a large number of
Hi Pooly,
I know your busy, but please help me, i need to submit this by today for the
testing team.
If you dont mind can you please guide to any url or documentation where i
can find the complete steps to connect from oracle 8.1.7.4
http://8.1.7.4on sun
5.8 to mysql 4.1.14 on Lunix fedaro with
Jasper Bryant-Greene wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;
Sometimes when I execute this stored procedure with, for
Hi
Thanks for the help. However, the query you suggest
Select 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
Gives only one reccord, hence the sum is
68 matches
Mail list logo