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
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
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 table
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
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
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?!) for
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
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,
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. |
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
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;
+ mysql select *
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:
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
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
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 which
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.
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:
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 Mailing List
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
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
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:
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
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 TEMPORARY TABLE
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
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
Sorry. In hast, I copied the wrong results. I generated a new set-here
they are:
=
1) WHAT IS INSERTED
=
ord binary
0fc1 4033
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
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
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
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 Mailing
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 Noyes
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,
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 are
See remarks intererspersed in question.
Rhino
- Original Message -
From: Duncan Miller [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 08, 2005 12:42 AM
Subject: Re: Evaluating text as an expression
Thanks again, I am certainly learning
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
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
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 change it
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
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|
+---++-++
|
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|
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
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
42 matches
Mail list logo