-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sat, 14 Dec 2002, Richard Pijnenburg wrote:
Does this also affects the 3.23.54 source? Or only the binary packages?
Yes, this affected the source archives as well - sorry for omitting this
in the addendum. We've now placed updated 3.23.54a
Now is ok ... thank you very much!
--- Jeremy Zawodny [EMAIL PROTECTED] ha scritto:
On Wed, Dec 11, 2002 at 05:03:51PM +0100, Natale
Babbo wrote:
Hi all,
I have a problem with replication between two
servers.
I created user repl on the master, I restored the
master's dump on the
Paul, nice to here from you,
Could you please tell me where probably to find (directory / file) the line
where PATH has to be set?
Some month ago I created my databases and php-scripts on a small partition
with OS X 10.1.4. Here I installed the package from Marc Lyanage including
php 4 but I do
On 16 Dec 2002 10:09:43 -
[EMAIL PROTECTED] wrote:
Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTECTED] mailing list.
To confirm that you would like
[EMAIL PROTECTED]
added to the mysql mailing list, please send
an empty reply to this address:
[EMAIL
Hi all,
I am now writing an C++ application with the use of
MySQL. When I follow the tutorial in MySQL++ manual,
the application go into segmentation fault during
execution. What's the mistake I have made?
The followings are the codes and the error messages
during execution.
Codes:
#include
Steve Lefevre wrote:
I'm designing a user database for PHP 4 and MySQL 3.32 or whatever.
Users enter a class and it's workshops for their students.
The 'Class' table has fields 'Name' and 'ID'.
ID is the primary key and its an auto-incremented integer
The 'Workshop' table has a field ID,
Steve Lefevre wrote:
I'm designing a user database for PHP 4 and MySQL 3.32 or whatever.
Users enter a class and it's workshops for their students.
The 'Class' table has fields 'Name' and 'ID'.
ID is the primary key and its an auto-incremented integer
The 'Workshop' table has a field ID,
Jari,
I am Cc:ing this to [EMAIL PROTECTED], so that other readers can follow
the discussion.
There is still no my.cnf option to set AUTOCOMMIT=0 globally though users
have requested it a lot.
I think that 4.1 will support a SQL script which is automatically executed
for all new connections.
Hello,
will a binary package of MySQL 3.23.53 for Solaris 2.7 be released?
Regards,
David OBando
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
hi everybody!
i have a problem with mysql, i am trying to create a new database as
follows:
$ cd /usr/local/mysql
$ ./bin/mysql -u root mysql -p
enter Password:
sql create database cardholder;
but i get the following error message:
ERROR 1006: Can't create database 'cardholder'.
Hi everybody,
I'm thinking about switching to innodb, but face the following problem: I've
got a column with texts longer than 256 chars and I need an index on it (for
having acceptable times for a query). So i can't use varchar and indexes are
not possible in InnoDB in text/blob, so I can't use
[root@www tmp]# perror 28
Error code 28: No space left on device
You don't have any more space avaiable on your hdd .
- Original Message -
From: Touria Zaddaoui [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 16, 2002 1:49 PM
Subject: question!!
hi everybody!
i have
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 16 Dec 2002, Obando, David DE - EV wrote:
will a binary package of MySQL 3.23.53 for Solaris 2.7 be released?
Unfortunately we are currently unable to provide binaries for Solaris 2.7
- - our build host is currently down due to a hardware
Stefan,
- Original Message -
From: Stefan Kuhn [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, December 16, 2002 2:11 PM
Subject: Long text with index in InnoDB
Hi everybody,
I'm thinking about switching to innodb, but face the following problem:
I've
got a column
I have been given a task to design a MySQL Backup server on which the client
requests should fall back in case the main MySQL Server is either busy, the
network connection to MySQL Server has broken. I can imagine this should be
possible only if a proxy server is in between the Clients and the
Hi !
Some times my application is hang-up. The stack trace contains the
following:
at java.net.SocketInputStream.socketRead(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:86)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:186)
I am trying to setup PHP 4.2.x wth MySQL 4.0.x
Somewhat new to this, I installed PHP via the redhat RPM.
PHP is being loaded as a module to httpd.
The error I keep getting is that httpd can't find libmysqlclient.so.10
and MySQL 4.0.x rpm installed libmysqlclient.so.11.
I tried making a
I'm testing the FULLTEXT indexing on a TEXT field on an Athlon/500, 256MB
RAM, SCSI-3 disks, FreeBSD 4.6 and MySQL 3.23.46 with my.cnf.large setup.
My table has 26 records and it seems to take too long to complete the
task. It's currently running since yestarday.
Is this processing time normal
Hi,
I have installed MySQL 2.23.53 release and I want to upgrade to MySQL
2.23.54... how can
I do this? Have i got to reinstall? Is there any script?
Any suggest?
Thanks in advance
-
Before posting, please
Hi people,
what is the status of version 3.23.55? It's already available for download
from www.mysql.com, but the links on the official download page all points
to 3.23.54a...
regards
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
Hi, all --
I'm still trying to get a good handle on how sets can be useful to me. I
have three scenarios so far.
1) A set of states (US Mail type, not turing type :-)
I can pick from the list of states when entering address data, and
storing the set entry should take less space than storing
On Sunday 15 December 2002 17:08, Beauford wrote:
I have two tables, one with peoples names in it and one with data
associated to these people. What I need to do is to be able to
automatically total certain items in the data table that correspond with a
name in the first table and then update
On Saturday 14 December 2002 23:07, tlr7425 at garnet dot acns dot fsu dot edu
wrote:
how exactly do I change the Root user's password for mysql?
like this? :
mysqladmin -u root -p'newpasswd' ? (without a space between -p and
'newpasswd' ?)
and, if that is correct, I guess I'd then be
On Monday 16 December 2002 08:51, Matthieu Lalonde wrote:
Hi, I'm trying to get mysql workin' and have had the same prob on both
OS X sever and NetBSD...
here is what's spit out of the .err file:
021215 22:33:00 mysqld started
021215 22:33:02 /usr/libexec/mysqld: Table 'mysql.host'
On Tuesday 17 December 2002 09:43, C. Reeve wrote:
From the MySQL Manual:
ALTER TABLE tbl_name MODIFY [COLUMN] create_definition [FIRST | AFTER
column_name]
I have also tried CHANGE instead of MODIFY.
My Statement:
alter table manager change column w1 decimal(8,2) not null after moves;
On Mon, 2002-10-21 at 14:25, Michael Widenius wrote:
Which log files is it that you want to delete ?
(Please give an example for this)
If you have a problem that old relay logs are not deleted, try to
upgrade to MySQL 4.0.4 ; We recently fixed a bug in this code.
This is still happening
Just be careful because the connection can be looked at and if there is
sensitive data going through someone who wants to can get their hands on it.
The data travelling from the server to the client is not encripted and as
far as I know there are not any hosts that will offer MySQL with the SSL
How are you working with them?
They are working form me doing the following:
In one side this is what I do.
Set rst = dbConn.Execute(SELECT STATMENT)
strFileName = C:\\Path\file.xml
rst.Save strFileName, 1 'adPersistXML
Then to read it back I just do this?
strFileName = C:\\Path\file.xml
Depending on your OS, you might be able to implement security through the
network layer via IPSec.
I run mySQL between two Windows2k servers, with the mySQL server requiring
the web server (in this case, a remote client to the mySQL server) to
establish an IPSec tunnel in order to connect.
It
Hello list.
Could you please suggest me a one-line query to solve a problem of inventory ?
Three table:
Products
-
| id | description |
-
| 01 | bread|
| 02 | milk |
| 03 | coffee |
I understood that MySQL didn't internally keep up with
the relationships between tables... like MS Access...
And that it was up to the programmer to referential
integrity...
But I noticed in phpMyAdmin that the offer the option
of defining a column in a table as 'Primary'
Am I confused on this
Hi,
I just send the one again, hope to find someone to
help me out with MySQL compile.
I am using HPUX 11.11, gcc 3.1.
Thanks!
Zengfa
1. CFLAGS=-fomit-frame-pointer -O3 -fpic CXX=gcc
CXXFLAGS=-felid-constructors -fno-exceptions
-fno-exceptions -fno-rtti -O3 ./configure
--disable-shared
David T-G wrote:
I'm still trying to get a good handle on how sets can be useful to me.
You're thinking of ENUMs. SETs are for when you want multiple things
selected out of a list. So perhaps, favorite colours:
You have a column Colours
Paul DuBois wrote:
manner. AUTO_INCREMENT columns are for use only with *positive*
integers,
and any attempt to use them otherwise will eventually cause you grief.
Just to point out, a lot of people get confused about the definition of
positive integers, especially in how it relates to
On Friday 13 December 2002 09:16, Chris Wagner wrote:
Firstly, I don't believe this is a bug, but I really can't figure it
out. I've installed MySQL through the Red Hat 8 distribution CDs. When I
run safe_mysqld, I have the following message:
[root@localhost bin]# safe_mysqld
[1]
On Friday 13 December 2002 19:48, Ewan \\MEB\\ Oughton wrote:
I just became the database admin on this server, my first job was to
upgrade the mysql install, it was running 3.22.30, I upgraded it to
3.23.54
Seemed to go OK, just want to check... I moved all the databases from var
in the old
I am running the Solaris 8 binary on all of my Ultra Sparc II Solaris 7
servers with no problems at this time, however I am not doing any of the
advanced features, such as MySQL-Max or replication.
Nickg
-Original Message-
From: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
Sent: Monday,
Hello,
I am setting up a mySQL box in my development environment and have noticed
that even under little usage mysql will consume a couple hundred MB's of
swap space even though I have almost 1GB of apparent free physical
memory. I am using the 'my-large.cnf' configuration file and otherwise
I have this SQL Query:
SELECT club . * , MAX( story.stid ) , story.longheadline
FROM club, story
WHERE club.sid = story.siteid AND club.div = 'epl'
and club.test = 0
and story.synd = '1'
GROUP BY club.sid
ORDER BY club.clubname ASC
The problem is that its not displaying the 'story.longheadline'
On Monday 16 December 2002 18:12, tmb wrote:
I understood that MySQL didn't internally keep up with
the relationships between tables... like MS Access...
And that it was up to the programmer to referential
integrity...
But I noticed in phpMyAdmin that the offer the option
of defining a
This is called storing derived data and it's a Bad Thing. (tm) It
denormalizes your schema. The real problem is that derived data stored in a
field has a tendency to get out of sync with the data it is derived from.
Therefore you end up writing programs that wipe it and put it back in sync
and
On Mon, 2002-12-16 at 16:20, Nicolas MONNET (Tech) wrote:
(...)
Nevermind. This was due to an error in the replication; but nonetheless,
it is impossible to shutdown mysqld cleanly if it's waiting for relay
logs to be freed.
--
Nicolas MONNET (Tech) [EMAIL PROTECTED]
Carpe Diem
Hello,
Is there a small program that would transfer the contents of an Access
database to MySQL?
TIA,
Yves Arsenault
Carrefour Infotech
5,promenade Acadian
Charlottetown, IPE
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
ICQ #117650823
On Mon, Dec 16, 2002 at 10:43:28AM -0600, Jamie Sullivan wrote:
Hello,
I am setting up a mySQL box in my development environment and have
noticed that even under little usage mysql will consume a couple
hundred MB's of swap space even though I have almost 1GB of apparent
free physical
Hello every one
At the first, I'm Sorry for my bad english.
I want to install phpMyAdmin for managing My MySql databases, I Downloaded
ths zip file frome here:
http://sourceforge.net/project/showfiles.php?group_id=23067
the file name is phpMyAdmin-2.3.3pl1-php3.zip
I unzip this file on my
At 09:20 AM 12/16/2002 -0800, you wrote:
On Mon, Dec 16, 2002 at 10:43:28AM -0600, Jamie Sullivan wrote:
Hello,
I am setting up a mySQL box in my development environment and have
noticed that even under little usage mysql will consume a couple
hundred MB's of swap space even though I have
Hello,
Still on this database consistency problem with FLUSH TABLES WITH
READ LOCK... I've tried upgrading to MySQL 4.0.5a binary distribution
(instead of source), but the problem does not disappear.
So I've made a little test. I open too shells.
- Shell 1:
I launch the MySQL client. Then
Hi,
A simple left join on two big table took 5 mins to
finish.
Here is the explain
mysql explain select count(*) from newSequence s left
join newSequence_Homolog h on s.Seq_ID = h.Seq_ID;
+---++---+-+-+--+-+-+
| table | type
Hi all,
I'm testing the fail-safety of InnoDB with MySQL, and I find that when
the data files are read-only, the process exits early instead of
returning an error code.
In the file innobase\os\os0file.c, the function os_file_handle_error()
does not recognize the error code 5, and so it
Try this:
SELECT t1.id AS prod_id, t1.description AS
Description,SUM(t2.quantities) AS Purchases,
SUM(t3.quantities) AS Sellings, (Purchases-Sellings) AS Inventory
FROM Products t1 INNER JOIN Purchases t2 ON t1.id=t2.prod_id
INNER JOIN Sellings t3 ON t1.id=t3.prod_id
GROUP BY t1.id,t1.description
On Sun, 15 Dec 2002 17:38:49 -0600, Paul DuBois wrote:
INSERT INTO gebaeude_daten VALUES (0, 'Bank Stufe 1', 1000, 30, 900, 1);
What happens if you use a value of NULL instead of 0?
Inserting a field with 0 tells the table to generate a value on its
own, like it's supposed to.
I Installed succefully MySQL, but i want to have a graphical interface to
create a new databases and manage my existing database.
i readed in a asp-php.net (french web site)
http://www.asp-php.net/tutorial/asp-php/iis_et_mysql.php?page=1
the steps for installing phpmyadmin, you cas see the web
Search the archive!
Short answer:
export to .txt and import in mysql or use ODBC
B.
At 13:20 16-12-2002 -0400, Yves Arsenault wrote:
Hello,
Is there a small program that would transfer the contents of an Access
database to MySQL?
TIA,
Yves Arsenault
Thank you for your attention, Adolfo.
Sorry, it doesn't work.
It looks like quantities are added more times into the SUM function.
gigi
-Messaggio originale-
Da: Adolfo Bello [mailto:[EMAIL PROTECTED]]
Inviato: lunedì 16 dicembre 2002 19.04
A: Gigi Di Leo; [EMAIL PROTECTED]
Description:
mit-pthreads directory missing
How-To-Repeat:
When attempting to compile mysql-3.23.54 on NetBSD 1.5.2, I get the
following error:
Configuring MIT Pthreads
cd: can't cd to mit-pthreads
And in fact, the mit-pthreads directory is not there. However,
Is it possible to duplicate a record in a table into the same table with a changed
field? I have a single user who now has authority over an additional database. I
wanted to duplicate the records in myslq.db for this user, changing the Db field to
the name of the additional database.
I
I guess your question is more about configuring IIS (or PWS) than about
MySQL.
Anyway, you have to create a web site in IIS pointing to your phpMyAdmin
directory and define in it the default document (index.html. default.php
or whatever)
Adolfo
-Original Message-
From: Rachid
Have been running mysql 3.23.43 on a RH 6.2 system and things have worked
fine for the last year. However, we run a mysqldump daily and this failed
yesterday. Looking into the problem I found that mysqld is having some
problems.
running:
mysqldump --defaults-file=default file -A dump file
ÄúºÃ!
ÍøÂçÓªÏú,¿ìÀ´×¬300Íò.
Ö©ÖëÍøÐÅÏ¢´úÀíÁªÃËÊǹúÄÚµÚÒ»¼ÒÒÔ¡°¶à²ã´ÎÐÅÏ¢ÍøÂçÓªÏú¡±Îª¾ÓªÄ£Ê½µÄºÏ·¨µÄÕý¹æ×¢²áÍøÕ¾£¬ËüµÄ×ܲ¿ÔÚÕã½£¬ÆäÕýÒÔÒ»ÖÖոС¢¼òµ¥¡¢ÓÐȤµÄ·½Ê½À´ÈÃÿһλ»áÔ±×ã²»³ö»§Ò²¿ÉÒÔ׬µ½¾Þ¶î²Æ¸»£¬³ÉΪÕæÕýµÄSOHO
Ò»×å¡£
¡¡
ÇëÏÈÈ¥×¢²áΪÃâ·Ñ»áÔ±°É Http://www.cnyilang.com
Hi When i try to install MySQL 3.23.54a linux, rpm it says that MD5
checksum is wrong
I have tried to download the package from another mirror with the same
error.
So is it a bug or do i have something wrong in by system?
Med vänliga hälsningar
Jonas Eriksson
Description:
On Linux, the rpm package dumps the user docs. (manuals) under
/usr/share/docs/packages/MySQL/.
The permissions for the MySQL directory are set to 766 and so the contents of the
directory
(ie the manuals) are not readable. The permissions need to be 755.
How-To-Repeat:
Get RPM
Hello,
I found SERVER-bin.* files from today in my MySQL directory, where
are databases stored. What are theese files and why was created.
SERVER-bin.001
SERVER-bin.002
SERVER-bin.index
Owner mysql, group mysql.
Thanks
Radek
--
S pozdravem,
Bc. Radek Kreja
Starnet, s. r. o.
Yves,
I am always open for cleaner method, but what I did was in MySQL created
a table 'member' for data.
In Access exported as .txt make sure tab sequential.
Back in MySql I made database active that had 'member'
And did a:
mysql load data infile c:\\mysql\\tmp.txt into member;
it actually
Hi,
I was just wondering if anyone has any tricks for speeding up huge queries
that require a LIKE comparison, and also a wild card at the front and back
of the search term. For example:
SELECT my_id FROM my_table WHERE my_value LIKE '%ABCDEFG%' LIMIT 50;
I know that in a query such as this,
Hi,
I have one table with an id1 column and a number column, these numbers
correspond to another table with an id2 column and a name column and a total
column. I also have a reference table with ties the two together (an id1 and
id2 column).
I want to be able to select all numbers in the first
I agree entirely. SETS and ENUMS should be avoided by any normal user
(frankly, I think they should be deprecated). They are not portable and
it's just horrific to be changing data with an ALTER statement.
Foreign Key relationships (even if they aren't real as in standard
MySQL) are the way to
Hello All,
Great list !
MySQL = Incredible Product !
I've been trying to come up with a SQL query to perform the following...
Table - Contact
ClientID
Activity1
Activity2
Activity3
Activity4
Time1
Time2
Time3
Time4
Date
I need to get a total of all the activities and their associated time
I have 2 tables in our MySQL database like this:
TABLE: customers
+--+---+--+-+-+-
---+
| Field| Type | Null | Key | Default |
Extra |
Qunfeng,
A simple left join on two big table took 5 mins to
finish.
These lines tell about the cause of the problem:
| table | type | possible_keys | key | key_len |
| s | index | NULL | PRIMARY | 50 |
MySQL has no key (index) which it can use to speed up the
Darren,
I need to construct a query to find out what customers in the database
have not
booked shipments with us. That means there would be no
records in the shipment table for a given customer id.
If I get this right, it should be:
SELECT custid, name FROM customers LEFT JOIN shipment ON
Chris,
SELECT my_id FROM my_table WHERE my_value LIKE '%ABCDEFG%' LIMIT 50;
I know that in a query such as this, mysql does not utilize indexing, so I
was just curious how some others have attempted to speed up this kind of
thing up
Maybe this answer won't help too much, but I
Dear Stefan,
Thanks for your help. I didn't know MySQL doesn't
automatically create index on primary key (I probably
should create UNIQUE index on them now).
About not mixing char and varchar in one table, I
don't find that info in the on-line documents. I could
successfully create a test
On 16 Dec 2002, at 23:50, Stefan Hinz, iConnect (Berlin wrote:
I need to construct a query to find out what customers in the database
have not
booked shipments with us. That means there would be no
records in the shipment table for a given customer id.
If I get this right, it should
Will MySQL/Windows db files work on a Linux box?
I'm guessing they will, but then someone questioned
me.
I'm creating a MySQL/PHP db prototype on a Windows box
running Apache... but it will end up on a Linux/Apache
server some day.
Thanks for any help.
tmb
I've run into an interesting problem. I have a large innodb table (2274962
rows, 46 columns, 2 datafiles - 4.5GB total).
When I run a query that uses a clustered_index in the where clause and the
data I'm selecting is not the primary key of the table, it takes up to 2 1/2
minutes to return
Technically, the files can work. But the best way (IMHO) is to use mysqldump
out of the Win32 box, copy that file to the Linux box and pipe it in. Make
sure you use options in mysqldump to do complete table creation, etc.
Gerald Jensen
- Original Message -
From: tmb [EMAIL PROTECTED]
To:
I have done that for months on Windows2000/XP. A MySQL database accessed
by a PHP application which runs under Apache.
Without any problem, I have now that working environment under Mandrake
9. I regenerated the db under Linux with a dump from the Windows db.
Adolfo
On Mon, 2002-12-16 at 19:30,
Adam,
I agree entirely. SETS and ENUMS should be avoided by any normal user
(frankly, I think they should be deprecated). They are not portable and
it's just horrific to be changing data with an ALTER statement.
To add some more to this discussion, a customer of ours is having problems
with
Hello mysql,
I am currently building news portal with php and mysql, and quite
surprised knowing mysql doesn't support descending index. Why ? I
think this feature is really needed. For example I want to show the
latest news (from last updates, not always everyday). With ascending
Hi,
Can you just
SELECT x, y, z FROM table WHERE condition ORDER BY timestamp_column
DESC;
?
-Dan
On Tue, 17 Dec 2002, Mpu Gondrong wrote:
Hello mysql,
I am currently building news portal with php and mysql, and quite
surprised knowing mysql doesn't support descending index.
Mpu Gondrong wrote:
Hello mysql,
I am currently building news portal with php and mysql, and quite
surprised knowing mysql doesn't support descending index. Why ? I
think this feature is really needed. For example I want to show the
latest news (from last updates, not always
On Tue, Dec 17, 2002 at 07:37:17AM +0700, Mpu Gondrong wrote:
Hello mysql,
I am currently building news portal with php and mysql, and quite
surprised knowing mysql doesn't support descending index. Why ? I
think this feature is really needed. For example I want to show the
I just got a message from the ezmlm program telling me that the
mysql digests have been bouncing and it is going to remove me from the list.
In fact, the digests have been coming through just fine. Any ideas
on what it could be referring to? Did anyone else get such a message?
Bill
--
Bill
Mpu Gondrong wrote:
Selasa, 17/12/2002 7:38:52, Daniel menulis:
DK What's wrong with using: order by MyIndex DESC
If I have 100 rows and mysql calculates with desc got 90 or more
(30%) rows, index won't be used. I have thousand rows, and just want
to get the last row. Without index,
hi! i'm running mysql-max version 3.23.52-max on a windows xp machine with
the apache web server. i'm trying to get innodb transactions to work using
a php application.
here is the transaction i am trying to run:
set autocommit=0;
begin work;
select * from for update;
update ...;
Hi Bill,
I did too.
Did you get the following error?
CNAME lookup failed temporarily. (#4.4.3)
I'm not going to try again; this message has been in the queue too long.
Fraser.
mysql query
_
Fraser Stuart
Logistics IT
77-85
Selasa, 17/12/2002 7:47:38, Jeremy menulis:
JZ I'm not quite sure what you're after, but MySQL 4.0 has support
JZ for reading indexes in reverse order in some circumstances. This
JZ greatly speeds up some queries that were slow in 3.23.
I'm using MySQL 4.0.4-beta. For example:
EXPLAIN
I also got that msg and I did seem to receive all the
emails from the list.
Qunfeng
--- Bill Rausch [EMAIL PROTECTED] wrote:
I just got a message from the ezmlm program telling
me that the
mysql digests have been bouncing and it is going to
remove me from the list.
In fact, the digests
Guru's
Problem is type SMALLINT needs to be MEDIUMINT (MyISAM).
column: id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT
My solution is to use the following ALTER statement:
ALTER TABLE messages CHANGE id
id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT
My question is: what happens to the
On Mon, Dec 16, 2002 at 04:51:38PM -0800, Bill Rausch wrote:
I just got a message from the ezmlm program telling me that the
mysql digests have been bouncing and it is going to remove me from the list.
In fact, the digests have been coming through just fine. Any ideas
on what it could be
At 2:43 -0500 12/17/02, C. Reeve wrote:
From the MySQL Manual:
ALTER TABLE tbl_name MODIFY [COLUMN] create_definition [FIRST | AFTER
column_name]
I have also tried CHANGE instead of MODIFY.
My Statement:
alter table manager change column w1 decimal(8,2) not null after moves;
The problem is
I'm looking for recomendations on improving system performance. Using
the SQL command below on a MySQL server I find result times averaging
three seconds. Being very inexperienced with database programming I
would appreciate any comments on whether this is expected behaviour, or
where my
Hi,
I assume it's because MySQL returns more than 30% of the totally of the
rows.
On one of my table, with 4.0.6-gamma :
mysql SELECT COUNT(*) FROM news;
+--+
| COUNT(*) |
+--+
| 4985 |
+--+
1 row in set (0.00 sec)
mysql SELECT COUNT(*) FROM news WHERE datec
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi again --
Well, the general consensus seems to be to stay violently away from SETs
and ENUMs :-) I'll certainly give that a shot. I still have to figure
out how to make sure that our credit card types and skill levels don't
get corrupted (MC,
Hi all,
I am having a problem with MySQL and I hope some nice guru can help me.
I am running MySQL server v3.23.49a on Red Hat Linux v7.1. I also need to
run queries on Microsoft Access running on my Win2K machine, using a MyODBC
connection over the Internet. However when I run certain queries
B F wrote:
Hi all,
I am having a problem with MySQL and I hope some nice guru can help me.
I am running MySQL server v3.23.49a on Red Hat Linux v7.1. I also need
to run queries on Microsoft Access running on my Win2K machine, using
a MyODBC connection over the Internet. However when I run
I need to use PHP to duplicate the schema of a mysql database. This
seems like it should be a simple task -- taking a 'template' db and
cloning it with a new name.
I've tried things like:
$filename = myDB.sql;
$fd = fopen ($filename, r);
$sql =
Selasa, 17/12/2002 9:14:39, Jocelyn menulis:
30%, so no index used
JF So the result of your explain seems normal for me.
Sooo..., back to my first thread, could I use index for such query
(datec = '...') ? Query resulting 30% is very seldom (so index is
mostly never used), and very
Yes, exactly. I think I did find that I was missing digest number
2201 so maybe that is what it was referring to.
Bill
At 12:01 +1100 12/17/02, Fraser Stuart wrote:
Hi Bill,
I did too.
Did you get the following error?
CNAME lookup failed temporarily. (#4.4.3)
I'm not going to try again; this
Are you first creating a new database first with mysql_create_db()
before trying to run your schema? What error message do you get? The
code you've posted is only creating a table.
Also, rather than opening and reading in an external file or doing all
those $sql .= lines, you might have an
1 - 100 of 105 matches
Mail list logo