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
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
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
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 in a
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 letter
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]
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]
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
--
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
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:
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
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:
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
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:
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.
Yoy
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
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
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
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
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
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
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,
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
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
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
/*
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: 041
error4
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
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 question but think that you're
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
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
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
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
32 matches
Mail list logo