> On Jan 30, 2008 12:50 PM, Dmitry E. Oboukhov wrote:
> > Is it possible to add to the syntax of the INSERT operator appoximately
> > in such way:
> > SELECT list INSERT [IGNORE] INTO ... - an added one.
> > SELECT list UPDATE - an added one.
>
> > PS: I understand that adding the changes i
On Jan 30, 2008 12:50 PM, Dmitry E. Oboukhov wrote:
> Is it possible to add to the syntax of the INSERT operator appoximately
> in such way:
> SELECT list INSERT [IGNORE] INTO ... - an added one.
> SELECT list UPDATE - an added one.
> PS: I understand that adding the changes into a language i
Hi!
I use mysql on amateurish level mainly for personal needs and so please
forgive me if this feature request is impossible to fulfil or if it is
sent to the wrong mail-list, or if this functionality has been already
realized in other ways :)
Note: I've read the discription of C-fun
> Daevid Vincent wrote:
> [snip]
> > Also, it would be great if mysql client was "smart" enough
> to limit my
> > tab completion choices to possibilities based upon the
> current SQL query
> > I'm crafting. So If I have:
> >
> > "select t[TAB] from ResolveTable join Tickets;"
> >
> > It shoul
Hi,
Daevid Vincent wrote:
[snip]
Also, it would be great if mysql client was "smart" enough to limit my
tab completion choices to possibilities based upon the current SQL query
I'm crafting. So If I have:
"select t[TAB] from ResolveTable join Tickets;"
It should only show me columns that sta
Is there a way to get the full table.column always in mysql client when
using the auto-tab completion feature? I'm currently using 5.0.36.
The way it works now is a bit confusing. Notice I have TWO different
"DateOnly" columns (for example) in two different tables. [middle
column]
mysql> select
Would like to see this, there is a TMD temp table created during an optimize
is there any reason read only access cant take place during the optimize
process? Update/delete/insert shouldn't, but read access should be
allowed on myisam
any thoughts on this?
--
MySQL General Mailing List
Fo
Sheeri,
- Original Message -
From: ""sheeri kritzer"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 28, 2006 9:29 PM
Subject: problems/feature request ideas
2 weeks ago we had a server crashing, and while I was checking it out
2 weeks ago we had a server crashing, and while I was checking it out
(before, during and after crashes) I noticed that after a crash, the
server was slow. Threads would run for 200 seconds or more, and yet
when they finished, nothing was written to the slow query log.
Why would that be? Slow qu
Hi:
I am using mysql 4.1.10 for a while now, and i was wondering how
painful it would be to tweak the mysqldump to support an additional
option, --insert-ignore , which instructs it to create the dump files
with
INSERT IGNORE blah blah
instead of just
INSERT blah blah
i have actually modified
Hello.
You can solve your problem using --all command line option
(--create-options after 4.1.2) which is on by default as of
MySQL 4.1.
Chris Elsworth <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a feature request for mysqldump that would greatly ease a
> c
Hello,
I have a feature request for mysqldump that would greatly ease a
current task I have; in my replicated setup my master is currently
MyISAM (as are most slaves), but I have one slave that is InnoDB for
testing.
Somehow or other, it's gotten itself out of sync, so I'm in the
p
I'm not sure of the right way to submit these things, so I'll do it here...
I want to dump some data form the binlogs and process it back into the
servers. However I just want to process the data from one specific server.
In mysqlbindump I can optionally specifiy a specific database for the
inform
At 12:38 -0700 on 05/27/2004, Daevid Vincent wrote about Re: Feature
Request: UPDATE 'error codes' or mysql_affected:
REPLACE INTO won't work, as I need the previous record (hence the update). I
store the first and last time I saw a node, amongst other info. REPLACE
would d
Daevid Vincent wrote:
Well, my "hack" (which is sort of like what you suggest) is to change my
primary key from just an auto_increment 'id' field to a combination of two
other fields (mac/scanner_id) that I know must be unique. Then I rely upon
the fact that mySQL will not allow a duplicate PK. (I
PLACE
would delete that data.
http://daevid.com
> -Original Message-
> From: Steve Meyers [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 27, 2004 7:42 AM
> To: Daevid Vincent
> Cc: [EMAIL PROTECTED]
> Subject: Re: Feature Request: UPDATE 'error codes' or
> mysql_a
http://dev.mysql.com/doc/mysql/en/INSERT.html
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES ({expr | DEFAULT},...),(...),...
[ ON DUPLICATE KEY UPDATE col_name=expr, ... ]
If you specify the ON DUPLICATE
Does REPLACE INTO not work in your case?
|
|
|REPLACE| works exactly like |INSERT|, except that if an old record
in the table has the same value as a new record for a |PRIMARY KEY|
or a |UNIQUE| index, the old record is deleted before the new record
is inserted. See section 14.1.4 |INSE
I'm developing a program where I try an "UPDATE ... LIMIT 1" and if
mysql_affected_rows == 0, then I know nothing was updated and so I do an
INSERT. I find this is much cleaner and the majority of the time, I'm going
to do UPDATES, so I didn't want to waste a SELECT (even though I hear
they're "che
> Here is the background: Anyone that is running a huge system like MARC
> that has millions of uncompressed blob records in huge tables, needs to be
> able to migrate, in real-time and without down-time, to compressed blobs.
> Therefore, we need a way to know if a given field is compressed or not
Hi!
On Feb 27, Lester Hightower wrote:
> To whom it may concern at Mysql AB:
>
> I see from the Mysql 4.1.1 CHANGELOG that new COMPRESS(), UNCOMPRESS(),
> and UNCOMPRESSED_LENGTH() functions were added. That is great news, and
> something I have been very interested in for a long time, as eviden
To whom it may concern at Mysql AB:
I see from the Mysql 4.1.1 CHANGELOG that new COMPRESS(), UNCOMPRESS(),
and UNCOMPRESSED_LENGTH() functions were added. That is great news, and
something I have been very interested in for a long time, as evidenced by
this mysql mailing list thread, dating back
Hi,
I rely on max_questions to balance the load on my servers. I'd like to
tune them more effectively than just a ballpark guess.
During the course of an hour (the question count resets each hour) is it
possible to retrieve the question count for a particular user? Obviously
it must b
I'd like to be able to look at show innodb status, notice that a query
is waiting on a lock to be released, and then determine which tx is
holding that lock.
I know you can use the innodb_lock_monitor table, but this would make
things a lot faster especially when there are a lot of active
transac
At 12:20 +1000 7/23/03, Daniel Kasak wrote:
Paul DuBois wrote:
At 10:46 +1000 7/23/03, Daniel Kasak wrote:
Hi all.
I need to test whether the first bit of a field is numeric.
For example, the field might contain:
154 boxes
Define this more precisely. Is an acceptable match one or more
digits
uld return true, as the abs('3a5') would equate to 3. But
it's good enough for now.
Is there a simpler / better way of doing it? I can't find any
reference to a function like isnumeric().
Feature request? It would be handy. It would also add to
compatibility with other DB serv
Paul DuBois wrote:
At 10:46 +1000 7/23/03, Daniel Kasak wrote:
Hi all.
I need to test whether the first bit of a field is numeric.
For example, the field might contain:
154 boxes
Define this more precisely. Is an acceptable match one or more
digits followed by a space? If so, field REGEXP '^
o work.
Well it kinda works. If 'field' has '3a5 boxes' in it, the above
function would return true, as the abs('3a5') would equate to 3. But
it's good enough for now.
Is there a simpler / better way of doing it? I can't find any reference
to a funct
Perhaps TIMESTAMP will provide what you need.
Daevid Vincent wrote:
http://www.mysql.com/doc/en/CREATE_TABLE.html states "Default values must be
constants. This means, for example, that you cannot set the default for a
date column to be the value of a function such as NOW() or CURRENT_DATE."
Is t
At 17:56 -0800 3/5/03, Daevid Vincent wrote:
http://www.mysql.com/doc/en/CREATE_TABLE.html states "Default values must be
constants. This means, for example, that you cannot set the default for a
date column to be the value of a function such as NOW() or CURRENT_DATE."
Is this ever going to be "fix
http://www.mysql.com/doc/en/CREATE_TABLE.html states "Default values must be
constants. This means, for example, that you cannot set the default for a
date column to be the value of a function such as NOW() or CURRENT_DATE."
Is this ever going to be "fixed"? I often find myself using this when
cre
How about this:
mysql> CREATE TABLE tablename (value1 int(10) AUTO_INCREMENT, value2 timestamp(14),
PRIMARY KEY (value1));
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT SQL_RETURN_INSERT_ID INTO tablename (value1, value2) VALUES (0, NOW());
+-+
| INSERT_ID() |
+-+
|
Hello!
Is it feasible to enable storing multiple values into one variable?
(that would then be an array)
For example:
@a := (SELECT idref FROM tableB);
(... some commands ...)
SELECT id FROM tableA WHERE id IN @a;
Or will mysql support something like cursors?
--
Christian Kohlschütter
[EMAIL PR
YMMV! Just a note
> on how FTS can really read a lot of data and how moving it can really
> clear things up. Which brings me to:
>
> EXPLAIN feature request: to have EXPLAIN RESOURCES SELECT or something
> similar to be able to show resource usage instead of query/index plan
me to:
EXPLAIN feature request: to have EXPLAIN RESOURCES SELECT or something
similar to be able to show resource usage instead of query/index plan.
Resources like CPU, disk read, and disk write. Likely it should not
actually be EXPLAIN, since it would do the operation (where explain does
not). So maybe S
Benjamin Pflugmann wrote:
> On Sat 2002-08-24 at 19:21:56 -0400, [EMAIL PROTECTED] wrote:
> > On Sat, 2002-08-24 at 18:38, Van wrote:
>
> > > Just thought I'd pass it along, since I haven't seen Monty and
> > > crew address it.
>
> I think that it is a non-issue and that this already has been c
Hello.
(This is more an additional answer to the original mail than to the
one I replied to).
On Sat 2002-08-24 at 19:21:56 -0400, [EMAIL PROTECTED] wrote:
> On Sat, 2002-08-24 at 18:38, Van wrote:
> > Just thought I'd pass it along, since I haven't seen Monty and
> > crew address it.
I think
Hi!
> "Daniel" == Daniel Kasak <[EMAIL PROTECTED]> writes:
Daniel> Would it be possible to add a 'drop table' command when a connection
Daniel> which has made a temporary table has been dropped, to make the logs
Daniel> match up with what actually happens? Thanks!
The later MySQL 3.23
Hi all.
Hello spam filter! sql. query.
I had to restore from a backup and run through part of the day's
transactions from the --log-update option ... I had accidentally deleted
2500 records, and wanted to replay the logs minus that one delete
command :-)
One problem which I encountered was tha
nd upgrade to the latest release of
phpMyAdmin that I released earlier this evening. We support comment fields
for columns ourselves now after we saw a feature request for it.
--
Robin Hugh Johnson
E-Mail : [EMAIL PROTECTED]
Home Page : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ#
Hi mysql users, mysql developers!
I have just started using mysql for a database project and I wonder that one
function is missing. I am using myphpadmin as utility. It is possible to
write a comment to each table, but it is not possible to write a comment to each
field. Why not? I think this wou
Hello,
I think that MAX_SLOW_QUERY_PER_HOURS is useful options for
GRANT ... WITH MAX_QUERIES_PER_HOUR = N1
MAX_UPDATES_PER_HOUR = N2
MAX_CONNECTIONS_PER_HOUR = N3;
statment.
Thank.
Best regards,
Andrew Sitnikov
e-mail :
Hello,
I think that MAX_SLOW_QUERY_PER_HOURS is useful options for
GRANT ... WITH MAX_QUERIES_PER_HOUR = N1
MAX_UPDATES_PER_HOUR = N2
MAX_CONNECTIONS_PER_HOUR = N3;
statment.
Thank.
Best regards,
Andrew Sitnikov
e-mail :
Ken Menzel writes:
> Hi Guys,
>I would like to request an additional feature with EXPLAIN.
> EXPLAIN does not run the query guesses on how the query would be run.
> This is not always accurate. The slow-log however logs the actual
> information the query was run with (like explain only the tru
Hi Guys,
I would like to request an additional feature with EXPLAIN.
EXPLAIN does not run the query guesses on how the query would be run.
This is not always accurate. The slow-log however logs the actual
information the query was run with (like explain only the truth!).
Could we have an option
It would be nice to have an option for mysqldump to put the building of
indexes after the insert statements to speed up loading.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
Hi!
On Dec 12, Colin Faber wrote:
> Hi,
>
> I've got a feature request which I don't think should be all that hard
> to implement (if not already)
>
> With in the mysql fulltext search system if your search words exist in
> more than 50% of the records; it is
Hi.
MySQL already reserves one connection to users with the process
privilege. So assure that common clients don't have the process
privilege and you connect with one that has it and you are done.
This is documented here (found no other place):
http://www.mysql.com/doc/T/o/Too_many_connections.h
Hi,
I've got a feature request which I don't think should be all that hard
to implement (if not already)
With in the mysql fulltext search system if your search words exist in
more than 50% of the records; it is ignored.
How about having mysql return either an error or set somethin
Hi,
I'd like to be able to reserve some connections to the MySQL
server for emergencies - eg. someone issued a slow query and locked out
several hundred updates from several hundred other connections.
Currently in this sort of situation, it is possible to completely
run out of connections and
Hello,
I don't know if this is the right mailing list for a simple feature
request, but please read on anyway.
SKIP TO THE END IF YOU JUST WANT TO READ THE FEATURE REQUEST.
As a Java programmer, I often access a MySQL database trough a driver, and
notice a little problem:
The MySQL forma
Hello mysql,
Resently MYSQL have introduced transaction support, which at least
in INNODB allows to make consistent backup/recovery. The bad thing
about this is - MYSQLDUMP does not support anything about this, so I
had to done the same things buy hands.
The Idea is quite simple - to
Greetings:
I haven't seen any discussions on reducing the duration of a network connection
on port 3306 after issuing a mysql_close, so it makes sense to inquire whether
anyone has addressed this.
The code follows:
// main.c
#include
if ((conn = do_connect (BTIME_HOST, USER, BTIME_PW, BTIME_DB,
Hi,
it would be nice to have a replicate-ignore-table for the Master also!
It works fine, but if one has to replicate only certain tables of a db
it would be good to have this.
It is not enough to have this on slave only, because we do not want to
send the data of whole databases across the n
Hi!
> "Basil" == Basil Hussain <[EMAIL PROTECTED]> writes:
Basil> Hi,
>> I am BEGGING you to please make the describe command OPTIONALLY display the
>> Privileges column. Before 3.23, I was able to see the describes properly. Now
>> the command is almost totally useless to me!
Basil> I agr
Hi,
> I am BEGGING you to please make the describe command OPTIONALLY display the
> Privileges column. Before 3.23, I was able to see the describes properly. Now
> the command is almost totally useless to me!
I agree! On any table you care to describe the output is usually always
wider than even
I am BEGGING you to please make the describe command OPTIONALLY display the Privileges
column. Before 3.23, I was able to see the describes properly. Now the command is
almost totally useless to me!
Aaron
-
Before posting, pl
57 matches
Mail list logo
