In the last episode (Aug 15), Mark Healey said:
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
- 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 two tables in one
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
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
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
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
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
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
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
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 table
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
* 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,
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
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
- 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 in a .ini
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]
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(*)
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 |
|
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:
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
* 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 |
|
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
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
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-charset=big5
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
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
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:
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
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
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 new
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 called
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 I
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 the
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 need
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
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
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 password
I tried that, and then
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
38 matches
Mail list logo