I've got a huge table going, and it's storing a load of numeric data.
Basically, a percentage or single digit rank, one or two digits before
the decimal and fifteen after, like this:
6.984789027653891
39.484789039053891
What is the most efficient way to store these values? I will be
frequently
On Thu, 20 Jun 2002, Flavio Reis wrote:
> Hi Galen!
> The problem is that command act on client, I need a command to act on server
> (mysqld)!
> Thanks
> []s
> Flavio
>
select_limit is a client variable, not a server variable. A second look at the
documentation suggests
On Thu, 20 Jun 2002, Flavio Reis wrote:
> Hi.
> I have an urgent question:
> How can I set the variable sql_select_limit as a global variable, which
> everytime that I open the MySQL it's set to the value that I determinated. I
> want to know how set this variable in the mysql.conf (where and h
On Thu, 20 Jun 2002, Seth Yount wrote:
> Hello experts
I'm glad you think so highly of us.
>
>I am trying to decide which would be the most efficient way of
> retrieving data, Subselects (nested queries?) or Temporary Tables?
>
> Does MySQL even support these yet?
MySQL supports tempo
On Thu, 20 Jun 2002, Javier Campoamor wrote:
> Hi,
>
> I have a problem with the next query because it's too slow (>10 seconds) and
> I need to do 10 queries like this one to show a page.
>
>
>
> SELECT
> h.Hour, count(c.Amount) As NumberOfCalls, sum(c.Amount) As Amount
>
On Wed, 19 Jun 2002, Silmara Cristina Basso wrote:
> I'm newbie MySQL and I'm using MySQL-max 4.0.1(Innodb), with one application
> developed in Delphi and connect through MyODBC. The question is ...
> How can i do to lock one row so that it is editing in the application?
>
>
The impression I g
On Tue, 18 Jun 2002, Brad W. Galiette wrote:
> I am currently in the process of designing a database solution that requires
> columns to have array-like capabilities. To provide the group with a better
> notion of what I am trying to accomplish, please review the following
> example.
>
As far a
On Sun, 16 Jun 2002 [EMAIL PROTECTED] wrote:
> Hi,
>
> I tried something like the following (MySQL 3.23.36 on RH7.1) and got
> the error indicated below.
>
> create table product ( /* The main table -- see below... */
> id int not null auto_increment,/* some text here */
>
On Fri, 14 Jun 2002, Sergey wrote:
> With root privileges
> I doing:
> GRANT ALL ON mydb.* TO client@localhost identified by "pwd";
> I got:
> OK
>
>
> Then I doing:
> LOAD DATA INFILE "/usr/data/myfile" INTO TABLE tab01;
> I got:
> ERROR 1045 Access denied fot user: 'client@localhost' (Using
On Fri, 14 Jun 2002, [GB2312] ³Â׿ wrote:
> mysqlmysql 3.23.41
> phpMyAdmin 2.2.3
> os :Linux server 2.4.9-31
>
> In order to remove the first character '0' of the field 'number',
> I want to use the following sql query to select the field from my database.
>
> select right(number,
>if(locate(
On Tue, 11 Jun 2002, Trevor Phillips wrote:
> Date: Tue, 11 Jun 2002 13:27:53 +0800
> From: Trevor Phillips <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Problem with Escaping quotes
>
> I'm writing some routines which generate SQL queries, and I'm trying to
> keep things generic. As su
11 matches
Mail list logo