I saw an example of creating tables (see below). I
wonder what the primary key (user_name, role_name) in
the table user_roles means? Does it mean that both
user_name and role_name are the primary key of the
user_roles table? How does a table have two primary
keys?
create table users (
user_na
on 1/1/04 9:59 PM, Schulman, Michael wrote:
> That only returns one number.. what we are really looking for is something
> like
>
> SELECT ticker, hour, first(price), last(price) from pricedata group by hour
Well, if you're using MySQL 4.1+, you're in luck. A subquery should help.
SELECT ticker
>> First: select * from table1 order by field1 asc limit 1
>> Last: select * from table1 order by field1 desc limit 1
> That only returns one number.. what we are really looking for is something
And worse: as far as I can tell 3.22.x even if field1 is indexed, ONE
of those queries is going to be
I know this sounds stupid but I'm totally lost.
I've created a MySQL DB whose purpose is to track customers who have not
gotten a newspaper.
I've created all the necessary fields, and have managed to learn how to
add/delete/modify the records in mysqlcc, but what I want is to have a
predesigned for
You should check the error log about why the server didn't start. It should be called
yourhostname.err in your data directory. I think the problem is that you put spaces
around the second equal sign. The first equal sign "set-variable = ..." can be
surrounded by spaces but the second one "...
Hi Mike,
I'm working in a large Data Capture Division of Lason Inc. in India, I
have developed a
Database which is used to report Server Load & Server space utilization
online, I'm designing this layout
with some what critical process.
It's not in millian rows per day, but in thousands... al
As far as I know min(price) and max(price) will return the lowest and higest
price, not the first and last in the group. Again I know first and last
break the paradaigm of SQL's bucket mentality but it is crucial to doing
timeseries analysis. And timeseries aggregation as the query I gave is
try
Is Hour a DateTime? If so, will this work...
SELECT ticker, DATE_FORMAT(Hour,'%H' ), min(price), max(price)
from pricedata
order by DATE_FORMAT(Hour,'%H' )
group by DATE_FORMAT(Hour,'%H' )
- Original Message -
From: "Schulman, Michael" <[EMAIL PROTECTED]>
To: "'Fredrick Bartlett'" <[EMA
That only returns one number.. what we are really looking for is something
like
SELECT ticker, hour, first(price), last(price) from pricedata group by hour
Sorry for the confusion.
Thanks,
Mike
-Original Message-
From: Fredrick Bartlett [mailto:[EMAIL PROTECTED]
Sent: Thursday
Hmmm...
First: select * from table1 order by field1 asc limit 1
Last: select * from table1 order by field1 desc limit 1
- Original Message -
From: "Schulman, Michael" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 01, 2004 6:47 PM
Subject: Time series
> Hi,
>
> I w
Hi,
I work for a large financial instituition. We are currently evaluating
databases to store intraday stock data. These are large tables with 40
million rows per day. We've done some initial testing with MySQL and have
been extremely impressed with its speed and ease of use. I know that it
go
Hi Chris,
You're fine with mysql_real_escape_string(). % or _ only need to be
escaped if you're using them in LIKE and want them to match
iterally. -- never needs to be escaped in a string.
BTW, if you're using PHP and the stupid magic_quotes_gpc is on, you
don't want to escape stuff yourself a
Hi Bob,
I did. So it should be assumed he's using 4.1.1 or 5.0? That's pretty
stupid. What % of people do you think are using those versions? 1%?
0.1%? 0.01%?
I think most people want the most compatible code/syntax/functions if
they accomplish the same thing. If you want things to be porta
* Gohaku
> I was just curious if there's a shorthand way of replicating a Table
> Schema.
> I use the following to create a new Table with the same schema.
> >create table new_table ( select * from table);
> >delete from new_table;
You can avoid the DELETE by specifying a non-true WHERE clause:
Dear friends,
What version of zesdbo is more faster, 5.5 or 6.1.2?
.NET Plataform is a future you believe in this new plataform?
Regards.
Carlos J Souza
>From Brazil
--
<>
Matt,
Good point, although he didn't specify what version he
was using so I assumed a newer one. Perhaps a
disclaimer should have been included? Anyways,
Kenneth, if you're using an older version try this:
SELECT id, TO_DAYS(firstdate) - TO_DAYS(postdate) AS
diff FROM calendar
Dan
-Original
On Thu, Jan 01, 2004 at 05:42:59PM -0500, Gohaku wrote:
> Hi everyone,
> I was just curious if there's a shorthand way of replicating a Table
> Schema.
> I use the following to create a new Table with the same schema.
> >create table new_table ( select * from table);
> >delete from new_table;
CRE
Hi everyone,
I was just curious if there's a shorthand way of replicating a Table
Schema.
I use the following to create a new Table with the same schema.
>create table new_table ( select * from table);
>delete from new_table;
Thanks in advance,
-gohaku
--
MySQL General Mailing List
For list archi
Dan,
DATEDIFF() only works in MySQL 4.1.1+.
RTFM! ;-)
Matt
- Original Message -
From: <[EMAIL PROTECTED]>
Sent: Wednesday, December 31, 2003 2:10 PM
Subject: RE: Subtracting date fields
> Kenneth,
>
> try
>
> SELECT id, DATEDIFF(firstdate, postdate) AS diff FROM
> calendar
>
>
> -Message d'origine-
> De : Amer Neely [mailto:[EMAIL PROTECTED]
> Envoyé : Thursday, January 01, 2004 3:07 PM
> À : Larry Brown
> Cc : MySQL List
> Objet : Re: Remote access FROM a secure server
>
>
> Larry Brown wrote:
> > Have you tried to telnet to port 3306 on the server from
> y
Larry Brown wrote:
Have you tried to telnet to port 3306 on the server from your local machine
to the foreign server? It should give you some feedback as to why your
connection is refused. If it times out, the server probably had 3306
blocked. I've not used remote servers other than inside a sec
Have you tried to telnet to port 3306 on the server from your local machine
to the foreign server? It should give you some feedback as to why your
connection is refused. If it times out, the server probably had 3306
blocked. I've not used remote servers other than inside a secure facility
so I h
I have a Perl script running on a secure server (https) and am trying to
access the mysql server on a different (unsecure) server. My ISP
administrator has done the following:
GRANT ALL ON database_name.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'
Then he restarted the server. But I'm still
I second Ugo's opinion.
dan
Ugo Bellavance wrote:
-Message d'origine-
De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
Envoyé : Thursday, January 01, 2004 12:16 PM
À : '[EMAIL PROTECTED]'
Objet : RE: Installation Question
Dan:
Thank you fast reply on New Year Day.
The only reason I w
> -Message d'origine-
> De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
> Envoyé : Thursday, January 01, 2004 12:16 PM
> À : '[EMAIL PROTECTED]'
> Objet : RE: Installation Question
>
>
>
> Dan:
>
> Thank you fast reply on New Year Day.
>
> The only reason I was trying to install the so
Dan:
Thank you fast reply on New Year Day.
The only reason I was trying to install the source distribution because it
is supposed to be optimized!!
Is binary distribution is also optimized or it makes no difference? I
personally prefer binary myself. I will wait for a response before I start
al
I am trying to install MySQL from source distribution by following the
instructions under section: 2.3.1 Quick Source Installation Overview.
I notice that the configure state is listed as follows:
shell> ./configure --prefix=/usr/local/mysql
which means to install the software in /usr/local/mys
Hi Asif,
Asif Iqbal wrote:
I have been pushing my syslogs to the following mysql table
However whenever it sees lines with a ' (apostrophe) it complains about SQL syntax
You need to escape those reserved characters, i.e. have ' replaced by \'
because otherwise mysql will treat the apostrophe as
Hi Carlos,
I tested zeos in my application and 6.1 seems to be faster, and much
more simple.
Happy new year
> From Brazil too ;)
-
Luciano Barcaro
Depto. Informática - Laboratório Alvaro
Carlos J Souza wrote:
Dear friends,
What version of zesdbo is more faster, 5.5 or 6.1.2?
.NET Plataform
Hi All
I have been pushing my syslogs to the following mysql table
However whenever it sees lines with a ' (apostrophe) it complains about SQL syntax
Here are two lines with ' from my syslog:
Jan 1 03:58:15 dal-svcs-02.inet.qwest.net 203: *Jan 1 08:58:13.926
UTC: %PFINIT-SP-5-CONFIG_SYNC: Syn
Dear friends,
What version of zesdbo is more faster, 5.5 or 6.1.2?
.NET Plataform is a future you believe in this new plataform?
Regards.
Carlos J Souza
>From Brazil
--
<>
I asked about a week ago how to get mySQL to index correctly in Hebrew, and
the best answer that I received was to define a my.cnf file as follows
[mysqld]
set-variable = default-character-set = hebrew
I created the file /etc/my.cnf using the root account, stopped the mysql
daemon then restarted.
Happy New Year!!!
What's the command for dropping multiple tables?
Example:
12 tables that all start with:
phpbb_
What? Well, the install isn't going as planned. I am having to
reinstall as I try to work out script path (I think) or some other piece
of info that isn't entered correctly, yet.
33 matches
Mail list logo