Re: Documentation bug?

It seems slightly ambiguous - updates are redirected and stalled. The fact that the two statements are in different sentences threw me off slightly. To everyone else who replied, thanks for your tolerance. Regards, Chris On Mon, 2003-12-15 at 03:55, Jeremy Zawodny wrote: > On Mon, Dec 15, 2003

Re: Ugrade from 4.01.3-max to 4.0.16, now slower

Hi! The optimizer issue is a known bug in 4.0.16 (I think). It should be resolved soon if my memory of the traffic on the list as of late is accurate. Regarding the issue with threads on Redhat 9.0 - did MySQL 4.0.13-Max come with Redhat 9.0 (or was it supplied by Redhat)? If it was, then chances

user permissions on test ( DBD::mysql)

In previous installs, I've never been able to do it 'right' but fresh install (4.1.1), new machine. So I'd like to set it up so perl Makefile.PL on modules will install without having to pass special parameters to build process. First. mysql_install_db sets up the test db so that the anonymous

RE: new install - command prompt doesn't work

someone's the man... and i think we all KNOW who it is... :oD thanks a lot Bob...it works...finally... thanks to everyone...again Bob Loeffler <[EMAIL PROTECTED]> wrote: If you are using Windows 2000, do the following to set the path. If you have Windows NT, the steps are similar, but slightly

Re: foreign keys.

On Mon, 15 Dec 2003 12:42 pm, Paul DuBois wrote: > At 11:09 +1030 12/15/03, Mofeed Shahin wrote: > >I'm trying to create a bunch of tables in MySQL. I'm having problems > > creating the following table : > > > >CREATE TABLE foo( > > ID INT PRIMARY KEY, > > note VARCHAR(50), > > FOO_ID I

Re: integer not being inserted correctly

At 19:12 -0800 12/14/03, David Griffiths wrote: If an INT has a fixed range, then what is the point of giving it scale? As in, "int(12)". That's not a scale. For integer types, it's a display width. It has nothing to do with the allowable range of the underlying data type. http://www.mysql.com/do

Re: blocked database by the server

At 21:56 -0500 12/14/03, Oscar Orellana wrote: Thanks, Paul. I have read what you say in the manual, but I don't know the way to fix the problem. Where the instruction FLUSH-HOSTS must be written? In the server? In MySQLAdmin? How can I write such instruction if after this error I can't connect to

Re: Getting Records where date is LESS THAN today, AND...

Ok, I got it... I THINK :o) $sth = $dbh->prepare (qq{ SELECT * FROM newsletters WHERE sent = "1" AND archive = "1" AND ((sendoutmon <= $_current_month AND sendoutday <= $_current_day AND sendoutyear <= $_current_year) OR (sendoutyear <= $_current_year)) }); Just checking a second time for anythi

Re: integer not being inserted correctly

David Griffiths wrote: If an INT has a fixed range, then what is the point of giving it scale? As in, "int(12)". In Oracle, a NUMBER(12) indicates how many digits you could have (in this case, 999 would be the max value). Would an int(2) allow -99 to 99, or -2147483648 to 2147483647? Mayb

Re: integer not being inserted correctly

If an INT has a fixed range, then what is the point of giving it scale? As in, "int(12)". In Oracle, a NUMBER(12) indicates how many digits you could have (in this case, 999 would be the max value). Would an int(2) allow -99 to 99, or -2147483648 to 2147483647? Maybe MySQL should throw a

Re: blocked database by the server

Thanks, Paul. I have read what you say in the manual, but I don't know the way to fix the problem. Where the instruction FLUSH-HOSTS must be written? In the server? In MySQLAdmin? How can I write such instruction if after this error I can't connect to the database at the server anymore? - Or

Ugrade from 4.01.3-max to 4.0.16, now slower

Hello, I recently upgraded from 4.0.13-max to 4.0.16 and now the same queries/sec cause a higher load on the database server. I upgraded to 4.01.6 since the optimizer was not using some of my fulltext indicies. All our tables are MyIsam so I figure there is no reason to use the MA

RE: integer not being inserted correctly

A Pasetti wrote: > When attempting to insert an integer into an integer > column, a different value is being inserted for the > given row. Check out the sql below to see what I mean. > The integer 7819359281 is somehow changed to > 2147483647 when it's inserted. > > Perh

Re: integer not being inserted correctly

At 18:42 -0800 12/14/03, A Pasetti wrote: When attempting to insert an integer into an integer column, a different value is being inserted for the given row. Check out the sql below to see what I mean. The integer 7819359281 is somehow changed to 2147483647 when it's inserted. Have you considered w

