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 sm
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
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 c
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 :
(gdb)
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, thank
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]
- Origin
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
An
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
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 o
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 th
-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 <[EMA
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 thi
...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 " string some
place.
Benjamin Pflugm
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 that
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 Sl
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 th
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
realize
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 sa
In your implementation, using limit,
LIMIT ,<# 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 4
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
exceeding
> -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 maki
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 ta
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
http://www.linux-mag.com/2001-12/mysql_01.
>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 t
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 sea
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
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 versio
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 snap
On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri wrote:
> Mark,
>
> if you do not explicitly do
>
> SET AUTOCOMMIT=0
>
> then MySQL automatically calls COMMIT after every SQL statement.
Make that:
SET AUTOCOMMIT=1
Heikki is probably low on coffee. :-)
Jeremy
--
Jeremy D. Zawodny, <
> - Original Message -
> From: "MySQL Newsgroup" <@[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, April 19, 2002 2:55 PM
> Subject: Re: Select with Order By that don't use my INDEX :(
>
>
> > Subject: Re: Select with Order By that don't use my INDEX :(
> > From: Vic Cekvenich
Gelu wrote:
>
> 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 net
Hello!
You are my last chance, reading FAQs and asking in newsgroups gives no
effect.
I have a problem when connecting a MySQL table in MS Access (2000) through
MyODBC.
MySQL is ver. 3.23.44 running on FreeBSD 4.5 box.
Description of the problem:
I connect the table and Access correctly retri
I try to compile mysql-2.23.49 but configure process stopped for an error:
checking for termcap functions library... configure:error/No curses/termcap
library found
I have gcc 2.95.3, make 3.79.1 on linux ppc 2000 with 2.2.x linux kernel.
Can you help me?
Thanks
Filippo Trocca
--
Jeremy,
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, April 22, 2002 9:37 AM
Subject: Re: InnoDB transactions with Connection Pooling
> On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri w
Hi!
> "Eric" == Eric Thelin <[EMAIL PROTECTED]> writes:
Eric> On Sat, 20 Apr 2002 [EMAIL PROTECTED] wrote:
>> I always get a syntax error when using INSERT_METHOD in creating merge
>> tables. If I leave off the INSERT_METHOD part it works fine. I have
>> tried this on many versions in th
42 matches
Mail list logo
