You need create your select statement using a variable and the do the
prepare statement;
Drop Procedure If Exists RankStock;
DELIMITER |
Create Procedure RankStock(IN TableNameIn CHAR(20),IN ColNameIn
CHAR(20))
begin
Set @selStmt = Concat("Select ",ColNameIn," from ",TableNameIn,"
order by ",Co
Have a look at kern.threads.max_threads_per_proc: 1500
and kern.threads.max_groups_per_proc: 1500
You are probably hitting one of these sysctl's. Here is a link to
some other info
http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2006-01/msg2.html
There is also a wiki on Freebs
2006/10/4, Dominik Klein <[EMAIL PROTECTED]>:
> You can only specify one IP address to bind to.
If you omit this option, mysqld will bind to all addresses on the
machine. If this is not what you want, you could block mysql-access with
a packet filter for the IP addresses you do not want to bind
I have a dozen tables and I need to perform the same operations on them so
I thought I'd create a stored procedure and just pass the table name,
column name.
I was hoping it would take the parameters and substitute that in the code.
So it looks like this:
create procedure RankStock(IN TableN
On 2006-10-04 Scott Hamm wrote:
> OBJECTIVE:
> INPUT:
> E524541015.txt:20061004|,535,999|Scot|Hamm|,410|||101 Walter
> Rd|Dover|MD|76709|,041|
...
> Been trying to get mysqlimport to use these characters to no avail, how do
> I get around to it?
I can't answer your
Hi All,
I've got a client, written in C++, that connects to a MySQL (5.x) DB. I
need keep my connection open for a long time (right now hours, but possibly
days in the future). But I need this client and only this client to
maintain the connection for a long time. All my other clients need
/*
OBJECTIVE:
INPUT:
E524541015.txt:20061004|,535,999|Scot|Hamm|,410|||101 Walter
Rd|Dover|MD|76709|,041|
WHERE error (,###) can be in any fields *AFTER* the first "|" char
DESIRED OUTPUT:
filename: E524541015.txt
ord: 20061004
error: 535
error1: 999
error2: 410
error3: 0
Brian,
My bad in steering you into the offset direction. You are right. Offset
cannot be used within a delete statement. However, if I am reading your
email correctly, you could specify a cutoff date and use that in the Delete
statement like this:
DELETE FROM tablename WHERE creation < cuto
My bad, the = was my own typo just in the email, it's not in my
actual query. I've tried using offset (delete...limit 50,99) and
it returns an error, and it is not documented (search that page you
referenced for "offset").
On Oct 4, 2006, at 9:04 AM, Rob Desbois wrote:
DELETE does sup
DELETE does support the offset
(http://dev.mysql.com/doc/refman/5.0/en/delete.html) the problem is you have an
erroneous equals character:
You wrote:
DELETE FROM tablename ORDER BY creation DESC LIMIT=n
You need:
DELETE FROM tablename ORDER BY creation DESC LIMIT offset, count
HTH,
--Rob
>
The offset is what I was thinking of - that would be the simplest -
but as far as I can tell, delete doesn't support the offset. It's not
documented, and it gives me an error when I try it. I was hoping to
avoid two queries but it sounds like that's what I might have to do.
On Oct 4, 2006,
> On Wed, 2006-10-04 at 17:22 +0200, Martijn Tonies wrote:
> > > Is there a tool available which can be used to transfer (periodically)
> > > between a MSSQL server and that of a MySQL Server?
> > > Is there anyone here who does this periodically? Either through a tool
> > > or via a command li
Brian, assuming you have an identity column of some kind (we'll call
it id here), this should work:
CREATE TABLE tmptable (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
INSERT INTO tmptable (id) SELECT id FROM tablename ORDER BY creation
DESC LIMIT 1;
DELETE FROM tablename
WHERE id NOT IN
(
You can add an offset in the Limit statement. Look at the Select Syntax in
the docs.
There is an even simpler solution to this problem. Use your creation field
within a Where clause instead of using Order by and Limit.
-Dan
I'm trying to delete all but the newest n records.
DELETE FROM
On Wed, 2006-10-04 at 17:22 +0200, Martijn Tonies wrote:
> > Is there a tool available which can be used to transfer (periodically)
> > between a MSSQL server and that of a MySQL Server?
> > Is there anyone here who does this periodically? Either through a tool
> > or via a command line script or s
On Wed, 2006-10-04 at 10:20 -0500, Dan Buettner wrote:
> You should check out
> http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-introduction.html
Yes. I've tried that. It works Great. (well, the only issue was I had to
change the structure of a few tables, but other than that
Robert, I can't remember which version you said you were on, but the
last few updates to the 5.0.x series have fixed some optimizer bugs.
You might check the functionality in the latest release (5.0.25).
See http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html
for the list of 5.0 changes.
Of p
> Is there a tool available which can be used to transfer (periodically)
> between a MSSQL server and that of a MySQL Server?
> Is there anyone here who does this periodically? Either through a tool
> or via a command line script or something?
>
> Would appreciate any feedback or suggestions.
Yo
I'm trying to delete all but the newest n records.
DELETE FROM tablename ORDER BY creation DESC LIMIT=n
This does the opposite of what I want. Is there some way to tell it
to start the delete after n and delete all the remaining records?
--
MySQL General Mailing List
For list archives: http:
You should check out
http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-introduction.html
Dan
On 10/4/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
Hi,
Is there a tool available which can be used to transfer (periodically)
between a MSSQL server and that of a MySQL Server?
Is t
Anyone here know enough about how the optimizer works to explain why it is use
the "less optimal" index in this case?
-Original Message-
From: Christian Hammers [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 03, 2006 2:54 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Gl
Hi,
Is there a tool available which can be used to transfer (periodically)
between a MSSQL server and that of a MySQL Server?
Is there anyone here who does this periodically? Either through a tool
or via a command line script or something?
Would appreciate any feedback or suggestions.
Thanks
-
Hi All,
This is the first Beta release of the PrimeBase XT storage engine for
MySQL.
The new version includes:
- Integration into the MySQL 4.1.21 build.
- A pluggable storage engine for MySQL 5.1.
Downloads, release notes and other information is available from:
http://www.primebase.com
Hi,
I'm including your post to the forum as well.
The problem I think is the fact that you need to
do LEFT JOIN in two directions which quite often
don't turn out what you want.
So what you can do is to do two queries, UNION
them together and form a derived table that you
then do your final SELECT
hey thx for the reply..
here's my query..
http://forums.mysql.com/read.php?20,119150,119150#msg-119150
thx.
yashesh bhatia.
On 10/4/06, Rob Desbois <[EMAIL PROTECTED]> wrote:
Yes, ask away :)
> Hi,
Is the the right group to post for questions with SQL Queries ?
thx.
yashesh bhatia
--
Yes, ask away :)
> Hi,
Is the the right group to post for questions with SQL Queries ?
thx.
yashesh bhatia
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
_
Hi,
Is the the right group to post for questions with SQL Queries ?
thx.
yashesh bhatia
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> how many is too many?
>
> i have a field with 21 possible values. each of the values are only 2 or 3
> letter strings, but that seems like a lot, would it be faster/more
efficient
> to put them in a separate table and just join?
What would you put in the separate table then? Just these 2-3 let
I think so...
""Tanner Postert"" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
> how many is too many?
>
> i have a field with 21 possible values. each of the values are only 2 or 3
> letter strings, but that seems like a lot, would it be faster/more
> efficient
> to put them i
You can only specify one IP address to bind to.
If you omit this option, mysqld will bind to all addresses on the
machine. If this is not what you want, you could block mysql-access with
a packet filter for the IP addresses you do not want to bind to.
--
MySQL General Mailing List
For list a
What you are asking for is exactly what DEFINER security does. The
applicxation owner grants appuser the right to execute the procedure,
but not to SELECT from any tables. The procedure is then run with the
security attributes of the definer of the procedure, the application
owner, even though
Dan,
I do need to prevent writes from occurring between the DROP and CREATE.
The primary purpose of this is to prevent the CREATE from failing due to
duplicate entries being found during key creation.
As CREATE INDEX has no IGNORE option, I had thought I would have to do this a
nasty way, but it
32 matches
Mail list logo
