Re: Alter table and setup Default value

2004-01-03 Thread robert_rowe
This worked for me: ALTER TABLE `test` CHANGE `somefield` `somefield` enum('new','used') DEFAULT 'new' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: LOAD DATA INFILE

2004-01-03 Thread robert_rowe
Both your client and your server must have the local flag turned on. Check phpMyAdmin to see if there is an option to turn this on for the client side. I use ADO/ODBC and I have to create a my.cnf file on the client machine with local infile=1(ON) in the [client] section and tell the ODBC drive

Re: Subtracting date fields

2004-01-03 Thread robert_rowe
Just try to access the databases with the permissions that you had previously set up. If you can then it worked okay. If you can't then use grant to set your permissions up again. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysq

Re: Help:)

2004-01-03 Thread robert_rowe
Issuing this command: > mysql>SET PASSWORD FOR 'root'@'localhost' = PASSWORD xx set your password to xx You will need to use mysql -u root -p xx from the local machine to get access with the root user. This: mysql -u root -p is specifying a blank password. I beli

RE: Dropping a foreign key in 4.1.x

2004-01-03 Thread Joshua Thomas
Nevermind, I found out that the DROP feature is only available in >= 4.0.13 or >= 4.1.1 ...*sigh* Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory and practice. In practice there is. - Yogi Ber

Dropping a foreign key in 4.1.x

2004-01-03 Thread Joshua Thomas
How does one drop a foreign key from a InnoDB table in mySQL 4.1.x? The manual says "ALTER TABLE yourtablename DROP FOREIGN KEY internally_generated_foreign_key_id You have to use SHOW CREATE TABLE to determine the internally generated foreign key ID when you want to drop a foreign key." Howev

Help:)

2004-01-03 Thread Don Matlock
Hi all, It's great to be able to post here and a privilege. Ok..now that I have warmed you up:)...I have installed Mysql tonight using a fresh install of Debian 3. r2. All went fine till I put in the password for the Mysql..this is what the docs said to put: mysql>SET PASSWORD FOR 'root

New grant tables

2004-01-03 Thread Scott Haneda
I just updated from 3.x to 4.x. I moved my data files from one server to another. Srated mysql, and ran the permissions fixer script, which seemed to have worked just fine. However, I am not sure what it changed, how can I be sure that it did in fact update the tables? -- --

Re: Converting MyISAM to InnoDB type.

2004-01-03 Thread Fred
Hi Matt. Thanks a lot again ! It worked pretty good. There is no problem about the app, because the use of the indexes is in charge of the DBMS (MySQL). The app "doesn't know" about the tables and indexes details. Best Regards, Fred. > Hi Fred, > > Also, you may be able to swap the or

Re: BUG IN MYSQL

2004-01-03 Thread miguel solorzano
At 17:16 3/1/2004 -0700, Richard S. Huntrods wrote: Hi, I also checked this problem with my main database on a Solaris box (4.0.5a), and the problem did not occur. In this case the bug is a Windows MySQL server specific issue. I will upgrade to 4.0.17. Please do, it is the only solution for. --

Re: BUG IN MYSQL

2004-01-03 Thread Jim Richardson
On Sat, Jan 03, 2004 at 04:05:09PM -0700, Richard S. Huntrods wrote: I've submitted this problem three times now, and been ignored all three times. I guess bugs are simply not popular. Since the problem described below is 100% repeatable, I will now escallate it from "problem with delete/insert"

Problem Solved - AND - How to decide when to upgade a production server MySQL

2004-01-03 Thread Richard S. Huntrods
My problem with deletes/inserts corrupting the database table has been resolved. I was using version 4.0.15, and the very bug I experienced was reported for version 4.0.14. As of 4.0.17, it is fixed. Interestingly, the bug does not appear in 4.0.5a on my Solaris box. Which brings me to my more

Re: Alter table and setup Default value

2004-01-03 Thread Matt W
Hi Mike, It's just part of modifying the column to change the DEFAULT value. e.g. you might use this (changes to NOT NULL and DEFAULT value of 'new'): ALTER TABLE table MODIFY type ENUM('new','used') NOT NULL DEFAULT 'new'; Hope that helps. Matt - Original Message - From: "Mike Maps

Re: BUG IN MYSQL

