TRUNCATE TABLE would work too. That would automatically remove all rows
as well.
Chris
mel list_php wrote:
Hi,
I think you are looking for something like that:
ALTER TABLE auto_increment=1 (or whatever value you want)
melanie
From: Mário Gamito <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Stephen,
That is interesting... The DBA and Oracle programmers are really raising
an issue on the difficulties of this extraction. We can use a ~ delimited
file but were told to give "our" standards. To which now they are saying
is out of time scope.
Thank you for this information since it give
It appears my email client took some liberties with converting portions of
my queries into mailto links. I've fixed them below. Sorry!
> I have a few questions about wildcard usage with Fulltext
> searches (Mysql 4.1.9). I have tried to find relevant answers
> to these questions with no success.
I have a few questions about wildcard usage with Fulltext searches (Mysql
4.1.9). I have tried to find relevant answers to these questions with no
success.
(1) Why is such a query as this allowed?
WHERE MATCH (text)
AGAINST ('+s*' IN BOOLEAN MODE)
This returns everything that starts with an
(Our mail server just flaked out, so apologies if this is a
duplicate.)
That doesn't work for me (I get '12/15/03'), but I like the
way you think, pardner. How about:
SELECT
LEFT(SUBSTRING_INDEX(LEFT(log, LOCATE('Tested this', log)), '\n', -1), 8)
FROM test WHERE log like '%tested this%';
As mentio
Mysql is telling me
my Heap table is full. Now I set it to 128M.
my.cnf
line
tmp_table_size =
128M
The Table
filled up at 12.7M This appears to be very close to 128M with a decimal
out of place.
Did I find a
Bug?
Am I doing something
wrong?
Is the tmp_table_size a PER TABLE or
WHOLLY COW!!!
That was awesome. Thanks
- Ed
>>> "Eamon Daly" <[EMAIL PROTECTED]> 3/24/05 1:48 PM >>>
SELECT
LEFT(SUBSTRING_INDEX(LEFT(log, LOCATE('\n', log, LOCATE('tested this',
log)) - 1), '\n', -1), 8)
FROM test WHERE log LIKE '%tested this%'
Don't try this at home.
_
Eamon Daly wrote:
SELECT
LEFT(SUBSTRING_INDEX(LEFT(log, LOCATE('\n', log, LOCATE('tested this',
log)) - 1), '\n', -1), 8)
FROM test WHERE log LIKE '%tested this%'
Another possibility:
SELECT SUBSTRING(log, LOCATE('\n', SUBSTRING(log, 1,
LOCATE('Tested this', log)-1))+1, 8)
FROM test WH
SELECT
LEFT(SUBSTRING_INDEX(LEFT(log, LOCATE('\n', log, LOCATE('tested this',
log)) - 1), '\n', -1), 8)
FROM test WHERE log LIKE '%tested this%'
Don't try this at home.
Eamon Daly
- Original Message -
From: "Ed Reed" <[EMAIL P
Thanks Shawn,
The idea I've been working with on this is to use an InStr to find the
point where the require substring appears. Then I need to search
backwards from there to the point where the first \n\r is found. Then
the Date that I want would be 8 characters from that position. The
obvious pr
"Ed Reed" <[EMAIL PROTECTED]> wrote on 03/24/2005 04:02:28 PM:
> Sorry everyone for not being more clear. The field IS in a multiline
> varchar field. The example data was all from one record in the table.
>
> Unfortunately, this is a database that has been around for many years
> and backward co
Sorry everyone for not being more clear. The field IS in a multiline
varchar field. The example data was all from one record in the table.
Unfortunately, this is a database that has been around for many years
and backward compatibility with other apps limits redesigning the table.
It is a Comment
"Ed Reed" <[EMAIL PROTECTED]> wrote on 03/24/2005 02:49:30 PM:
> This is an interesting problem that I hope someone can help me with. I
> have a varchar field that contains data like this,
>
> 01/01/05 SG Reviewed this
> 12/15/03 DSD Reviewed that
> 10/24/02 EWW Worked on that and tested this th
"Lily Wei" <[EMAIL PROTECTED]> wrote on 03/24/2005 03:08:28 PM:
> Is there a way to use MySQL API that established ODBC calls without
> going through ODBC driver?
>
> Is it even possible?
>
>
>
> Thanks,
>
> Lily
There is a non-ODBC API (written in C) that comes pre-packaged with your
MySQL
[snip]
[snip]
01/01/05 SG Reviewed this
12/15/03 DSD Reviewed that
10/24/02 EWW Worked on that and tested this then stop to do something
else
05/02/01 AW Did something
08/31/98 DSD Tested this
07/22/97 EWW Worked on that and did something
I need a Select statement that returns the Date for the
Is there a way to use MySQL API that established ODBC calls without
going through ODBC driver?
Is it even possible?
Thanks,
Lily
[snip]
01/01/05 SG Reviewed this
12/15/03 DSD Reviewed that
10/24/02 EWW Worked on that and tested this then stop to do something
else
05/02/01 AW Did something
08/31/98 DSD Tested this
07/22/97 EWW Worked on that and did something
I need a Select statement that returns the Date for the first o
Dan Nelson wrote:
How about:
SELECT LEFT(description, 8) FROM mytable WHERE description LIKE "%tested this%" LIMIT 1
Hmm, I assumed he was talking about a multi-line VARCHAR, but
now that I look again Dan's interpretation is probably the right
one. My previous message doesn't apply (except for t
Ed,
let me put it in a "politically incorrect", blunt way:
Am Do, den 24.03.2005 schrieb Ed Reed um 20:49:
> This is an interesting problem that I hope someone can help me with. I
> have a varchar field that contains data like this,
>
> 01/01/05 SG Reviewed this
> 12/15/03 DSD Reviewed that
>
Ed Reed wrote:
01/01/05 SG Reviewed this
12/15/03 DSD Reviewed that
10/24/02 EWW Worked on that and tested this then stop to do something
else
05/02/01 AW Did something
08/31/98 DSD Tested this
07/22/97 EWW Worked on that and did something
I need a Select statement that returns the Date for the
In the last episode (Mar 24), Ed Reed said:
> This is an interesting problem that I hope someone can help me with. I
> have a varchar field that contains data like this,
>
> 01/01/05 SG Reviewed this
> 12/15/03 DSD Reviewed that
> 10/24/02 EWW Worked on that and tested this then stop to do somet
This is an interesting problem that I hope someone can help me with. I
have a varchar field that contains data like this,
01/01/05 SG Reviewed this
12/15/03 DSD Reviewed that
10/24/02 EWW Worked on that and tested this then stop to do something
else
05/02/01 AW Did something
08/31/98 DSD Tested
You are on the right track. Don't forget to use the EXPLAIN command to
help you tune in your indexes.
One other thing that may help is to try making extracts of some of your
tables as temp tables and using them in the final JOIN query that pulls it
all together. For instance, you could make a t
Hi Shawn,
I think I may have found a solution, but the query takes quite a while
to run...here is what I have now paraphrased:
SELECT
vd.id AS id,
vd.session AS session,
vl.value AS content,
vd2.varvalue AS browser,
vl3.value AS bandwidth
FROM vardata AS vd
LEFT OUTER JOI
At 11:07 AM 3/23/2005, V. M. Brasseur wrote:
You say it usually crashes near the same record? Could you post the
record information and also the query which is being run?
Also, is there any information in your hostname.err file? If mysqld is
bailing (and it appears that it is), it ought to be
On Thursday 24 March 2005 10:27 am, Marc Dumontier wrote:
> I had a slave machine (ralph) as backup to a master machine (barney). I
> then made ralph the production server, and turned off barney. I now want
> to make barney a backup to ralph (so ralph would be the master).
http://dev.mysql.com/do
Hi,
i'm working with mysql 4.1
I had a slave machine (ralph) as backup to a master machine (barney). I
then made ralph the production server, and turned off barney. I now want
to make barney a backup to ralph (so ralph would be the master).
I see in the logs that ralph is still trying to connect
On Thursday, March 24, 2005 10:06, J.R. Bullington wrote:
> You can change it on the command line by
>
> mysql> set date_format = '%m-%d-%Y';
>
> However, this may be a client-only view, as I am still trying to get
> the global variable to change.
[shell]
#mysqld -v --help | grep date_format
Hi there's a free utility name dbf2mysql I assume you are running dbase3
plus under windows/dos
Look for it in google or ask me and I would send it to you.
I´ve used it under windows with dbf tables from Clipper, dBase and Fox
It doesn't require ODBC drivers at all.
greetings
Mauricio
On Wed,
You can change it on the command line by
mysql> set date_format = '%m-%d-%Y';
However, this may be a client-only view, as I am still trying to get the
global variable to change.
J.R.
PS - Sorry it took me so long Mark, was busy and AFK
-Original Message-
From: [EMAIL PROTECTED] [mailto
Mathew Ray <[EMAIL PROTECTED]> wrote on 03/24/2005 10:42:51 AM:
> Been searching for a while and can't seem to come up with any good
> answers to this - I have a normalized structure of about 5 tables that I
> need to denormalize into one big representation of the entire structure.
> Anyone
Hello list,
I have a big table, 25M records and a lot of indexes on it.
Sometimes, it happens that we need to create an new index on the
table, and I was wondering if there is a solution to do an
ALTER TABLE... ADD INDEX without having mySQL to rebuild all indexes ?
Thanks,
CheHax
--
MySQL Gene
Been searching for a while and can't seem to come up with any good
answers to this - I have a normalized structure of about 5 tables that I
need to denormalize into one big representation of the entire structure.
Anyone know of a good tool or resource to 'flatten' my tables easily?
I've got a
David Blomstrom <[EMAIL PROTECTED]> wrote on 03/24/2005 12:28:53
AM:
> I was trying to imnport a csv file into an online
> databse table, but I kept getting error messages
> alluding to a "child row," foreign key, etc. So I
> decided to delete both keys (primary and index), then
> import the csv
Hello all,
Suppose I have a LAMP server which functions good enough for daily use
by humans, but is occasionally brought to its knees by an automated
website-downloader, when such a download involves a lot of database
searches, which uses up all the available MySQL connections.
Is there anything
Check your DATE format in your server variables... MySQL default date format
is -MM-DD. You can change it, however until then, you have to use
update policies set renewdate = '2006/02/21' where polnumber = 'WRIM01002';
HTH,
J.R.
Hello. This is a frequently asked question. For example read
Graham Anderson <[EMAIL PROTECTED]> wrote on 03/23/2005 08:09:48 PM:
> I have 3 different tables I need data from
> And, the tables have the potential to get fairly large
> I am using mysql 4.1.3
>
> This working query below pulls up all media requests for 'Yolanda
> Perez' in Los Angeles
Graham Anderson <[EMAIL PROTECTED]> wrote on 03/23/2005 06:19:34 PM:
> stupidly
> My DateTime field is in this format:
> March 23, 2005, 3:49 pm
>
> If I want to run this sql
> SELECT TO_DAYS(MAX(DateTime)) - TO_DAYS(MIN(DateTime)) AS record
> FROM userLog
>
> I gather I need some extr
From: "Paul Groves"
> The main con for me is that it won't index words of three characters
> (which I think I will in my queries) or less unless I change the default
> server setting (can you do this on a by database basis?), which may be
> possible, but it depends where its finally hosted...
You
Jigal van Hemert wrote:
From: "Paul Groves"
BTW is there anyway to speed up the search, as I think this may be
pretty slow (there will be about 25000 records in the real database...)
e.g. maybe by doing a LIKE match for "%elbow%" first then doing a REGEXP
within that? Not sure how one would code th
Hi,
I could get the expected result in version 4.1.10a-log with that former
single query , which failed in your environment. May be some configure
options missing? Which configure options is your Mysql built with ? !!
Regards
Usha
- Original Message -
From: "Paul Groves" <[EMAIL PROTEC
From: "Paul Groves"
> BTW is there anyway to speed up the search, as I think this may be
> pretty slow (there will be about 25000 records in the real database...)
> e.g. maybe by doing a LIKE match for "%elbow%" first then doing a REGEXP
> within that? Not sure how one would code the SQL for that,
Paul Groves wrote:
Jigal van Hemert wrote:
From: "Paul Groves"
SELECT * FROM object WHERE description REGEXP '[[:<:]]elbow[[:>:]]';
There are records in the object table that have the following
description fields (as test data):
elbows ligaments
elbowed ligaments
My elbow
elbow joint
Whose elbow is
Jigal van Hemert wrote:
From: "Paul Groves"
SELECT * FROM object WHERE description REGEXP '[[:<:]]elbow[[:>:]]';
There are records in the object table that have the following
description fields (as test data):
elbows ligaments
elbowed ligaments
My elbow
elbow joint
Whose elbow is that
The query sho
From: "Paul Groves"
> SELECT * FROM object WHERE description REGEXP '[[:<:]]elbow[[:>:]]';
>
> There are records in the object table that have the following
> description fields (as test data):
>
> elbows ligaments
> elbowed ligaments
> My elbow
> elbow joint
> Whose elbow is that
>
> The query sho
Hi,
I think you are looking for something like that:
ALTER TABLE auto_increment=1 (or whatever value you want)
melanie
From: Mário Gamito <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: Resetiing indexes
Date: Thu, 24 Mar 2005 11:41:30 +
Hi,
I'm using MySQL on a project, and duri
Hi,
I'm using MySQL on a project, and during the development stage, the
number of the (auto incrmenting) indexes went increasing.
Now that the deed is done, how can i "reset" them back to 1, without
having to throw away the database and rebuilding it from scratch ?
Any help would be apreciated.
I'm having a problem with REGEXP and word boundaries, my query does not
throw an errow, but isn't giving me any results e.g. my query is:
SELECT * FROM object WHERE description REGEXP '[[:<:]]elbow[[:>:]]';
There are records in the object table that have the following
description fields (as test
Hello.
This is a frequently asked question. For example read these threads:
http://lists.mysql.com/mysql/175324
http://lists.mysql.com/mysql/177730
Shuan <[EMAIL PROTECTED]> wrote:
> Dear all,
>
> How to change the Default Date/DateTime Format of MySQL server?
> I'm us
This is not really a MySQL question so much as it is a PHP/HTML
question, but it's a quick answer.
Replace
echo "".$rows['lastname']
With
echo "".$rows['lastname']
On the next page, $_REQUEST['person'] contains the selected chairid.
Martin Toombs wrote:
Sorry if this is simple, but I'm a fairly n
50 matches
Mail list logo
