PAUL MENARD wrote:
Hello All,
I'm having trouble understanding the MySQL docs on how to subtract two DATETIME values. I have two tables that have a DATETIME column. In my SELECT I am doing a JOIN to bring in both sets of rows. What I want is to subtract the DATETIME values to determine the number
I searched on Google and I found this post from 2 years ago:
http://www.phpbuilder.com/mail/php-db/2001082/0212.php
suggesting that the way to do it would be to connect to MySQL as root and
run the command:
grant all on tracerlock.test to bhaselto identified by ""
I tried that, and then did "flus
Hello All,
I'm having trouble understanding the MySQL docs on how to subtract two DATETIME
values. I have two tables that have a DATETIME column. In my SELECT I am doing a JOIN
to bring in both sets of rows. What I want is to subtract the DATETIME values to
determine the number of seconds betw
On Saturday 16 August 2003 8:44, O'K Web Design wrote:
> Hi Mark
>
> I can only tell you about my experience from the Perl side of things.
> The integration to the database is great and the amount of things you can
> do with the data once you get it in the script is the biggest bonus. My
> f
On Saturday 16 August 2003 4:41, Hans van Harten wrote:
> Depending on your exact needs, consider brutal overwrites:
> LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE
>
> Replaces 1 rows within 3.5 s into Innodb running MySQL-max-4.10 and
> WinXP on Celeron /400MHz/ for me.
Is there a nee
At 05:54 PM 8/16/2003 -0400, Rajesh Kumar wrote:
Bennett Haselton wrote:
I'm trying to port my MySQL tables for a database called "tracerlock"
from one server to another. On the old server, in the
/var/lib/mysql/tracerlock directory, there was a ".MYD", ".MYI" and
".frm" file for every table in
I just want to be 100% sure on something...
With an Opteron (or Itanium for that matter) using let's say the RedHat 9 or
AS 3 betas available for those CPUs, how will MySQL/INNODB function?
Specifically does the ability to allocate a bigger chunk of memory than 2GB
just work "out of the box"? Can
Bennett Haselton wrote:
I'm trying to port my MySQL tables for a database called "tracerlock"
from one server to another. On the old server, in the
/var/lib/mysql/tracerlock directory, there was a ".MYD", ".MYI" and
".frm" file for every table in the database. So after creating a
database cal
I'm trying to port my MySQL tables for a database called "tracerlock" from
one server to another. On the old server, in the /var/lib/mysql/tracerlock
directory, there was a ".MYD", ".MYI" and ".frm" file for every table in
the database. So after creating a database called "tracerlock" on the n
Hi Mark
I can only tell you about my experience from the Perl side of things.
The integration to the database is great and the amount of things you can do
with the data once you get it in the script is the biggest bonus. My
feeling is that a combination of the two would probably be the best
Correct me if I'm wrong, but won't this cause it to no longer be a
real-time solution? The machine I'm running MySQL on is fairly
vulnerable to attack (which, for the time being, cannot be
changed...although I have secured it as much as is possible), which is
why I'm logging everything remotely
Trevor,
Why not try simplify it to 2 fields and remove most of the validation
code? If that works, then you can binary add/delete code until it fails.
BTW 'Red' I guess only works on certain mail clients, but not mine, so
sorry if I missed something obvious.
Regards,
Andy.
Trevor Morrison wrote:
John,
I was intrigued with the given solution so I tried this and here's a
version I found to work:
Table x1 has fields uid, uname, pid (parent's id)
select parent.uname, count( child.uname) as ChildCount
from x1 as parent left join x1 as child on ( parent.uID=child.pid)
group by parent.uName o
At 12:17 AM 8/16/2003, you wrote:
As part of my own learning mysql project I'm planning to build
databases for all my books and DVD's. Stephen Hawking is probably
a better typist than I am so I plan to use barcodes to get the info
,taking the information from various web sites.
People tell me that
> As part of my own learning mysql project I'm planning to build
> databases for all my books and DVD's. Stephen Hawking is probably
> a better typist than I am so I plan to use barcodes to get the info
> ,taking the information from various web sites.
>
> People tell me that PHP is THE way to do
Hi,
On Sat, Aug 16, 2003 at 04:29:01AM +0200, albert wrote:
> Now i'm trying to install MySQL 4.0.14 through binary source install.
>
> I'm using Redhat 7.2 and 8.0
>
> I'm trying like this..
>
> ./configure --prefix=/usr/local/mysql \
> --localstatedir=/usr/local/mysql/data \
> --with-chars
Hi
Firstly if your application is well designed then your data should not be accessible
by the wrong users - if you make sure that there is no way the wrong supplier id can
be allocated - put an extra 'are you sure this is correct' check, make it so that the
user id can only be allocated once t
Hi,
I am running the latest MySql on a windows 200 machine. I also use the
control center gui to do all my work with. I have a Perl program that
parses online order data and then using Perl's DBI I write this data to the
database. Now, It all works fine except that each order and orders items
* Karam Chand
> I have a column with double values like -
>
> .01
> .02
> .03
>
> Well...its sounds ridiculous but i do have data like
> that :)
>
> I am using C API to get the resultset, but the data is
> resturned as ( also with mysql client which uses C API
> ).
>
> |1e-006
I learned MySQL last year without putting it into action; that is why
I face trouble in formulating my queries. Were it a test, then you
would have passed it, because your queries did help me solve my problem.
I'll turn to MySQL doc after getting through this pressing project.
Thanks a lot Roge
Dear Friends
I has images saved on an mysql table as an blob field, but i could not
recreate the image as file by selecting an specific record of this field
any ideia
Regards
Luiz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Greetings
I have a column with double values like -
.01
.02
.03
Well...its sounds ridiculous but i do have data like
that :)
I am using C API to get the resultset, but the data is
resturned as ( also with mysql client which uses C API
).
|1e-006 |
|2e-006 |
|3e-006 |
|
Hello,
I am a mySQL newbie here and have some problem defining the mySQL 4.0.14
or 3.23 SQL to get student grade ranking where tied grade have the same
rank.
I used to set it through MS Access 2002 and use this kind of query:
SELECT nilai.studentNIS, nilai.studenttestmark,
(SELECT COUNT(*)
When will 4.1.1 be officially available in a packaged download?
Just curious.
Thx,
Rick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 16, 2003 11:48 AM
Subject: Re: Can I change the date format...
> Karam Chand <[EMAIL PROTECTED]> wrote:
> > Is there anyway to change the default date format
> > (possibly
Hello
I am using SQLyog. I want to manage user permissions
down to a field level which SQLyog does. Any DDL or
DML statements that I attempt to execute within SQLyog
support the defined user permissions.
However, when I use MySQLCC the persmissions are
totally ignored. This is also true when I a
Hi,
It is noted in the MySQL manual that unsigned integers bigger than
9223372036854775807 (63 bits) shouldn't be used itnarithmetic operations
since signed BIGINT/DOUBLE is used in arithmetic functions.
Can we somehow tell MySQL (probably during compilation) to use unsigned
BIGINT/DOUBLE for a
* B. Fongo
> I was able to extra the information from the first 2 tables yesterday
> using following query:
>
> SELECT Customers.Name, Customers.City, Orders.Product,
> Order.Price FROM Customers inner join Orders USING (cust_id) WHERE
> customers.cust_id = "2"
>
> -
Hi All!
Recently I installed mysql on a win98. Some 2 days after the
installation the system started experiencing a problem shutting
down. When shutting down the hard-disk kept spinning sometimes
as
long as 10 minutes.
The same problem was encountered on another win98 computer.
The system is wo
Karam Chand <[EMAIL PROTECTED]> wrote:
> Is there anyway to change the default date format
> (possibly in a .ini or .cfg file) from -MM-DD to
> another format ? (ie, mm/dd/ or any user-defined
> format).
No, You can't.
>
> The useage that I'm looking at is to import a CSV file
> into a t
Hello
Is there anyway to change the default date format
(possibly in a .ini or .cfg file) from -MM-DD to
another format ? (ie, mm/dd/ or any user-defined
format).
The useage that I'm looking at is to import a CSV file
into a table (using Load data infile command)
where dates are stor
Jackson Miller wrote:
> I need to have a web application be able to import large amounts of
> data (400,000 rows of 10 columns). I know how to script it and have
> it running in the background. However I want to know how I can
> optimize my insert statements to try to speed things up.
For extreme
Hello again!
I was able to extra the information from the first 2 tables yesterday
using following query:
SELECT Customers.Name, Customers.City, Orders.Product,
Order.Price FROM Customers inner join Orders USING (cust_id) WHERE
customers.cust_id = "2"
--
Dear,
Now i'm trying to install MySQL 4.0.14 through binary source install.
I'm using Redhat 7.2 and 8.0
I'm trying like this..
./configure --prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--with-charset=big5
make
so far there is no problems.
but when i try like 'make
Dear,
Now i'm trying to install MySQL 4.0.14 through binary source install.
I'm using Redhat 7.2 and 8.0
I'm trying like this..
./configure --prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--with-charset=big5
make
so far there is no problems.
but when i try like 'make
Dear,
Now i'm trying to install MySQL 4.0.14 through binary source install.
I'm using Redhat 7.2 and 8.0
I'm trying like this..
./configure --prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--with-charset=big5
make
so far there is no problems.
but when i try like 'make
Dear,
Now i'm trying to install MySQL 4.0.14 through binary source install.
I'm using Redhat 7.2 and 8.0
I'm trying like this..
./configure --prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--with-charset=big5
make
so far there is no problems.
but when i try like 'make
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Rob Yelvington" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, August 15, 2003 4:10 PM
Subject: Re: querie assitance
> At 15:52 -0500 8/15/03, Rob Yelvington wrote:
> >I need some help with a query.
> >
> >I have t
38 matches
Mail list logo