2004-01-03 Thread Richard S. Huntrods
Udo, Thanks - I found the bug in the database. Looks like it's been fixed in 4.0.17 (the bug was reported in 4.0.14 and I'm running 4.0.15). The bug was also not in my Solairs system - using 4.0.5a. Thanks, -Richard Ugo Bellavance wrote: -Message d'origine- De : Richard S. Huntrod

Re: Converting MyISAM to InnoDB type.

2004-01-03 Thread Matt W
Hi Fred, Also, you may be able to swap the order of those columns in the index. I think that would work, but don't know if it would cause other problems -- like for the way your app uses the index, etc. Matt - Original Message - From: "Fred" Sent: Saturday, January 03, 2004 6:11 PM Sub

Re: BUG IN MYSQL

2004-01-03 Thread Richard S. Huntrods
Miguel, miguel solorzano wrote: At 16:05 3/1/2004 -0700, Richard S. Huntrods wrote: I've submitted this problem three times now, and been ignored all three times. Sorry for this inconvenience but I suggest you in the next time to use the MySQL's forums for to report bugs instead of the genera

Re: Converting MyISAM to InnoDB type.

2004-01-03 Thread Fred
Hi Matt and thank you very much Now I get the point I'll have to decide if I maintain these two tables in MyISAM or if I drop the AUTO_INCREMENT and change the source-code in Delphi. It's clear now that the problem is the lack of support of InnoDB. Thanks for your help and regards, Fre

Re: Default DATE field values

2004-01-03 Thread Matt W
Hi Chris, Nope, DEFAULT values have to be constants; no functions or anything. :-/ What are you trying to do? And what's wrong with using TIMESTAMP since you want a default of NOW()? If it's because you don't want it update when you UPDATE the row, you can just set it to its current value, if y

Re: BUG IN MYSQL

2004-01-03 Thread Douglas Sims
I also ran the test, using MySQL 4.0.16, for apple-darwin6.6 (powerpc) on a Mac iBook G4 w/Panther and got no errors from mysqlcheck. You might try using mysqlbug to compose the bug report: http://www.mysql.com/doc/en/Bug_reports.html Hassan Schroeder wrote: Richard S. Huntrods wrote: I've

Re: Converting MyISAM to InnoDB type.

2004-01-03 Thread Matt W
Hi Fred, InnoDB does not support AUTO_INCREMENT on secondary columns of a multi-column index. > `id_registro` int(11) NOT NULL auto_increment, > PRIMARY KEY (`id_formula`,`id_registro`) There: id_registro is the second column of the index. Matt - Original Message - From: "Fred" Se

Re: BUG IN MYSQL

2004-01-03 Thread miguel solorzano
At 16:05 3/1/2004 -0700, Richard S. Huntrods wrote: I've submitted this problem three times now, and been ignored all three times. Sorry for this inconvenience but I suggest you in the next time to use the MySQL's forums for to report bugs instead of the general list:

Alter table and setup Default value

2004-01-03 Thread Mike Mapsnac
I use MYSQL 4. I can modify or alter a column with no problems. But how I can alter table and setup Default value. The column below has default value NULL, but I want to setup default value used. How that's can be done? type | enum('new',used') | YES | | NULL|| __

Re: BUG IN MYSQL

2004-01-03 Thread Hassan Schroeder
Richard S. Huntrods wrote: I've submitted this problem three times now, and been ignored all three times. I guess bugs are simply not popular. Since the problem described below is 100% repeatable, Uh, well, maybe not quite :-) I've distilled the problem I'm having with DELETE/INSERT to an even

RE: BUG IN MYSQL

2004-01-03 Thread Ugo Bellavance
> -Message d'origine- > De : Richard S. Huntrods [mailto:[EMAIL PROTECTED] > Envoyé : Saturday, January 03, 2004 6:05 PM > À : [EMAIL PROTECTED] > Objet : BUG IN MYSQL > > > I've submitted this problem three times now, and been ignored > all three > times. http://bugs.mysql.com/ >

BUG IN MYSQL

2004-01-03 Thread Richard S. Huntrods
I've submitted this problem three times now, and been ignored all three times. I guess bugs are simply not popular. Since the problem described below is 100% repeatable, I will now escallate it from "problem with delete/insert" to "BUG IN MYSQL". Cheers... I've distilled the problem I'm having

Re: FULLTEXT across two tables

2004-01-03 Thread Matt W
Hi Ladd, How about SELECT DISTINCT? Hope that helps. Matt - Original Message - From: "Ladd J. Epp" Sent: Saturday, January 03, 2004 11:39 AM Subject: FULLTEXT across two tables > Hello, > > I would like to do a FULLTEXT search across two tables. I run an artist > website, so I nee

