On Thursday 06 June 2002 9:51 am, Greg D. wrote:
I was wondering if there was a better way to speed up
my update statement in my perl script. It goes through all the
entries in the database , which is around 800, 000, and then updates the
email field. The problem is that it takes to
On Wednesday 05 June 2002 4:28 pm, Jay Liew wrote:
Hello everyone,
I am new to database operations, and I was wondering if there were any
advantages or using MS Access to MySQL. Don't get me wrong, but I would
prefer Open Source over proprietary, but this is a mission-critical
On Wednesday 05 June 2002 4:54 pm, Jeremy P. McKay wrote:
I do not really think MS Access is for Mission-Critical databases...but I
guess that depends on ther definition of mission critical. Most MCP will
agree that MS Access does not scale well and offers little advantages for
Please stop reposting your question.
You should be able to get this information from Delphi. Set up a time object
before you execute the query.
On Thursday 16 May 2002 10:19 am, Alexander Burbello wrote:
I made a program with delphi and I would like to get the message when is
execute any
On Monday 13 May 2002 1:49 pm, Taylor Lewick wrote:
Hi All, I am fairly new to mysql..
I am using perl, mysql, and apache to do a little development, and to learn
quickly I am trying to do some real dbase transactions...
I have a program whcih gets a bunch of stock quotes from the internet
Look up the ALTER TABLE statement.
On Friday 10 May 2002 12:52 pm, Tang Ngo wrote:
I am beginning to learn mysql.
How to add a column to table in mysql database.
Thanks
Tang
-
Before posting, please check:
On Tuesday 23 April 2002 1:10 pm, destr0 wrote:
query, table
When I run the query:
SELECT LAST_INSERT_ID() as id FROM myTable;
This query really makes no sense. It is almost the same as:
SELECT LAST_INSERT_ID() as id;
It returns the last inserted Id, but why does it return that value
http://www.mysql.com/doc/S/E/SET.html
On Tuesday 23 April 2002 1:45 pm, Jim Philips wrote:
I couldn't find this in the documentation. What is the propoer sql to
insert into a field with a data type of set? My field has the following set
of acceptable values:
GA, TN, SC, NC, AL
Assume I am
Do you have g++ installed? It doesn't look like you do.
On Friday 19 April 2002 1:45 pm, Ricky Sun wrote:
I am trying to install mysql 3.23.49 source release on RH7.3 Beta 1
workstation... Encountered the following gcc C++ compiler executable
creation problem
when ./configure checks
I'm not sure what you are asking. Everything is working correctly as far as
I can see.
On Tuesday 16 April 2002 10:19 am, Svensson, B.A.T. (HKG) wrote:
Is this a documented behavior of MySQL(?):
mysql create table test (a int);
Query OK, 0 rows affected (0.03 sec)
mysql insert into test
-Original Message-
From: Christopher Thompson
Sent: Tuesday, April 16, 2002 6:24 PM
To: Svensson, B.A.T. (HKG); Mysql List
Subject: Re: WHERE codition test
I'm not sure what you are asking. Everything is working correctly as far
as I can see
Read the manual. MySQL doesn't support subselects but offers you
alternatives.
On Monday 15 April 2002 2:45 pm, Jeff Shipman wrote:
I'm trying to do a fairly simple select of a
column from a table where the date of that column
happens to be the highest value. I tried this:
SELECT name
appreciate
it (slow modem connection, etc).
Christopher Thompson wrote:
Read the manual. MySQL doesn't support subselects but offers you
alternatives.
On Monday 15 April 2002 2:45 pm, Jeff Shipman wrote:
I'm trying to do a fairly simple select of a
column from a table where the date
On Saturday 13 April 2002 4:34 pm, Samwise Gamgee wrote:
I am trying to update a table with information from that same table and
another table. I have two tables, player and goalie, for a hockey pool.
The field pool_points is total points for forwards, goals * 2 for
defencemen and point +
On Friday 12 April 2002 2:26 pm, BJ Phillips wrote:
I can load files from '/home/mysql' but when trying to do it from any other
user ('/home/user/directory'), I get an error 13 about cannot get stat on
file such and such. The files are located on the server and are owned by
the user, both
You shouldn't be storing the questio number at all. You have denormalised
your database and this is why you are experiencing this problem.
Instead, store a unique identifier with each one (an 'id' field,
autonumbering) and then, when you pull back all the questions, order it by
this ID
Sure, just don't include it in the list of columns to bring back.
SELECT column1, column2 FROM ...
instead of
SELECT * FROM...
or
SELECT columnIDoNotWant, column1, column2 FROM ...
On Friday 12 April 2002 3:29 pm, Thi Cao wrote:
Can I hide the auto_increment field?
-Original
On Friday 12 April 2002 8:10 pm, Carl Schmidt wrote:
I have a form where a user enters some numbers into text boxes. Some of
the text boxes can be left blank. The business logic receives all
variables to all text boxes. Should I :
I'm assuming that you are using an executable file and NOT
On Thursday 11 April 2002 4:09 pm, Thi Cao wrote:
All,
When I insert records into a database, the records will be inserted in the
order that I have them listed in my insert statement. So my question is,
will the MySQL database always return the records in the order of insertion
when I
On Monday 08 April 2002 10:09 pm, Daniel Jarrett wrote:
i'm building a table in MYSQL that has about 30 fields..
is this inefficient to have a large number of columns?
Not necessarily, no. Often, it is more efficient.
if anyone can direct me to some good info on efficient design tips/
On Tuesday 09 April 2002 11:07 am, Alain Del Giust wrote:
if you have a foreign key constraint, that field must be one of the values
of the referenced column and that column, being an index, is never NULL
OK so my understanding is that it is impossible with mySQL to do such
things wich are
On Tuesday 09 April 2002 11:47 am, Alain Del Giust wrote:
I am just testing mySQL so I will be able to use it instead of Oracle
Sybase ...
I am not saying a PK can be NULL wich is impossible
But a FK can be NULL and I'd like to know how to do that with mySQL
I do not see this as being
On Tuesday 09 April 2002 2:13 pm, Andrew Hazen wrote:
Hi,
Can I use the MD5 function in the where clause, as in:
Select * from table where md5(column)=value
I see no reason why not but note that you are likely MUCH better off storing
column as an MD5 hash, computing the MD5 of value,
On Monday 08 April 2002 9:49 am, Chuck \PUP\ Payne wrote:
Ok, I know I am going to get yell about this but how can I do an SQL and
only show to fields from a table. For example I only like to see the names
and birthday? Or will as so all fields for a given table.
SELECT field1, field2 FROM
On Friday 05 April 2002 10:16 am, john wrote:
Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID =
1;
that is the command that I am attempting to issue, but states the where...
is wrong. What's wrong with that?
It isn't valid SQL. You are, I think, trying to do an
On Friday 05 April 2002 10:29 am, [EMAIL PROTECTED] wrote:
We are writing a book about MySQL. There will be emphasis on using MySQL
with perl/php, .net java. The publisher needs lots of emphasis on SPs and
nested subqueries. We need to be able to write about implementing biz rules
using
On Friday 05 April 2002 2:54 pm, Zhao, Charles wrote:
Thanks Todd and Tyler for the encouragement,
When I searched on Mysql column types, I did not find any obviously
suitable for images. I do not suppose I can use VARCHAR, can I?
Use one of the BLOB types.
Note that if you are running a
On Thursday 04 April 2002 2:21 pm, Guy-Maurice Lepoutre wrote:
Hello,
I would like to create a MySQL database using DAO and
Visual C++ 6.0 (CDaoDatabase and CDaoRecordset). I
know there is a Create() method on CDaoDatabase but I
cannot figure out how to use it to create a mysql
database.
Note also that by doing this, your database will be denormalised. This may
not be a big deal, however.
On Wednesday 03 April 2002 9:55 am, you wrote:
UPDATE mytable SET field1=field2;
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03,
On Wednesday 03 April 2002 12:35 pm, Leo Przybylski wrote:
Hello all,
Does anyone know if MySQL can do subqueries?
Not the current version, no.
I am trying to provide a SELECT subquery to an IN clause and I am getting
errors. Is this possible?
Read the manual and follow the example on
On Wednesday 03 April 2002 2:02 pm, Lori Thompson wrote:
Does MySQL have the capability for the user to specify their own
delimiters for the command:
INSERT into (database) values (value1, value2,...,valuen);
The values that I am inserting contain both and '' and I am receiving
a syntax
On Thursday 28 March 2002 9:48 am, Harry Rorarius wrote:
I thought Mysql was a server that could be used as a online database?
Yes
If it is, is there some material I have not read that tells me how to do
this?
What are you trying to do? You have not been at all clear in
[For the spam-bot: Go away, you annoying little beast. You know I'm not
posting spam so stop querying me about it and let's get back to the topic at
hand; sql]
On Sunday 03 February 2002 1:27 pm, Chuck Barnett wrote:
Hi, I have a db field that holds the first and last name of a person. Is
On Tuesday 26 March 2002 2:56 pm, Harpreet Kaur wrote:
I am using
C:\ BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa P sapwd -c
-t \t -r \n
to create a text file from a sqlserver table . Th text file shows a tab
after every field except the last field. How can i get it to put a
On Tuesday 26 March 2002 3:30 pm, adam nelson wrote:
It's been a while since I've done this, does anybody remember:
If I have 2 tables:
tblPerson (
iPersonID int
szPersonDesc varchar
iPersonType int
)
tblPersonType (
iPersonType int
szPersonType varchar
)
iPersonType =
On Tuesday 26 March 2002 3:26 pm, Steven Hajducko wrote:
I'm trying to take a string ( In this case, a password ), and encrypt it
with RSA encryption via the perl module, Crypt::RSA. Later on, I want
to be able to pull the encrypted string back out and decrypt it.
Note that if you do this,
What percentage of your database contains rows where status = 200? It looks
to me like MySQL is estimating that perhaps 1/3 or more of the rows have that
status and therefore, it is faster to simply do a table scan rather than
using an index.
On Monday 25 March 2002 1:08 pm, Michael C. Neel
On Thursday 21 March 2002 11:28 am, Klym wrote:
Is it possible to have your web server and your MySQL server running at
different geographic locations? I'm wondering if I can run my own MySQL
server here at home on Linux and have my web site use PHP to connect to it
and extract data. Is
Have you looked at:
http://www.mysql.com/information/benchmarks.html
On Tuesday 19 March 2002 11:50 am, Kathy Reyes wrote:
Hello all its me again
Does any one now of any database benchmarking utility that I can use on
mysql database???
On Monday 18 March 2002 4:22 pm, [EMAIL PROTECTED] wrote:
Everyone,
What's the differences with MySQLD and MySQL-max?
MySQL-max supports more table types.
-
Before posting, please check:
http://www.mysql.com/manual.php
Your problem, I _think_, is that your query works as follows:
for i = 0 to table_name.rows {
row -- table_name.row[i]
if row.count = ROUND(rand() * 10) then result += row
}
NOTE: ROUND(rand() * 10) is performed FOR EACH ROW in your table. You
actually mean for it to
On Thursday 14 March 2002 9:32 am, BD wrote:
Why or why couldn't MySQL have used case insensitive names in the first
place? Store everything in lower case internally, but allow the user to use
Invoice_Number or invoice_number or INVOICE_NUMBER in the SQL
statement and it should refer to the
On Tuesday 05 March 2002 10:15 pm, Amit Lonkar wrote:
hi
Does Mysql support Transat SQL???
Assuming you mean Transact SQL, no. 'Transact SQL' is Microsoft's name for
their proprietary extensions to SQL. Only Microsoft SQL Server supports it.
But then again, MS SQL doesn't support MySQL's
This is not a MySQL question, it's a Solaris question. :) But anyway, you
need to get and install ncurses (version 5). You can find more information
at:
http://www.gnu.org/software/ncurses/ncurses.html
On Wednesday 06 March 2002 8:57 am, Atif Faruqui wrote:
Hello,
I feel i am dead
mysql_row_seek().
On Wednesday 06 March 2002 10:26 am, JOUANNET, Rodolphe wrote:
Can someone tell me how to find the previous record in C (with mySQL API
function). I do a SELECT statement, read it with mysql_store_result(), read
the first record with mysql_fetch_row(), the next record with
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#MySQL_server_licenses
On Wednesday 06 March 2002 1:17 pm, Zengfa Gao wrote:
Hi,:
I heard that when we use MySQL on windows, we need to
pay fees. But I can't find anything on MySQL document
to talk about this.
Do
On Tuesday 05 March 2002 11:11 am, Edward Peloke wrote:
I asked yesterday but got no responses...anyone have any ideas how I can
use one odbc connection but have access to all databases on the MSSQL
server???
I have not tried this but have you considered using the use command? Or even
No need to get all snarky. People are confused because there's a whole
section in the manual that covers the installation, step-by-step, with no
cryptic mumbo jumbo. This is at
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Linux-RPM
and basically tells you to
This has nothing to do with MySQL. Check out freesql.org and talk to them
about your problems.
On Monday 04 March 2002 1:31 am, Zandona Marcello BGV wrote:
sql-problem!
hello,
please could you help me? after you made some
work on your server.. the side of
www.fcliestal.chdoes not
On Monday 04 March 2002 10:50 am, Richard Clarke wrote:
create table mytable (id int, val char(255), hits int);
insert some data...
select max(5,hits) from mytable group by id;
This would allow selecting of the top 5 rows for each id according to the
hit column.
Without this function it
On Friday 01 March 2002 9:21 am, BLANCHET wrote:
Hi,
Is it possible to make simultaneous 2 SQL queries in a MySQL database(
update, insert and the other) on only 1 table. Because my DB is on a server
and i I've 5 clients who works on the same table. Samuel
For reasonable definitions of the
What is your query? What error message do you get?
On Friday 01 March 2002 2:46 pm, Alexander Shaw wrote:
Hi,
I have an application running under Access 2000 with linked MySQL tables.
At the moment I m trying to run a query to populate a second table. Some of
the data in the query is a
On Friday 01 March 2002 2:51 pm, Thomas LaCicero wrote:
I am not sure if this is going to sound like a stupid question but here it
goes...
If I have a table with a Float field and, an entry in that field that has
at least one decimal place, and I try to do a SELECT * FROM some_table
WHERE
For what it is worth, this does NOT cause 3.23.41 to crash.
On Friday 01 March 2002 3:47 pm, Tony J. White wrote:
Using versions 3.23.47 or 3.23.49a on linux i386 precompiled binaries.
Using ORDER BY on a column that is type text causes a crash.
The following MySQL Query crashes it's MySQL
On Thursday 28 February 2002 3:47 pm, Eric Colley wrote:
I have a MySQL table of basic user information including email address as
one of the fields. The table is about at the 10,000 record mark. I have a
list of bad email addresses that another program found for me (around 2,000
records).
On Thursday 28 February 2002 3:47 pm, Eric Colley wrote:
I have a MySQL table of basic user information including email address as
one of the fields. The table is about at the 10,000 record mark. I have a
list of bad email addresses that another program found for me (around 2,000
records).
On Tuesday 26 February 2002 4:00 pm, Scott Broderick wrote:
Hello group! I am a newbe to this listing.
What I am attempting to do is pass a number like 0123456 to a field in
the mysql database which is setup as int(11) but for some reason, the zero
is not
written into the database but
On Friday 22 February 2002 5:03 pm, Luie wrote:
hello all,
anybody know where to find a quick reference guide for mysql
commands/functions?
If you are looking for an SQL quick reference guide, check out SQL Instant
Reference (2nd Edition) by Martin Gruber, published by Sybex. Very good
I am trying to do an inner join between three tables. Here is what I have
tried:
select * from MapConfig LEFT JOIN ConfigString USING (id) LEFT JOIN ConfigInt
USING (id) WHERE MapConfig.layername = Roads;
What I am trying to do is to pull back all rows from MapConfig associated
with
On Thursday 21 February 2002 3:29 pm, Rick Emery wrote:
try:
select * from MapConfig mc LEFT JOIN ConfigString USING (id)
LEFT JOIN ConfigInt cf on mc.id=cf.id WHERE MapConfig.layername = Roads;
Heh. It's been too long since I worked with SQL.
Thanks, that worked perfectly.
On Tuesday 19 February 2002 4:31 pm, Peng Zhao wrote:
Can somebody tell me why these 3 flags must be added when I
compile mysql from source code? I am trying to use another compiler
I see no reason that these should be required.
-fno-implicit-templates simply requires all templates to be
On Tuesday 19 February 2002 4:56 pm, Peng Zhao wrote:
Thanks for your reply. But You can find something from
http://www.mysql.com/doc/I/B/IBM-AIX.html :
Thanks, I hadn't noticed that.
If you are using gcc or egcs to compile MySQL, you must use the
-fno-exceptions flag, as the exception
Prefix it with the path:
/usr/local/mysql/mysqld start
or whatever.
On Friday 15 February 2002 3:16 pm, Mark M Jervis Jr. wrote:
Hi,
I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686. When
I try to run it to finish installation and set up users, i get the
following
On Wednesday 13 February 2002 10:51 am, Shih-Hao Li wrote:
Does anybody know what's the minimum memory requirement
for mysql running on Redhat Linux and Sun Solaris?
Please reply or cc to my email address.
I have run MySQL with 32 megs of RAM quite happily. Note that this was NOT
On Wednesday 13 February 2002 12:10 pm, Trond Eivind Glomsrød wrote:
Our kernel people love them - Athlon goodness, no VIA chipset. Good
performance, good stability.
Note that the Via kt266a (_not_ SMP chipset) is quite good these days.
If I was building a dual-processor machine, there's no
On Wednesday 06 February 2002 3:35 pm, Claire Forchheimer wrote:
I want to select all entries in my table that in a column with given
dates findes all dates inbetween $from_date - $to_date. (These are
vars that the user supplies from the HTML-page). I don't know how to set
up the SELECT
On Tuesday 05 February 2002 9:59 am, Barry J. Wiegan wrote:
Hi,
I'm trying to build a query to solve a fairly simple problem.
I have two tables (A and B) linked by a common ID. I want to
locate a specific record in A that is linked to two or more
records in B based on second field in B
At 09:49 AM 1/30/2002 -0500, Hashim Ismail wrote:
Is there a database size limitation with MySQl in the Windows NT and Windows
2000 enviroment? Like some databases have size limitation of 2GB.
Yes. Read the manual. In a Windows environment, table sizes are limited
to 2 gigabytes if memory
At 02:34 PM 1/30/2002 -0600, Emily Kelley wrote:
In the process of searching for a dynamic database solution for a work
project I have just begun reading about MySQL. So far this looks like a
very promising choice for us but I have one extremely basic question that I
hope someone will kindly
At 03:15 PM 1/29/2002 -0500, Douglas Brantz wrote:
Hello,
I have a big problem! I need to match all patterns in schdays from a
variable schdays and if schdays = mwf it only turns up mwf and not all
entries containing M, W or F. Is there a way to do this?
mysql select schdays from courses where
At 09:50 PM 1/29/2002 +0100, Torkil Johnsen wrote:
Given this example:
table CARS
has got an entity Labourghini with car_id=5
table NEWS
has got an entity Lambourghini displays new super model with
date=2002-05-02, news_id=735 and car_id=5
Now:
I want this output:
NEWS HEADLINES
date:
Not _necessarily_ true, surely, if there's another transaction active at
the moment (assuming you are using a table that supports transactions)...?
At 03:16 PM 1/29/2002 -0800, James Montebello wrote:
SELECT MAX(id) FROM table;
will get you the highest value for 'id', that +1 will be the
Nathan:
I suspect you are trying to solve the wrong problem. Why don't you tell us
_why_ you think you need this value, what you are trying to accomplish.
At 04:23 PM 1/29/2002 -0700, Nathan wrote:
But if this is the MyISAM table type, and you performed an insert, then a
delete, your MAX + 1
At 05:27 PM 1/28/2002 -0800, Lance Prais wrote:
Why when I use the following SQL it get a
ORA-00937: not a single-group group function
What could I be doing wrong?
I am only trying to group on Time_stamp.
Thank you in advance
SELECT
ROUND(AVG(COUNT(Time_stamp))),
At 05:19 PM 1/24/2002 +, [EMAIL PROTECTED] wrote:
I've installed Mysql on my machine, two of my machines, one on win98 and
other on windows 2000. But for some reason when the developer is trying to
run any query from a VB applications, it tends to slow and hang both the
machines. I 'm trying
At 04:10 PM 1/24/2002 -0500, Michael Stearne wrote:
We have a somewhat large read-only table (2.9 million recs). I am wonder
if there is a utility that will look at each row of each columns and come
up with a summary of the largest field (in character length) for each
column. For example,
, 2002 4:38 PM
To: Christopher Thompson
Cc: [EMAIL PROTECTED]
Subject: Re: Tighly packed table
Christopher Thompson wrote:
At 04:10 PM 1/24/2002 -0500, Michael Stearne wrote:
We have a somewhat large read-only table (2.9 million recs). I am
wonder if there is a utility that will look
At 05:58 PM 1/24/2002 -0500, Michael Stearne wrote:
The problem is, this query really hurts (I don't know if it finishes) for
unindexed field for 2.9 million rows. But I'm sure it will finish eventually.
Yes, it will really hurt. After all, there's no way for MySQL to do this
other than
At 10:23 PM 1/23/2002 +, you wrote:
Hi,
I have a blank table for some testing.
1 of the fields (the primary key) is an auto_increment and not null.
how and what do I insert into this field to start off the recordsets. also
once I have set the records going say to 1, what do I then insert
At 02:51 PM 1/23/2002 -0800, you wrote:
i understand that creating a M:N relationship in mysql involves 3 tables,
one of which being a bridge, but how do i join the first and third tables
by way of a bridge?
example: a table of subscribers and a table of magazines with a bridge
in the
At 02:45 PM 1/23/2002 -0800, Eric Mayers wrote:
I'm designing a system that will parse and store log files in a
MySQL-Max-2.23 database (the log table will be innodb). I have a
requirement that as the database fills towards maximum capacity that it
writes over the oldest records rather than
familar with MYSQL syntax yet but I think you'll
be able to translate.
select
m.magazinename
from
s,m,b
where
s.name = 'fred'
and
s.id=b.subscriberid
and
m.id=b.magazineid
;
On Wed, Jan 23, 2002 at 03:59:11PM -0700, Christopher Thompson wrote:
At 02:51 PM 1/23/2002 -0800, you wrote
Have you installed perl? You need it (and the Perl MySQL drivers)
installed before you can benchmark. Also, you'll want to modify the batch
files such that it uses a different user (possibly the root user if you
haven't changed the password on that yet).
Note that running the benchmark
At 02:41 PM 1/21/2002 -0600, jon-david schlough wrote:
yep. perl is all good - got activestate perl fer windoze and the
dbi and the dbd - everything went fine as i went thru the tutorial in the
manual...i was able to: perl -v and get the version info...
Great. So perl is in your path? I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a problem compiling an app that uses the MySQL C API. My program
itself is C++ using Visual C++ 6.0 in Windows 2000, but the C api is plenty
sufficient for me. I suspect the problem comes because when I include C++
streams, I use the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At 03:44 PM 1/18/2002 -0500, you wrote:
We use mysql heavily in production with tables over 30GB. We are going
to purchase a new db server soon and the decision to be made now is
whether we should go with a 4 cpu 700-900MHz system or a 2 cpu
86 matches
Mail list logo