Re: integer not being inserted correctly

In the last episode (Dec 14), A Pasetti said: > When attempting to insert an integer into an integer column, a > different value is being inserted for the given row. Check out the > sql below to see what I mean. The integer 7819359281 is somehow > changed to 2147483647 when it's inserted. > > Perh

integer not being inserted correctly

When attempting to insert an integer into an integer column, a different value is being inserted for the given row. Check out the sql below to see what I mean. The integer 7819359281 is somehow changed to 2147483647 when it's inserted. Perhaps someone has experienced this problem and could suggest

Re: foreign keys.

At 11:09 +1030 12/15/03, Mofeed Shahin wrote: I'm trying to create a bunch of tables in MySQL. I'm having problems creating the following table : CREATE TABLE foo( ID INT PRIMARY KEY, note VARCHAR(50), FOO_ID INT, FOREIGN KEY (FOO_ID) REFERENCES foo(ID) ) TYPE=INNODB

Re: blocked database by the server

At 19:41 -0500 12/14/03, Oscar Orellana wrote: Hi, everyone! I'm a new user in MySQL. I've got a problem: The server told me that the database is blocked because of many bad connections. It needs to be unblocked. May I do that from my computer or it has to be done from the server? I am guessing

Re: Problems using date with MySQL 4.1.0 - Alpha

At 18:10 -0600 12/14/03, Lenny Sorey wrote: I am currently using MySQL 4.1 Win2K version along ODBC 3.5.1 Driver I am having trouble using the following LOAD DATA INFILE to import a txt, comma delimited file into to a Mysql Table. Actually the only problem is the date field loading into mysql 4.

Getting Records where date is LESS THAN today, AND...

I am Creating a newsletter site for my employer, which will allow him to just add the newsletter and choose which day to mail it. a cron job runs everynight and mails out a notice that the newsletter is ready, along with the link. I am having a problem getting the date to match up... I have the

My SQL setup issue

Hello, I am unable to start MySQL 4.0. I tried installing it from a mirro image. All looks OK, but when I try to initiate it, I reveive ERROR moving data -103 server. Then I initiate WinMySQLAdmin and I believe I am supposed to be prompted for "Name and Password". I actually get a window wi

foreign keys.

I'm trying to create a bunch of tables in MySQL. I'm having problems creating the following table : CREATE TABLE foo( ID INT PRIMARY KEY, note VARCHAR(50), FOO_ID INT, FOREIGN KEY (FOO_ID) REFERENCES foo(ID) ) TYPE=INNODB; The error I get is the following : ERR

blocked database by the server

Hi, everyone! I'm a new user in MySQL. I've got a problem: The server told me that the database is blocked because of many bad connections. It needs to be unblocked. May I do that from my computer or it has to be done from the server? If there are users who speak Spanish, please send me a mail.

Re: mysql-4.1.1-alpha-win.zip - Missing setup file

>No setup file is included in the ZIP mysql-4.1.1-alpha-win.zip >Do you know why ?? It is alpha software, expect an installer with the final version. In the meantime just extract the zip file into a directory and it should run. -- MySQL General Mailing List For list archives: http://lists.mys

Re: "undefined reference to `errno'"

the reference is found in the source.. from crt.c #include Regards, -Martin - Original Message - From: "Jeff Gordon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, December 14, 2003 3:57 PM Subject: Re: "undefined reference to `errno'" > On Sun, Dec 14

Problems using date with MySQL 4.1.0 - Alpha

I am currently using MySQL 4.1 Win2K version along ODBC 3.5.1 Driver I am having trouble using the following LOAD DATA INFILE to import a txt, comma delimited file into to a Mysql Table. Actually the only problem is the date field loading into mysql 4.1. I have defined the field as a date, date

Re: Documentation bug?

At 2:58 +1100 12/15/03, Chris Nolan wrote: Hi all, while reading through some of the MySQL docs, I noticed the following paragraph: |ALTER TABLE| works by making a temporary copy of the original table. The alteration is performed on the copy, then the original table is deleted and the new one i

Using MySQL in LGPL library