Re: Trouble With Counting New Documents With Complex Query

2004-01-03 Thread Bob Terrell
on 1/2/04 12:59 PM, Adam i Agnieszka Gasiorowski FNORD wrote: Thanks for the info. Just so I'm sure I know what I should: :) 1) You only want the day's articles. These are records in the article table and nowhere else. 2) An article will always belong to at least one section, and may belong to m

LOAD DATA INFILE

2004-01-03 Thread Bill
Hi all I am running a remote web server with MySQL v4.0.12 installed - local infile=1(ON) When I try to upload a file via either a web interface or via phpMyAdmin I still get the error The used command is not allowed with this MySQL version phpMyAdmin generated the following: LOAD DATA LOCAL

Re: MySQL Control Center!!!

2004-01-03 Thread zzapper
On Sat, 3 Jan 2004 09:24:05 -0500, "Kirti S. Bajwa" <[EMAIL PROTECTED]> wrote: >Hello: > >I have been reading MySQL Control Center. There are screen shots but I have >not been able to find documentation. Is the documentation is hidden or not >available? If there is documentation, kindly direct me

MySQL + QuickBooks + OS X ?

2004-01-03 Thread m i l e s
Does anyone know of a way for all three fo these to talk to one another ? -- M i l e s President & Toolbox Architect MagicMiles Software (413) 374 - 5161 PO Box 414, Northampton, MA 01060 http://www.servicetoolbox.com/ http://www.workshoptoolbox.com/ http://www.healingartstoolbox.com/ http://www.ar

re: Japanese in MySQL

2004-01-03 Thread Keitaro
Hi, thank you for your answere. > Is the client application using a unicode font that > supports the characters > you're using? Most fonts only support a subset of > unicode characters. > Are you using MySQL 4.1.1? The failure is not in the client, but the mysql server cannot store the charact

RE: Broadcast to search available MySQL Server in Network?

2004-01-03 Thread Ugo Bellavance
> -Message d'origine- > De : Manfred Süsens [mailto:[EMAIL PROTECTED] > Envoyé : Saturday, January 03, 2004 7:58 AM > À : [EMAIL PROTECTED] > Objet : Re: Broadcast to search available MySQL Server in Network? > > > Yes, I tried to find the port 3306, but MySQL doesn't answer! Maybe it

RE: Perl Modules!!!

2004-01-03 Thread Ugo Bellavance
> -Message d'origine- > De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] > Envoyé : Saturday, January 03, 2004 9:43 AM > À : [EMAIL PROTECTED] > Objet : Perl Modules!!! > > > Hello: > > I need some advise. I am trying to learn and install MySQL, > RH9 distro. My > question is about Pearl

re: Japanese in MySQL

2004-01-03 Thread Jeremy March
I don't know what's wrong from your description, but here are some things to watch out for: Are BOTH the client and server using utf8? Is the client application using a unicode font that supports the characters you're using? Most fonts only support a subset of unicode characters. Are you usin

RE: MySQL Control Center!!!

2004-01-03 Thread Ugo Bellavance
> -Message d'origine- > De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] > Envoyé : Saturday, January 03, 2004 9:24 AM > À : [EMAIL PROTECTED] > Objet : MySQL Control Center!!! > > > Hello: > > I have been reading MySQL Control Center. There are screen > shots but I have > not been able

FULLTEXT across two tables

2004-01-03 Thread Ladd J. Epp
Hello, I would like to do a FULLTEXT search across two tables. I run an artist website, so I need to search across the user list and the users' associated art pieces list. I've come up with this query (fulltext indexes for these precise values have been created on both tables): SELECT * from

Default DATE field values

2004-01-03 Thread Chris Nolan
Hi all, Upon reading the funky manual, I have discovered the following things: 1. TIMESTAMP fields can be set so that their default value is NOW(). 2. DATE and TIMESTAMP fields are related. Given the two above facts, is there a way to set DATE columns so the default value is NOW()? My playing ar

Re: Thinking About Upgrading MySQL, PHP, and phpmyAdmin

2004-01-03 Thread Yves Goergen
Hi, I'd recommend you PHP 4.3.2 or newer, if you're already using 4.3.0. Latest stable should be 4.3.4, see www.php.net . Upgrading is described there, depends on you type of installation (Apache module/CLI/CGI). Latest MySQL of 3.23 series is 3.23.57 or so, don't know exactly, see www.mysql.com .

