I always use stored procedure when I meet such demand.
On Jan 3, 2008 11:09 PM, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Jan 3, 2008 9:28 AM, GF <[EMAIL PROTECTED]> wrote:
> > I need to create a view, about a ranking.
> > The select from which I generate the view has a "ORDER BY" a
learnt.
On Jan 4, 2008 10:15 AM, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
> Martin,
>
> I took a quick look at the tools that you mentioned. Seems you are
> heavily involved in Java :)
>
> We don't use Java at all, and other than using cron (which I do use for
> backups and standard stuff like
The script mysql_install_db will initilize all the data in database mysql.
So the user you created losted certaintly.
On Jan 4, 2008 3:10 PM, Chris <[EMAIL PROTECTED]> wrote:
> Krishna Chandra Prajapati wrote:
> > Hi all,
> >
> > Mysql on debian operating system has debian-sys-maint user. What is
cene.com
>
> Pricing information available on:
> http://www.upscene.com/purchase.htm#adg
>
> More information available here:
> http://www.upscene.com/news/20080104.htm
>
>
>
> With regards,
>
> Martijn Tonies
> Upscene Productions - Database Tools for Developers
&
But why I have not found this parameter in my version.
Something is like this:
mysql> show variables like '%innodb_buffer%';
+-+---+
| Variable_name | Value |
+-+---+
| innodb_buffer_pool_size | 268435456 |
+
In my opinion ,I alway use underscore as "f_table" in my appication.
It runs well all the time.
On Jan 5, 2008 6:22 AM, mos <[EMAIL PROTECTED]> wrote:
> At 12:36 PM 1/4/2008, you wrote:
> >Thanks. It doesn't make the programming easier...it's just easier to read
> >the tables!
> >Victor
>
>
> Vic
I've never used this feature before on my application.
On Jan 5, 2008 7:06 AM, Perrin Harkins <[EMAIL PROTECTED]> wrote:
> On Jan 4, 2008 5:51 PM, Eben <[EMAIL PROTECTED]> wrote:
> > The resultset is paginated on the front end using the
> > SQL_CALC_FOUND_ROWS functionality...
>
> Usually a bad i
On Jan 4, 2008 5:51 PM, Eben <[EMAIL PROTECTED]> wrote:
> The resultset is paginated on the front end using the
> SQL_CALC_FOUND_ROWS functionality...
Usually a bad idea:
http://www.mysqlperformanceblog.com/2007/08/28/to-sql_calc_found_rows-or-not-to-sql_calc_found_rows/
- Perrin
--
MySQL Gener
I left something out, the query looks like:
SELECT SQL_CALC_FOUND_ROWS table_1.id,table_2.*
FROM table_2
LEFT JOIN table_1 ON table_2.shared_id = table_1.shared_id
WHERE MATCH table_2.field AGAINST ('value')
AND table_2.current = 1
AND table_2.shared_id IN (SELECT shared_id FROM table_1_view)
LIMI
Hi,
I have a query that has to run on a full text indexed table with many
millions of records. I'm trying to figure out some optimizations for
it. Here's the general query:
SELECT SQL_CALC_FOUND_ROWS table_1.id,table_2.*
FROM table_2
LEFT JOIN table_1 ON table_2.shared_id = table_1.shared_i
At 12:36 PM 1/4/2008, you wrote:
Thanks. It doesn't make the programming easier...it's just easier to read
the tables!
Victor
Victor,
Just use an underscore as in "My_Table" which is quite readable.
Using a "$" is just asking for trouble. Unless you're the type of guy who
likes going i
Thanks. It doesn't make the programming easier...it's just easier to read
the tables!
Victor
On Jan 4, 2008 2:23 PM, Scott Helms <[EMAIL PROTECTED]> wrote:
> Let me ask this another way, what does this gain you that makes it
> worthwhile to make it harder to work with your database in (at least)
On Fri, January 4, 2008 10:07, Victor Subervi wrote:
> Hmm. The idea is to take this open source. I'll eventually switch over to
> Java. I guess there may be some people tempted to write a quick perl
> script,
> as you say, but on the other hand it wouldn't be part of the open source
> package, whi
Hmm. The idea is to take this open source. I'll eventually switch over to
Java. I guess there may be some people tempted to write a quick perl script,
as you say, but on the other hand it wouldn't be part of the open source
package, which will be either all Python or all Java. Your thoughts?
Victor
Question is, will anyone ever have to write a quick utility in perl (or
any language which uses '$' as a delimiter) to support this? Will you
have to explain your tables to anyone else?
On Fri, January 4, 2008 09:15, Victor Subervi wrote:
> LOL! True. I'm a Python guy ;)
>
> On Jan 4, 2008 1:14 PM
LOL! True. I'm a Python guy ;)
On Jan 4, 2008 1:14 PM, Gerald L. Clark <[EMAIL PROTECTED]> wrote:
> Victor Subervi wrote:
> > Hi;
> > I discovered I can use a $ sign in table names:
> > my$table
> > Is this recommended against? It's kind of handy in my app.
> > TIA,
> > Victor
> >
> If you write
Hi,
On Jan 4, 2008 1:04 AM, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> On mysql production server one of the innodb component
> Innodb_buffer_pool_pages_free =1 . Although there are no issue with the
> performance with the server. What should be the optimum value of
> Innod
You should paste all your error messages here.
On Jan 4, 2008 7:29 PM, Vitaliy Okulov <[EMAIL PROTECTED]> wrote:
> You must copy all files from old location, probably /var/lib/mysql to
> /data/mysqldata/.
> Also open your mysql error log file & read it.
>
>
> 2008/1/4, Krishna Chandra Prajapati <
You must copy all files from old location, probably /var/lib/mysql to
/data/mysqldata/.
Also open your mysql error log file & read it.
2008/1/4, Krishna Chandra Prajapati <[EMAIL PROTECTED]>:
>
> Hi All,
>
> I was trying to change the data directory of mysql on debian. I have added
> two thins in
Hi Krishna,
Did you try this option to start mysql
cd mysql-enterprise-gpl-5.0.40-linux-x86_64-glibc23/bin
./mysqld_safe --user=mysql &
On 1/4/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I was trying to change the data directory of mysql on debian. I have added
> tw
rd Edition
- MySQL Edition
More info and a 30-day trial version on www.upscene.com
Pricing information available on:
http://www.upscene.com/purchase.htm#adg
More information available here:
http://www.upscene.com/news/20080104.htm
With regards,
Martijn Tonies
Upscene Productions - Database
21 matches
Mail list logo