I was benchmarking a few of my queries tonight and I noticed that two
queries had different query plans based on table type.
Here's the "broken" query:
mysql> EXPLAIN SELECT * FROM FOO_LINK_MEMORY_TEST GROUP BY
TARGET_NODE_ID\G
*** 1. row ***
Anybody have an idea why I might be getting the following message:
ERROR 1064 (0): You have an error in your SQL syntax near
'('hello','password')' at line 1
When I type this in at the command line:
SELECT AES_ENCRYPT('hello','password');
Version info: mysql Ver 14.7 Distrib 4.1.12,
Hi,
We're having a problem with "lock wait timeout exceeded" errors. We are
exclusively using innodb tables apart from the mysql database. The
problem seems to be with the way we are simulating sequences.
There is a table called SEQUENCES defined as follows:
CREATE TABLE IF NOT EXISTS Sequ
Shawn,
Your correct about my algorithm for IPv4, I was not paying attention (too
many things at once). It should have read:
AAA.BBB.CCC.DDD
\\ \\
\\ \ DDD
\ \ CCC x 256
\ BBB x 256 x 256
AAA x 256 x 256 x 256
I'd like to add a bit of history data to a table (who changed a record
last, and when it was last changed). Is this the way to do it?
alter table MEMBERS
add CHG_BY varchar(3)
alter table MEMBERS
alter CHG_BY set default "sbk"
alter table MEMBERS
add CHG_DATE date
Raz wrote:
Dan,
Forgot to say, re. MySQL Workbench - this may be a useful source of info:
http://forums.mysql.com/list.php?113
Raz
Sent off the link to the forum before I moved on to this message. D'OH!
G.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
Chance Ellis wrote:
[snip]
> of CREATE TABLE entries. I then import those files with a cron script into
> mysql. This is where I am looking to convert IP address into something
[snip]
There is a world of possibilities at this point, one is this:
sed \
--expression='s/@@@NEEDTOREPLACETHIS\([012345
You should be able to do the conversion when you run the cron script. Or at
least just before. Preprocess the output from syslog-ng to translate all .
to _. in the table names.
Jerl
On 10/3/05, Chance Ellis <[EMAIL PROTECTED]> wrote:
>
> So more information about the project...
> I am working
Chance Ellis wrote:
[snip]
Thus, syslog-ng creates a file that contains a bunch of CREATE TABLE
entries. I then import those files with a cron script into mysql.
This is where I am looking to convert IP address into something
without periods. I cannot perform logic within the .conf file and it
a
So more information about the project...
I am working on a syslog-ng project to input syslog messages into mysql.
The syslog-ng.conf file is the only way to tell syslog-ng where to put data.
You can perform filtering based on predefined syslog-ng macros such as
$HOST, $DATE $TIME etc... however wi
Hi Keith,
Thanks, it did work.
I was trying to use a regular expression but this is just fine for my
needs.
On Mon, 2005-10-03 at 13:18 -0400, Keith Ivey wrote:
> Richard F. Rebel wrote:
>
> > do I say REGEXP BINARY ""
> >
> > I have tried \000 \0 as they are common representations for binary
- Original Message -
From: [EMAIL PROTECTED]
To: Barry
Cc: mysql@lists.mysql.com
Sent: Monday, October 03, 2005 9:49 PM
Subject: Re: Query Trouble!
"Barry" <[EMAIL PROTECTED]> wrote on 10/03/2005 04:38:48 PM:
> I'm new to MySQL and am using version 4-1-12a on my de
"Barry" <[EMAIL PROTECTED]> wrote on 10/03/2005 04:38:48 PM:
> I'm new to MySQL and am using version 4-1-12a on my development
> machine locally this query works just fine:
>
> SELECT * FROM actor
> WHERE id IN
> ( SELECT id FROM episode_cast
> WHERE episode_number =001)
>
I'm new to MySQL and am using version 4-1-12a on my development
machine locally this query works just fine:
SELECT * FROM actor
WHERE id IN
( SELECT id FROM episode_cast
WHERE episode_number =001)
but when I try to run it from the web server which is running version
4.0.24
Jeff Pflueger <[EMAIL PROTECTED]> wrote on 10/03/2005 03:46:09 PM:
> Hi,
> I need to encrypt data as I insert it into a mySQL database.
> The data will then be sent as a text file to another institution to be
> decrypted.
>
> I am using mySQL version 11.18 Distrib 3.23.58 for RedHat Linux.
>
> I
I currently have an application that is written on the 4.0 C API, but supports
both 4.1 and 4.0 client/server. My question is if I move my application to
support 5.0 and some of the new API's will the 5.0 Application/client be able
to communicate with a 4.1 or 4.0 server?
I support windows, HP
Replies embedded:
"Patrick" <[EMAIL PROTECTED]> wrote on 10/03/2005 03:43:20 PM:
> There are many ways to approach this. How are you receiving the IP
> data? Are you reading a file or other stream or are you trying to
> process the table creation by reading a column from a previously
> popul
Thanks Shawn,
Your reply was clear. To get MySQLd results I will use ADODB.
I need these results for error trapping and included in my VB code:
Dim adbError As ADODB.Error
and forced an error with:
adbConn.Execute ""SELECT a MOD b;"
and finally the trapping code to get the mySQL error messages
Hi,
I need to encrypt data as I insert it into a mySQL database.
The data will then be sent as a text file to another institution to be
decrypted.
I am using mySQL version 11.18 Distrib 3.23.58 for RedHat Linux.
I cannot find a single encryption function in the documentation that
seems to not cr
> > Jim,
> >
> > I didn't word my question quite right because I was only guessing at
> > what a LVM snapshot was. Moreover, what you're saying is all correct.
> > However, I was not suggesting that the snapshot be kept around once the
> > backup is made.
> >
> > Let's go to article "What is a
There are many ways to approach this. How are you receiving the IP data? Are
you reading a file or other stream or are you trying to process the table
creation by reading a column from a previously populated table through a select
statement?
The functions, inet_ntoa() and inet_addr(), are par
anyone using openoffice:base to design mysql db's? back when I tried it
earlier this year it wasn't able to define relationships which made it
pretty much useless as a time saving tool.
-Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
- Hi and Welcome to -
LASSO TIPS FOR MYSQL: 3.0
I'm your host, M i l e s.
First and foremost, a good place for you to start with Lasso is the
following 5 things:
The FIRST LASSO TIPS FOR NEWBIES
-> http://www.listsearch
Hello.
> What's the reason behind this?
If you're asking about why I've written that columns defined as NOT NULL
are faster - I've read it in one of the articles from dev.mysql.com.
I'm not sure about the true reason, but the way MySQL stores NULLs
is strongly dependent on the storage engi
If it's a DoS attack then perhaps you should be speaking to your ISP and
getting that resolved rather than trying to work around the problem on
your side of things!
Having said that, you could possibly impose host level restrictions in
MySQL, but that could be a lot of work to modify your exis
In the below query, the results first row is usually the same 3-4
tracks out of 30.
so should I use PHP to generate a random seed, $r, and pass that to the
query ?
ORDER BY RAND($r)
or, can it be done just with mysql
many thanks
g
On Oct 3, 2005, at 10:15 AM, Michael Stassen wrote:
Graham A
D'OH! You're right. heh So much for the degree in computer science. lol
Jenifer
- Original Message -
Subscriptions wrote:
Er... do you mean this instead?
>
> UPDATE your_table
> SET decimal_field = decimal_field + (0.15 * decimal_field);
No, but they do the same thing:
Subscriptions wrote:
Er... do you mean this instead?
>
> UPDATE your_table
> SET decimal_field = decimal_field + (0.15 * decimal_field);
No, but they do the same thing:
decimal_field + (0.15 * decimal_field)
= (1 * decimal_field) + (0.15 * decimal_field)
= (1 + 0.15) * decimal_field
=
Er... do you mean this instead?
UPDATE your_table
SET decimal_field = decimal_field + (0.15 * decimal_field);
Would this work?
Jenifer
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Subscriptions" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, October 03, 2005 12:25 P
Subscriptions wrote:
I have a decimal field in my table... what would be the query to add 15%
to that number in every row? I need to mark the column up by 15% and want to
make sure I get the query right the first time. heh
Jenifer
UPDATE your_table
SET decimal_field = 1.15 * decimal_field;
Richard F. Rebel wrote:
do I say REGEXP BINARY ""
I have tried \000 \0 as they are common representations for binary null.
Have you tried "WHERE your_column LIKE '%\0%'"? That works for me.
--
Keith Ivey <[EMAIL PROTECTED]>
Smokefree DC
http://www.smokefreedc.org
Washington, DC
--
MySQL Ge
Graham Anderson wrote:
is there a way to make ORDER BY RAND() a bit more spontaneous ?
I am using it in a php statement:
$sql = "SELECT media.id,
artist.name as artist,
artist.spanish as bio,
artist.purchaseLink,
artist.picture,
media.spanish as trackName
change the seed on the random function.
http://dev.mysql.com/doc/mysql/en/mathematical-functions.html
On Mon, 2005-10-03 at 08:33 -0700, Graham Anderson wrote:
> is there a way to make ORDER BY RAND() at bit more spontaneous ?
>
> I am using it in a php statement:
> $sql = "SELECT media.id,
>
Hi,
I have tried several formulations using BINARY, but cannot see how to
apply it.
do I say REGEXP BINARY ""
I have tried \000 \0 as they are common representations for binary null.
On Mon, 2005-10-03 at 17:52 +0100, Andrew Braithwaite wrote:
> Hi,
>
> You could try the binary operator:
>
Title: Security Question
Hi All --
I have been a member of this list for a while but I actually have a question that I can't answer.
MySQL v4.1.14-nt on Win2k3 Server
I've got someone who is trying to get in, but I have locked it down. Methods used include, but are not limited to:
No
Hi,
You could try the binary operator:
http://dev.mysql.com/doc/mysql/en/charset-binary-op.html
Cheers,
Andrew
-Original Message-
From: Richard F. Rebel [mailto:[EMAIL PROTECTED]
Sent: Mon, 03 Oct 2005 17:48
To: Untitled
Subject: How to match a binary null in a varchar column???
Hel
Hello,
How do you match all rows with a binary null (octal 000) in a given
column.
I have tried all sorts of strange combinations of REGEXP and LIKE with
no results. I have dug in the manual, but can't seem to find anything.
Any help would be appreciated.
--
Richard F. Rebel
cat /dev/null >
This looks great! Is there anything like this for Mac OS X?
Kevin
On 10/2/05 10:39 PM, "Ligaya Turmelle" <[EMAIL PROTECTED]> wrote:
> +1 - it is wonderful.
>
> olinux wrote:
>
>> You will love this.
>> http://www.fabforce.net/dbdesigner4/
>>
>> Josh
>>
>>
>> --- Jeffrey Goldberg <[EMAIL PRO
I have a decimal field in my table... what would be the query to add 15% to
that number in every row? I need to mark the column up by 15% and want to make
sure I get the query right the first time. heh
Jenifer
Hi,
Thanks for your detailed reply.
Kind regards,
Martijn
On Sunday 02 October 2005 21:18, Gleb Paharenko wrote:
> Hello.
>
> > For InnoDB I'm not sure, so I don't make guessings.
>
> I'm continuing the previous message. Here is what I've found out:
>
>
> InnoDB has its own open file statist
Gerhard Prilmeier wrote:
Hello,
I use tables with one primary key (which is the only unique key). I'd
like to export data from such a table to a file, and then import it on
another machine.
If a duplicate unique key is found when importing with LOAD DATA INFILE,
How does that happen? I tak
is there a way to make ORDER BY RAND() at bit more spontaneous ?
I am using it in a php statement:
$sql = "SELECT media.id,
artist.name as artist,
artist.spanish as bio,
artist.purchaseLink,
artist.picture,
media.sp
"C.R. Vegelin" <[EMAIL PROTECTED]> wrote on 10/01/2005 03:51:41 AM:
> Hi List,
>
> I want to call the C API functions from Visual Basic in MS Access 2003.
> I assume that I have to use: "c:\Program Files\MySQL\MySQL Server 4.
> 1\Bin\LibMySQL.dll".
> In my code at module level I have included var
Le lundi 03 octobre 2005 à 16:24 +0200, Bastian Balthazar Bux a écrit :
> Yannick Warnier wrote:
> > Le lundi 03 octobre 2005 à 12:29 +0200, Martijn Tonies a écrit :
> >
> >>>Using PhpMyAdmin, I seldom get the warning message:
> >>>PRIMARY and INDEX keys should not both be set for column `ID`
> >>
Hi all,
I have just upgraded a master slave database system from 4.0 to 4.1.
the replication binlogs are now growing at a vastly greater rate. The
queries going through are the same. Did 4.0 use some kind of
compression by default or something?
Does anyone have any idea what's going on wi
Yannick Warnier wrote:
> Le lundi 03 octobre 2005 à 12:29 +0200, Martijn Tonies a écrit :
>
>>>Using PhpMyAdmin, I seldom get the warning message:
>>>PRIMARY and INDEX keys should not both be set for column `ID`
>>>
>>>I understand its meaning, but I was wondering to what extent having a
>>>field
Hello,
I use tables with one primary key (which is the only unique key). I'd like
to export data from such a table to a file, and then import it on another
machine.
If a duplicate unique key is found when importing with LOAD DATA INFILE,
MySQL gives me the choice of whether to
1. stop executi
Le lundi 03 octobre 2005 à 12:29 +0200, Martijn Tonies a écrit :
> > Using PhpMyAdmin, I seldom get the warning message:
> > PRIMARY and INDEX keys should not both be set for column `ID`
> >
> > I understand its meaning, but I was wondering to what extent having a
> > field indexed AND being a prim
Yannick Warnier <[EMAIL PROTECTED]> wrote on 03/10/2005 11:18:05:
> Hi all,
>
> Using PhpMyAdmin, I seldom get the warning message:
> PRIMARY and INDEX keys should not both be set for column `ID`
>
> I understand its meaning, but I was wondering to what extent having a
> field indexed AND being
> Using PhpMyAdmin, I seldom get the warning message:
> PRIMARY and INDEX keys should not both be set for column `ID`
>
> I understand its meaning, but I was wondering to what extent having a
> field indexed AND being a primary key might slow down/speed up my
> queries.
>
> Is that gonna take twice
Hi all,
Using PhpMyAdmin, I seldom get the warning message:
PRIMARY and INDEX keys should not both be set for column `ID`
I understand its meaning, but I was wondering to what extent having a
field indexed AND being a primary key might slow down/speed up my
queries.
Is that gonna take twice the
Gleb Paharenko wrote:
I'm not giving an exact answer on your question, however, it might be
interesting for you. Usually queries are faster if you define the column as NOT
NULL.
What's the reason behind this? NULL 'values' are a bit of strange
phenomenon. In the EXPLAIN output a query with WH
Hello.
I'm not giving an exact answer on your question, however, it might be
interesting for you. Usually queries are faster if you define the column as NOT
NULL.
Lefteris Tsintjelis wrote:
> Hi,
>
> What is better/faster to insert as a value for indexed fields, in case of
> 0 or Null
Hi,
What is better/faster to insert as a value for indexed fields, in case of
0 or Null values, to leave it blank ('') or to insert a '0'/'NULL'?
Thnx,
Lefteris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC
54 matches
Mail list logo