Re: Trouble With Counting New Documents With Complex Query

2004-01-03 Thread Adam i Agnieszka Gasiorowski FNORD
Bob Terrell wrote: > on 1/2/04 12:59 PM, Adam i Agnieszka Gasiorowski FNORD wrote: > > > Tell me if you need any additional information. > > Thank you for all your help. > > Some additional information would help, yes. What exactly are the sections, for > example? Do you need to know the numbe

Perl Modules!!!

2004-01-03 Thread Kirti S. Bajwa
Hello: I need some advise. I am trying to learn and install MySQL, RH9 distro. My question is about Pearl Modules: 1) Is it common to install Perl Modules? 2) If I do not install Perl Modules now, can I install later on with any big headache? Thanks, Kirti -- MySQL General Mailing List For

MySQL Control Center!!!

2004-01-03 Thread Kirti S. Bajwa
Hello: I have been reading MySQL Control Center. There are screen shots but I have not been able to find documentation. Is the documentation is hidden or not available? If there is documentation, kindly direct me to the URL. Thanks. Kirti -- MySQL General Mailing List For list archives: http:/

Re: Delete logs: not enough space on /var/lib/mysql

2004-01-03 Thread Nitin Mehta
move the data files to another directory (partition) and create symlinks in original directory - Original Message - From: "Mike Mapsnac" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 03, 2004 7:42 PM Subject: Delete logs: not enough space on /var/lib/mysql > I don

Delete logs: not enough space on /var/lib/mysql

2004-01-03 Thread Mike Mapsnac
I don't have enough space on /var/lib/mysql partition. What logs can be deleted from the partition? Is it possible don't delete last logs? Thanks _ Worried about inbox overload? Get MSN Extra Storage now! http://join.msn.com/?PAGE

Thinking About Upgrading MySQL, PHP, and phpmyAdmin

2004-01-03 Thread [EMAIL PROTECTED]
I'm on a Macintosh G3 PowerBook with OS 10.2.1. PHP is version 4.3.0; MySQL, 3.23.53; and phpmyAdmin, 2.4.0. What are the latest available post-beta, stable, fully-baked versions? Is upgrading as big a project as deleting old versions and then reinstalling newer? Or are there instructs for upgradi

Re: Broadcast to search available MySQL Server in Network?

2004-01-03 Thread Manfred Süsens
Yes, I tried to find the port 3306, but MySQL doesn't answer! So, has MySQL a functionality to answer automatically? What is the port number MySQL is listening? What kind of family MySQL use? Do MySQL use UDP protocol? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Japanese in MySQL

2004-01-03 Thread Keitaro
Hi, I am developing a vocabulary trainer. The languages I want to support are German and Japanese. When I try to store Japanese characters in my mysql database, I do not get the correct characters. The entry of the field is "???" instead of the Japanese character. I tried to store the charact

Re: Arbitrary interval for DATE_ADD()

2004-01-03 Thread Aleksandar Bradaric
Hi, > SELECT DATE_ADD(NOW(),tbl_name.interval) AS date > FROM tbl_name; As you know, the syntax is: DATE_ADD(date,INTERVAL expr type) The 'expr' can be a column, but I don't think either 'INERVAL' or 'type' support columns - they are not strings. So, IMHO, this is the closest you can

Arbitrary interval for DATE_ADD()

2004-01-03 Thread Adam Carmichael
Hello List, I'm trying to write a query that will use the DATE_ADD() function, but with a variable interval based upon a database value in similar style SELECT DATE_ADD(NOW(),tbl_name.interval) AS date FROM tbl_name; With the text string 'INTERVAL 1 MONTH' as test data for the interval field, howe

Re: Replicating Table Schema

2004-01-03 Thread Tobias Asplund
On Fri, 2 Jan 2004, Roger Baklund wrote: > * Gohaku > > I was just curious if there's a shorthand way of replicating a Table > > Schema. > > I use the following to create a new Table with the same schema. > > >create table new_table ( select * from table); > > >delete from new_table; > > You can

enable Innodb

2004-01-03 Thread vinay
hi all, HAPPY NEW YEAR I have mysql-3.23.49a installed on my system, which does not provide foreign key support without enabling INNODB which can be done by installing mysql-max binaries so my questions are:- 1:=can any version of mysql-max binaries can help enable INNODB. 2:=After installi