If you could present sample data of both table1,
table2, and an example of the result set it would be
easier to give you the sql. I believe you could
eliminate the temporary table with a subselect in the
original query. The subselect is where you would
specify 'Smith'.
Dave
--- mos <[EMAIL PROTECT
There can also be a [mysql] section that will apply to all applications
that read the my.cnf file. It is sort of the "default" section.
[mysql]
socket=/tmp/mysql.sock
[mysqld]
datadir=/var/lib/mysql
socket=/tmp/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
socket=/tmp/mysql.sock
[safe_
Jim Winstead wrote:
On Wed, Nov 09, 2005 at 02:06:59PM +1100, Daniel Kasak wrote:
Background on data:
mysql> select ID, Loc_FK, BatchNo, EAPDate from EAPosting where Loc_FK=7249;
+---++-++
| ID| Loc_FK | BatchNo | EAPDate|
+---++-+
On Wed, Nov 09, 2005 at 02:06:59PM +1100, Daniel Kasak wrote:
> Background on data:
>
> mysql> select ID, Loc_FK, BatchNo, EAPDate from EAPosting where Loc_FK=7249;
> +---++-++
> | ID| Loc_FK | BatchNo | EAPDate|
> +---++-++
>
Greetings.
I thought I'd run this one by the list before panicing and submitting a
bug report.
A couple of weeks ago, I did a mysqldump of all our databases,
uninstalled 4.0.something, did a clean install of 4.1.14, and imported
from our backups. As far as I could see, the upgrade went flawl
"David Inglis" <[EMAIL PROTECTED]> wrote on 11/08/2005
09:33:27 PM:
> I am having the following problem
>
> with the setting for socket in the my.cnf configuration file set to
> socket=/tmp/mysql.sock I am able to connect through a browser but cannot
> connect using the mysql client when I cha
I am having the following problem
with the setting for socket in the my.cnf configuration file set to
socket=/tmp/mysql.sock I am able to connect through a browser but cannot
connect using the mysql client when I change it to
socket=/var/lib/mysql/mysql.sock I can access through mysql client but
I figured out that it wasn't really the special characters that were
the issue, but the
addslashes function in php with the html tags. I just got rid of the
back slashes and all
is good. Sorry for the noise...
Thanks,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Nov 8,
See remarks intererspersed in question.
Rhino
- Original Message -
From: "Duncan Miller" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, November 08, 2005 12:42 AM
Subject: Re: Evaluating text as an expression
> Thanks again, I am certainly learning a lot more a
On Sun, November 6, 2005 2:17 am, Chris W wrote:
> I just tried to use the output of the export function on phpmyadmin
> and
> got a million errors. After looking at the file I found that certain
> columns that are strings were not quoted at all. I can't find any
> reason why some are and some ar
Is this the wrong list to ask this on?
If so can someone suggest a better list?
Am I missing something in my analysis of my problem?
Did I not include enough info?
Could it be a problem with perl scripts?
Thanks,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Nov 8, 2005,
At 04:33 PM 11/8/2005, Scott Noyes wrote:
> select * from table1 t1 left join table2 t2 on t1.date1=t2.date2 where
> t2.date2 is null
> where t2.name='Smith'
Maybe this?
select * from table1 t1 left join table2 t2 on t1.date1 = t2.date2 AND
t2.name = 'Smith' WHERE t2.date2 is null;
--
Scott Noy
> select * from table1 t1 left join table2 t2 on t1.date1=t2.date2 where
> t2.date2 is null
> where t2.name='Smith'
Maybe this?
select * from table1 t1 left join table2 t2 on t1.date1 = t2.date2 AND
t2.name = 'Smith' WHERE t2.date2 is null;
--
Scott Noyes
[EMAIL PROTECTED]
--
MySQL General Maili
I would like to find the missing subset of rows in table2 based on the rows
in table1.
Normally it would look like this:
select * from table1 t1 left join table2 t2 on t1.date1=t2.date2 where
t2.date2 is null
Well this works fine except I only want to compare a subset of rows in
table2 for
Title: Column type problem
I am trying to create a table to import data on cpu usage based on certain programs. the following is a sample of the data. When I import into the tables their is no field type that matches up to this type of time data. The field type (time) is close to it but
Can this also be used? (just now figured out a way)
SELECT
bo.book,
b.chapter,
b.verse,
b.text
FROM
avkjv.books bo
LEFT JOIN
Sorry. In hast, I copied the wrong results. I generated a new set-here
they are:
=
1) WHAT IS INSERTED
=
ord binary
0fc1 4033
Instead of using COLLATE you can try using the "BINARY" option
instead. It will work in older versions of MySQL and I think it makes
you select a bit more readable. Just put "BINARY" before the
comparison you want to be case sensitive.
WHERE BINARY text LIKE '%Jehovah%'
On Nov 8, 2005, at
Hi,
if the character_set_client is by default latin1, does that mean that
the java application is sending latin1?or is it changed at runtime?
kind of lost again.
As I understand, the charset of the column/table/database is irrelevant,
there will be no conversion if you query from or inse
In article <[EMAIL PROTECTED]>,
"Barbara Deaton" <[EMAIL PROTECTED]> writes:
> Thank you for the idea. It fixed my date problem, but my numeric column is
> still 0 and NOT "NULL." Here's what I did:
> create table a (
> d date default null,
> e smallint default null );
> CREATE TEMPO
At 19:05 -0500 11/7/05, Eric Herrera wrote:
I'm attempting to sort using utf8_bin and I don't think its sorting
properly. I believe I have everything set correctly. I've appended
all related data. I also have a small perl script below which I used
to
generate the tests.
I may be wrong, but I
sorry i should have put the result of the show variables:
*** 5. row ***
Variable_name: character_set_client
Value: latin1
*** 6. row ***
Variable_name: character_set_connection
Value: la
Hi folks,
I want to load a set of PDFs into a MySQL 5 ISAM table. I'm using the
following command
LOAD DATA INFILE '1037021.pdf' INTO TABLE complete FIELDS TERMINATED BY
'%%EOF' (d_c)
in the Query Browser 1.1.17, MySQL 5.0.15, running on W2K. Field d_c is
defined as LONGTEXT.
The followi
Hi guys,
I don't really understand the character set in mysql from the doc.
Tu summarize my problem:
users upload xml files (UTF-8).
part of the data is then inserted into MySQL (CHARSET=latin1)
at that point, when I browse via phpmyadmin (which is isolatin1) or export
to an html page no proble
2005/11/8, prathima rao <[EMAIL PROTECTED]>:
> hai all , im using mysql 4 version
>
> we are trying to connect inter units thriugh VPN will my database work and
> how?
You just need to open the port 3306 on your firewall. No other step
should be requiered.
>
>
> p rao
>
>
> --
> MySQL General M
That worked Perfect!!!
Thanks a ton!
On 11/8/05 11:27 AM, "Shen139" <[EMAIL PROTECTED]> wrote:
> ALTER IGNORE TABLE mytbl ADD UNIQUE KEY ( Name, email, sex, country ) ;
Rahul S. Johari
Coordinator, Internet & Administration
Informed Marketing Services Inc.
251 River Street
Troy, NY 12180
Tel:
Hi,
It¹s didn¹t work. I think I know why.
I have 5 fields in my table. ID, name, email, sex, country.
Although in the duplicate rows.. Name, email, sex & country values are
duplicate, the value in the ID column is different for each. It happened so
when people added their entry multiple times. Th
Hi,
I used the following SQL Query to determine Duplicate Records with same Name
& Email in the row:
SELECT email,
COUNT(email) AS NumOccur1, name, COUNT(name) AS NumOccur2
FROM mytbl
GROUP BY name, email
HAVING ( COUNT(email) > 1 ) AND ( COUNT(name) > 1 )
I want to delete all the records whi
> I'd love to get the offset working if possible.
Since offset is not in the supported syntax for deletes (see
http://dev.mysql.com/doc/refman/5.0/en/delete.html), I think you'll
have some trouble with that.
You could do something like this:
SELECT @theDeadline := `timestamp` FROM `table` ORDER B
Thank you for the idea. It fixed my date problem, but my numeric column is
still 0 and NOT "NULL." Here's what I did:
create table a (
d date default null,
e smallint default null );
CREATE TEMPORARY TABLE tmp (
d TEXT not NULL,
e TEXT not NULL );
LOAD DATA LOCAL INFILE "c:\
I am running MySQL 5.0.15-nt on Windows 2000 PRO and use PHP as
front-end for word search in Bible. My goal is to set an option for
case sensitivity in text search. For example, if I want to search for
the word "Jehovah*" I would expect "Jehovah" not "JEHOVAH". This
query works for my objective:
"Senthil Kumar K" <[EMAIL PROTECTED]> wrote on 11/08/2005 08:31:28
AM:
> Hi all,
>
> i want to upgrade Mysql 3.23 to 4.1.14-standard.
>
> I've a table with the following structure in Mysql 3.23.
>
>
> + create table test ( amount double(8,4) );
> + insert into test set amount = 123456;
> + my
also.. ascii characters(1-127) sort correctly using utf8_bin
Eric Herrera wrote:
I'm attempting to sort using utf8_bin and I don't think its sorting
properly. I believe I have everything set correctly. I've appended all
related data. I also have a small perl script below which I used to
genera
Hi all,
i want to upgrade Mysql 3.23 to 4.1.14-standard.
I've a table with the following structure in Mysql 3.23.
+ create table test ( amount double(8,4) );
+ insert into test set amount = 123456;
+ mysql> select * from test;
+-+
| amount |
+-+
| 123456. |
Lee,
Gleb is right. Conceptually, MySQL 'locks' every table that it uses in a
SELECT query. The functions are ::store_lock() and ::external_lock(). But in
the case of InnoDB, those table locks are very weak, they do not block
anything.
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, r
Hello.
In my opinion, it is just for some statistics. The variable
locks_immediate (which corresponds to Table_locks_immediate) is
incremented very often in mysys/thr_lock.c in this way:
statistic_increment(locks_immediate,&THR_LOCK_lock);
lee wrote:
> Why would a simple select a
Hello.
Reading this could help a bit you:
http://dev.mysql.com/doc/refman/5.0/en/temporary-files.html
>Hi,
>
>While I was trying to index a field on an already existing table, my
>partition became full. Checking into mysql database I realized the
>repository (if it is so called?!) fo
Lindsey wrote:
ok thanks, then i know!
but do you know how to use the * in regexp searches. err what i mean if i want
to search for * and not use it as asterix?
i have tried \* but that did't work, it just does the same as *.
The manual comes again to the rescue ;-)
Appendix G [1] tells us:
I tried using
`mysqldump $log -v -Q -c --set-charset --default-character-set=utf8
--add-drop-table --add-locks --create-options --disable-keys
--extended-insert --lock-tables --quick $db_name -r $bk_file 2>&1`
and I still get
-- MySQL dump 10.9
--
-- Host: localhostDatabase: --
On Tuesday 08 Nov 2005 08:42, Timothy Wu wrote:
> another partition. So I manually removed the files. However, not much disk
> space was freed from the operations. I suspect what I removed were hard
> symlinks, but I wasn't quite sure. Why wasn't my disk space freed? How
> would I be able to free
ok thanks, then i know!
but do you know how to use the * in regexp searches. err what i mean if i want
to search for * and not use it as asterix?
i have tried \* but that did't work, it just does the same as *.
Quoting Jigal van Hemert <[EMAIL PROTECTED]>:
> Lindsey wrote:
> > Lets say the tabl
Hi,
While I was trying to index a field on an already existing table, my
partition became full. Checking into mysql database I realized the
repository (if it is so called?!) for the database files (frm, myd, and myi)
were located at /var/lib/mysql/diginorth/. I found three files started with
pound
Lindsey wrote:
Lets say the table contains the following brands
SAMSUNG
SIEMENS
SONY
If you do a fulltext boolean search with the term:
-S*Y
-(S*Y)
everyting that starts with an S will be excluded... any solutions?
Although I couldn't find a question in your post, I guess you want to
know h
43 matches
Mail list logo
