2008/10/31 Moon's Father <[EMAIL PROTECTED]>
> *A prepared statement is also global to the connection. If you create a
> prepared statement within a stored routine, it is not deallocated when the
> stored routine ends. *
>
> Then I don't know how to deallocate the memory used by prepare statement
2008/10/21 Moon's Father <[EMAIL PROTECTED]>:
> Could you please give me an idea of how to manage the privileges inside
> mysql?
http://www.google.co.uk/search?q=mysql+grant
first hit :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
2008/10/17 Reyna.Sabina <[EMAIL PROTECTED]>:
> Hi,
>
> Running Environment:
> MySQL Server version: 5.0.45
> OS is Red-Hat 64-bit
>
> The table 'junk' doesn't have a row with id=4. Two tests to trap 'errors'
> using DELETE follows:
>
Perhaps I'm missing something - but a delete matching no
2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>:
> On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier <[EMAIL PROTECTED]> wrote:
>
>> Okay, I realize that query won't work, but that's essentially want I want
>> to do:
>>
>> Add four months to the current date, then return the first day of that
>> month, e.g
2008/10/17 Brent Baisley <[EMAIL PROTECTED]>:
> Why are you creating a subquery/derived table?
>
> Just change your limit to 1,2
> ORDER BY updates.AcctSessionTime DESC LIMIT 1,2
Because then the maths in the select part isn't executed, and I don't
get the figures I need.
--
MySQL General Maili
2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>:
> *How long does the second query actually take to run compared to first?
Actually, really quickly - so quickly that I also suspected that a
full table scan was not taking place. I'd like to understand how the
output of EXPLAIN can differ from the act
2008/10/16 Krishna Chandra Prajapati <[EMAIL PROTECTED]>:
> I believe that yahoo, google and other companies must be generating reports.
> How they are doing. Any Idea.
This is how google do it: http://en.wikipedia.org/wiki/MapReduce
Have you seen federated tables? Be aware of the performance on
2008/10/17 dave aptiva <[EMAIL PROTECTED]>:
>
> I tried SELECT ID_number, max( count( CU_number ) ) but this causes an error
> "# - Invalid use of group function "
# sqlite3
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> create table moo (id_number, cu_number);
sqlite> insert int
Hi all,
I'm trying to work out the difference in a field between the last 2
updates in an updates table. I'm doing this as shown below:
mysql>SELECT
-> (@in - AcctInputOctets) AS AcctInputOctets,
-> (@out - AcctOutputOctets) AS AcctOutputOctets,
-> (@in := AcctInp