Hi!
I have a small problem:
a have a database containing three fields
number, timestamp, used
i allready inserted into the number fileds about 50.000 random and
unique numbers - timestamp and used are empty
With my perl script i have to do the following:
look into the database for the first
Howdy, how can I add an extra field to an already created table in sql ?
Andrew rich
-Original Message-
From: Sascha Kettner [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 21 April 2002 9:29 PM
To: [EMAIL PROTECTED]
Subject: Number pickup with parallel updating? with script!
Hi!
I have a
On Sat, Apr 20, 2002 at 05:16:46AM +0200, Benjamin Pflugmann wrote:
Hi.
[...]
According to the MySQL doc (5.2.7, example 5) this should work
using the index without any additional sorting.
MySQL-3.23.49-max-log running on FreeBSD 4.4-RELEASE
I assume you are referring to the
On Sun, Apr 21, 2002 at 02:44:32PM +0200, Roger Baklund wrote:
* Sven Huster
This manual is f@#$% up, since it seems like there is no manual for
stable versions online or at least some annotations that say in which
version a feature was introduced (it's not nice to lookup every change
From: Andrew Rich [EMAIL PROTECTED]
Howdy, how can I add an extra field to an already created table in sql ?
ALTER TABLE tablename ADD columnname attributes
See http://www.mysql.com/doc/A/L/ALTER_TABLE.html for more details.
--
denonymous
www.coldcircuit.net
Hello, All!
I have program which try to connect to different mysql servers twice at
the same time.
When I use libmysqlclient.so sometimes one or two mysql connection freeze
in mysql_real_connect
But when I try to use libmysqlclient_r.so
program crash in my_fopen
this is stack of program :
Hello.
On Sun, Apr 21, 2002 at 02:15:33PM +0200, [EMAIL PROTECTED] wrote:
[...]
I assume you are referring to the online manual? It's documenting the
most recent version. According to the change history (Appendix D),
this optimization was introduced in version 4.0.2.
I see, thanks for
Hi,
You can use show full processlist to see what table is locked and unlock
tables;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original
Can anybody explain how to start MySQL on Windows 2000? I've moved and
renamed the my.ini file to C:\my.cnf - to no avail. I get the following
messages displayed in the Err File tab of WinMySQLadmin:
020421 5:22:28 MySql: Got signal 11. Aborting!
020420 8:41:09 MySql: Shutdown Complete
Any
hey.
I have a little question (hope somebody can help me
out)
I search for a script/tool/... to write mails into a
mysql db. (I know there is a perl script mail2db.pl,
but i cant find it)
Or better is there a script for fetchmail to write the
mails direct to the mysql db
Big thx for your help
At 23:34 -0500 4/20/02, Darren Vollmer wrote:
Both files are world readable.
How do you know this?
Because FTP tells me they are.
Also, when you say client machine, what do you mean? In particular,
are the web server and the MySQL servers running on the same machine?
Client
Hi,
I know , sound strange.I life the same experience and my problem was ,
the first network switch, near the server machine(big responding time on
the network - over 5.000 msec).What is was really oddly, not all the time
the network have the same behaviour.
The network interfaces , mounted on
Joe:
Here is what we do ...
- Login as Administrator
- Open DOS Prompt, switch to the drive with MySQL on it, and CD\MYSQL\BIN
- Type MYSQLD-NT --INSTALL
- Type NET START MYSQL
If that doesn't do the trick, your C:\WINNT\MY.INI (or C:\MY.CNF) may not be
correct. Most coomon mistake is to use
-Original Message-
From: zlab1 [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 21, 2002 13:50
To: MySQL Mailing List ([EMAIL PROTECTED])
Subject: Problem with HAVING
Hi,
I'm running Mysql 4.01 on mandrake 8.2 with all production data
using InnoDB type.
I've a field named dch_pri
Hi,
You use and two different mysql_init ?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Andrey Kotrekhov
Hi,
I have a question about how to optimize MySQL performance for a somewhat
unusual (I think) usage pattern.
In the first process, I'm summarizing a large amount of time series data
(the main table will end up around 5GB, index around 1/3 of that) and
storing the summaries to the db. During
...winner will be announced January 31, or sometime in February.
Did I miss something?
What is the Dolphin's name?
Steve the mysql data guy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi benjamin/Sven,
it's my understanding that the latest revision of the manual is (minus
4.x commits) always included in the distribution set. New features
are always documented in the manual and are nearly always appended
with a This was added in version insert version here string some
place.
I have the standard tarbal install of mysql. I want to know how do I start
the server so that I can access it from another machine. I am running on a
linux 6.2 server where the local ip address of the box is 192.168.1.150 and
the hostname is MysqlServer. I need to be able to change the host
Hey guys,
I have a, for you simple, newbie question.
my query is SELECT * from $TableName LIMIT $name
now $name goes from 1 to 4, the 4 rows in my database, but i just want the
query to give me one row, not say if $name is 2, rows 1 and 2, just row 2.
How do i do this?
thanks,
Jule
--
Jule
From: Kevin Fialkowski [EMAIL PROTECTED]
...so that I can access it from another machine.
Hi Kevin,
This isn't a matter of how you start the service, but of your user privileges. Users
are not only known by user name and password, but also by the host they are coming
from.
Start with this
Hi, I am interested to know if there was any comparisions made between
windows and unix mySQL ? What is the performance difference in comparable
hardware and same version of mySQL running on unix vs windows ? If anyone
can offer some help/insights/pointers I will appreciate it very much. I
Hello,
When attempting to create some tables using the MySQL 4.0.1 alpha and
3.23.49, I'm getting a generic error message, General error: Can't
create table './industria/ORDEREDITEMS.frm' (errno: 150). The other 6
tables, all using similar features, are created without a problem.
perror just
In your implementation, using limit,
LIMIT startpoint,# to retrieve
so you would want $name=2,1
-Brenden
On Sun, 2002-04-21 at 17:05, Jule Slootbeek wrote:
Hey guys,
I have a, for you simple, newbie question.
my query is SELECT * from $TableName LIMIT $name
now $name goes from 1 to
I haven't been able to dig up any specific information about how to get
maximum performance when making changes to large tables. I have a table
that's close to 4 GB, which I'm altering to come up with the best trade-off
between performance and speed. Dropping a column or an index seems
-Original Message-
From: Nick Arnett [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 21, 2002 3:39 PM
To: [EMAIL PROTECTED]
Subject: How to speed up mods to large table?
I haven't been able to dig up any specific information about how to get
maximum performance when making
Anyone have a good resource for mysql optimization
tips? or just standard db optimization.
Thanks,
olinux
__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
yeah.. i've just been researching that subject myself..
it seems that db optimization is mainly about normalization..
check out this
http://www.devshed.com/Server_Side/MySQL/Normal
dan
- Original Message -
From: olinux [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 22,
Hello,
I have a table with a large number of news articles.
Articles of type 'feature' (identified in the
article_type field) will have the path to an image
associated with the article stored. The question is
whether to 1) add a field to the database that most
records will not use OR 2) add a
On Sun, Apr 21, 2002 at 06:21:33PM -0700, olinux wrote:
Anyone have a good resource for mysql optimization tips? or just
standard db optimization.
Well, there are a few things I wrote up last year:
http://www.linux-mag.com/2001-06/mysql_01.html
Description:
Very similar to a problem I reported more than 2 years ago, which
was then fixed in a subsequent release, it now appears that the index on
a column that is declared as decimal(14,2) is not being built correctly.
Dropping the index and re-creating it seems to fix the problem
Hello olinux,
If I were in your shoes, I would put not only paths to images into a separate
table, but also a field called content and probably title, summary,
author and linked all this stuff together via ID-like fields which are
primary keys in those new tables. Then articles table can be
Richard,
- Original Message -
From: Richard Harms [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, April 22, 2002 2:32 AM
Subject: InnoDB Error 150, MySQL 4.0.1 alpha 3.23.49
Hello,
When attempting to create some tables using the MySQL 4.0.1 alpha and
3.23.49,
On Sunday, 21. April 2002 20:54, Colin Faber wrote:
it's my understanding that the latest revision of the manual is (minus
4.x commits) always included in the distribution set. New features
are always documented in the manual and are nearly always appended
with a This was added in version
Mark,
if you do not explicitly do
SET AUTOCOMMIT=0
then MySQL automatically calls COMMIT after every SQL statement.
If you set AUTOCOMMIT=0, then you should yourself call COMMIT after each
SELECT so that you do not leave a dangling transaction open in the database
and that you get a fresh
35 matches
Mail list logo