Thanks.
I see what you mean. I used the 'Evaluate' as an example because in some
code you can use that function to execute a text string as code. I sort
of thought there may be something similar in SQL / MySQL to allow the
execution of a resultant string as if it were code.
And yeah a lot of
Ed,
what does
gcc --version
say? I am able to compile with gcc-3.3.1.
in ut0dbg.h we have:
#if defined(__GNUC__) && (__GNUC__ > 2)
# define UT_DBG_FAIL(EXPR) UNIV_UNLIKELY(!((ulint)(EXPR)))
#else
extern ulintut_dbg_zero; /* This is used to eliminate
compiler
Hi,
i've got a problem with my server because some times per day, something occurs
and server load average grows until 20 due to mysql. When it occurs, with "show
processlist", I can see a lot of queued queries in "locked" state ( more than
100 queued).
You can see the load average at http://clu
See comments interspersed below.
Rhino
- Original Message -
From: "Duncan Miller" <[EMAIL PROTECTED]>
To:
Sent: Sunday, November 06, 2005 8:36 PM
Subject: Evaluating text as an expression
> I am trying to set up a table where the returned value is a result of
> evaluating an expression
Mike,
the opinions below are my personal opinions. They do not reflect the
official standpoint of Oracle Corporation.
- Original Message -
From: "mos" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, November 07, 2005 12:51 AM
Subject: Re: Heikki: What will becom
On Nov 6, 2005, at 6:05 PM, Jeremy Cole wrote:
Jeremy Cole
MySQL Geek, Yahoo! Inc.
Desk: 408 349 5104
Yahoo employs MySQL geeks? Always wondered what db that big index
runs on... :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
John Taylor-Johnston wrote:
Which version? Which export type? Strings TEXT, VARCHAR would be
quoted. INT would not, I think.
Their forum might be a better place. www.phpmyadmin.net.
I am using phpMyAdmin 2.6.1-rc. I have no control over that as I am not
the admin on the server. All the colu
On Sun, 2005-11-06 at 16:45 -0600, mos wrote:
> If this happens, what alternative will MySQL be offering their users who
> need transactions and RI?
The GPLed version of InnoDB?
--
Jasper Bryant-Greene
General Manager
Album Limited
e: [EMAIL PROTECTED]
w: http://www.album.co.nz/
b: http://jbg.
Hi Brian,
I'd like to delete all but the newest 100 records from a table. I have
a timestamp field. I can't figure out how to do this in a single SQL
statement - can anyone help? Thanks!
This should work:
DELETE FROM tbl ORDER BY ts DESC LIMIT 100, 99;
Note that ORDER BY and LIMIT are
The problem is the most recent 100 records won't be sequential. There
are records with many different identifiers, in random order mixed
with other records that I don't want deleted, and each time I do this
I'm going to be limiting each subset of identified records to only
the most recent 1
I am trying to set up a table where the returned value is a result of
evaluating an expression that is stored as text (or varchar).
The idea is to have a table with a couple of fields that can contain
numeric values or expressions eg
NameFred
Years 3
Commission base 10%
Commissi
Which version? Which export type? Strings TEXT, VARCHAR would be quoted.
INT would not, I think.
Their forum might be a better place. www.phpmyadmin.net.
2wsxdr5 wrote:
I just tried to use the output of the export function on phpmyadmin and
got a million errors. After looking at the file I fo
Marcus Bointon <[EMAIL PROTECTED]> wrote on 11/06/2005 05:53:50
PM:
> I'm generating data to use for a php graph-drawing utility where I
> summarise data into daily counts of events relating to an 'issue'
> item from an 'event' table via a 'session' table. My queries are
> currently along thes
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
Consider about switching to per-table tablespace:
http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html
> have an ibdata file that is growing and growing and growing
>Are ther
I'm generating data to use for a php graph-drawing utility where I
summarise data into daily counts of events relating to an 'issue'
item from an 'event' table via a 'session' table. My queries are
currently along these lines:
SELECT DATE_FORMAT(event.timestamp, '%Y-%m-%d') AS adate, COUNT
At 08:59 PM 11/4/2005, you wrote:
At 21:49 -0500 11/4/05, Ezra Taylor wrote:
Last one people:
I just realized that Heikki is
monitoring our post pertaining to innodb. This guy/gal is an oracle
employee. The enemy is amongst us. Beware. Haha Haha
Ezra
Ezra,
Y
At 08:33 PM 11/4/2005, you wrote:
Mike,
- Original Message - From: "mos" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, November 05, 2005 12:11 AM
Subject: Heikki: What will become of InnoDb once MySQL license runs out
Heikki,
I am about to start a large MySQL
On 5 Nov 2005, at 03:47, Ezra Taylor wrote:
They will crush anyone that gets in there way.
Well, if recent events are any indication, Oracle's approach to
'crushing' the opposition is to give them very large amounts of
money. If that's being crushed, I'm up for it.
Marcus
--
Marcus Boint
Hello,
I am moving my first steps with stored procedures in Mysql and I was
trying to write a stored procedure
using a tablename given as a variable. In this example the local
variable m_sequence has the value of the
table I want to use.
CREATE PROCEDURE p_new_id (IN tablename VARCHAR(128), O
I have an ibdata file that is growing and growing and growing
Are there maintenance routines that I can run to keep this file in check?
My database is performing close to half a million transactions a day and this
file is now well over 75GB. Can I expect this file to continue to grow, until
I am experiencing problems when trying to compile 5.0.15 on RH 7.3. I run
"configure --prefix /usr/local/mysql" with no apparent errors. when I run
make I get the following error:
ha_innodb.o: In function `check_trx_exists(THD *)':
ha_innodb.o(.text+0x30a): undefined reference to `ut_dbg_zero
Ok thank you, I think I have it now. Now to get my Client application
working.
On Nov 6, 2005, at 1:16 PM, Björn Persson wrote:
söndagen den 6 november 2005 18:39 skrev Bruce Martin:
However, even though I specified 'test.*' my test user can access the
mysql database.
That's because this s
Hello.
There are some examples inside the discussion which should work:
http://forums.mysql.com/read.php?98,19146,19496
Scott Hamm wrote:
> I was working on Php web page and attemtped to use stored procedure.=20
> Last night on Php line, they said that I should consider MySQLi and to
söndagen den 6 november 2005 18:39 skrev Bruce Martin:
> However, even though I specified 'test.*' my test user can access the
> mysql database.
That's because this statement:
> UPDATE user SET
> Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_p
> riv='Y' WHERE user.User='t
Ok thank you for your replies. I finally got it working, but as you
stated I granted too many permissions. I found that in the user table
my testUser had N for every column with the exception of the last few
which where 0.
I first logged into the database using:
shell>mysql -u root -p mysq
söndagen den 6 november 2005 16:15 skrev Brian Dunning:
> I'd like to delete all but the newest 100 records from a table. I
> have a timestamp field. I can't figure out how to do this in a single
> SQL statement - can anyone help? Thanks!
I'd try something like this:
delete from x where ID not in
> -Original Message-
> From: Michael Stassen [mailto:[EMAIL PROTECTED]
> Sent: zondag 6 november 2005 6:26
> To: Mark
> Cc: 'Bruce Martin'; mysql@lists.mysql.com
> Subject: Re: Add New User
>
> > Because, afterwards, you forgot to say:
> >
> > FLUSH PRIVILEGES;
> >
> > Perhaps?
> >
> > - Ma
If you have auto_incremnt id in the table you can do the following:
delete from table a where id > start_id and id =< end_id
Or you can delete by timestamp.
delete from table a where date between 'start_date' and 'end_date'.
On 11/6/05, Brian Dunning <[EMAIL PROTECTED]> wrote:
>
> I'd like to d
I'd like to delete all but the newest 100 records from a table. I
have a timestamp field. I can't figure out how to do this in a single
SQL statement - can anyone help? Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
"Bruce Martin" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> When I log in as root using:
> mysql -u root -p mysql
> I get the mysql prompt:
> mysql>
>
> I then issue this command or statement:
>
> mysql>GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED BY
> 'some_password'
Rhino wrote:
I'm glad the explanation helped. I figured that the solution alone wouldn't
be very useful if it wasn't explained since it is not obvious to most people
how correlated queries work :-)
I really wasn't trying to center you out with my "rant" about MySQL version.
It's been a long-run
I just tried to use the output of the export function on phpmyadmin and
got a million errors. After looking at the file I found that certain
columns that are strings were not quoted at all. I can't find any
reason why some are and some are not quoted. Anyone have any idea why
this is happening?
32 matches
Mail list logo