Hi We have been supporting MySQL in the GNOME-DB project (http://www.gnome-db.org) since the beginning almost (1998). GNOME-DB provides several liraries, and one of those is a plugin-based generic data access library (libgda) which allows access to several DBMS, by dlopen'ing the plugins. Each of

Re: "undefined reference to `errno'"

On Sun, Dec 14, 2003 at 02:28:36AM -0600, Bill Runge wrote: > > > > /usr/lib/mysql//libmysqlclient.a(my_malloc.o)(.text+0x23): In function > `my_malloc': > : undefined reference to `errno' > collect2: ld returned 1 exit status > make: *** [error] Error 1 > make: *** [update] Error 1 (Hi, Bill

Questions about indexing

I have a database I'm using for a MMORPG (well, it isn't very MM because I'm something of a noob), and I have a few questions about indexing. I am storing world data in a database. In order to keep everything as swift as possible, I have indexed everything. And I really mean, e

MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

Hello.   I have been tasked with evaluating open source databases for a large upcoming project:  e-commerce, B2B, high availability.   The O/S is most likely to be Linux, although FreeBSD could possibly be used (lower probability).   So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase/Fir

mysql-4.1.1-alpha-win.zip - Missing setup file

Clear DayEvening, No setup file is included in the ZIP mysql-4.1.1-alpha-win.zip Do you know why ?? Cheers Mark

RE: Another Brickwall with Displaying using JOIN

Hi Jess, If there will never be another ID number, something like the following should work (although I don't know about the "\n" part): $Row = mysql_fetch_array ($Result); print ("ID: $Row[id]\n"); print ("$Row[technotes]\n"); while ($Row = mysql_fetch_array ($Result)) { print ("$Row[

Re: Documentation bug?

Chris Nolan wrote: This seems a bit confusing. On one hand, it says that updates don't fail, but on the other hand it says they are stalled until ALTER TABLE is done executing. Am I going blind/loosing my mind (a possibility I am open to) or do others agree with me? It looks perfectly correct.

Another Brickwall with Displaying using JOIN

OK, Have another small issue that maybe someone could help me out with. When using a JOIN I can pull records from a second table without a problem (now). I am wanting to display two fields ( id and notes) however I only want the id field to display once and all the notes to be displayed. Here is

problem with query (group, count)

Hello to all, I searched this list's archive, but I couldn't find a solution to a problem I am currently facing. Any help would be appreciated. I have the next table configuration: session (an session id), weight (a counter), and other fields. When I add a new record and the session id I am tri

RE: RESOLVED - Help with "JOIN" and Record Display

I managed to figure out where I was going wrong (or at least I think I have. I was playing around with the syntax and decided to add a after the $Row[notes] and it displayed the records line by line. I don't know if this was the best way to do it but it worked. Thanks Jess > -Original Mess

Help with "JOIN" and Record Display

This being the first time I have tried to do a JOIN statement (and still not yet fully understanding it). If someone could take a look at the below code and see what I may be doing wrong. I have the actual code working and it displays the information from $TableName2.notes, however in this table t

Re: Documentation bug?

On Mon, Dec 15, 2003 at 02:58:53AM +1100, Chris Nolan wrote: > Hi all, while reading through some of the MySQL docs, I noticed the > following paragraph: > > |ALTER TABLE| works by making a temporary copy of the original table. > The alteration is performed on the copy, then the original table i

Re: Duplicate combination

fr0g wrote: I have a table with peoples names in 3 different languages. Fields are like: id, surname_english, name_english, surname_original, name_original, surname_greek, name_greek. What I want is to check if a person has been entered twice in that table. You can create unique index on (surname_

Documentation bug?

Hi all, while reading through some of the MySQL docs, I noticed the following paragraph: |ALTER TABLE| works by making a temporary copy of the original table. The alteration is performed on the copy, then the original table is deleted and the new one is renamed. This is done in such a way that

Re: Duplicate combination

Hi! There are many ways, depending on whether you want the database to handle it, or you want your application to handle it. What you want is a UNIQUE index on surname_original and name_original. Assuming the table already exists: ALTER TABLE names ADD UNIQUE(name_original,surname_original);

Re: Duplicate combination

Hi, > I have a table with peoples names in 3 different languages. > Fields are like: id, surname_english, name_english, surname_original, > name_original, surname_greek, name_greek. > What I want is to check if a person has been entered twice in that table. > The key is ID but I can't have any oth

Duplicate combination

I have a table with peoples names in 3 different languages. Fields are like: id, surname_english, name_english, surname_original, name_original, surname_greek, name_greek. What I want is to check if a person has been entered twice in that table. The key is ID but I can't have any other field uniqu

"undefined reference to `errno'"

Good morning list, A rather brief introduction; I am new to this list and a novice to MySQL. I am in the process of building a postfix mailserver w/ mysql, courier, cyrus and others on a RH 9 distro. If hardware is a factor these items reside upon a intel pent 4, 3gig ram, and three scsi 120gig