Re: How can I do phpmyadmin/mySQL web based DBase entries/queries?

2003-12-01 Thread Duncan Hill
On Monday 01 December 2003 02:28, [EMAIL PROTECTED] wrote: creating a web-site which has a spot to make a query as well as text boxes to input data into the database. This way I won't have to type all the mysql commands to add new entrys. I already have the mySQL database installed, as well

Out-of-control log file

2003-12-01 Thread Chris Waskowich
One of my server is a slave to another. The slave server's host.err file is getting filled with blocks like this: Status information: Current dir: /usr/local/mysql/var/ Running threads: 0 Stack size: 65536 Current locks: lock: 82268c: key_cache status: blocks used:15 not flushed:

Re[5]: Please analyze my project table design

2003-12-01 Thread Stefan Hinz
% I don't know of a DB theory rule that says it's a bad idea to have the same columns in many tables, but it might make the design more compact to take the common stuff and put it into one table. Oh, there is, indeed. CF normalization :-) Well of course, but that begs the question,

Re: About maxdb

2003-12-01 Thread Thomas Spahni
On Fri, 28 Nov 2003, Lemasson Sylvain wrote: May be this not the good mailing list. I have recently installed maxdb. I have create succefully a database instance but when I try to launch it (admin or onlyne mode) I have a runtime environment error saying I must have a look to the application

Re: About maxdb

2003-12-01 Thread Eduardo Melo
I have an application written in Visual Basic and MS-ACCESS. I want to migrate it to MySQL but MySQL does not support sub sub query. Does the maxdb supports sub query ? best regards, Eduardo F. Melo PRO-IT Serviços em Informática S/C Ltda. Telefone : (19) 3897-5005 Fax : (19) 3909-4566 Resume

error 1045 happened randomly

2003-12-01 Thread Francis Mak
Hi, sorry if this has been answered previously, however I tried to google, I found a few people having this issue, but no solutions provided. I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary, not rpm and not compiled by myself) + REDHAT 9 all I did is: grant all on

Re: Mysql won't start

2003-12-01 Thread Chuck Gadd
Michael Burke wrote: I'm using mysql on redhat 9 and wanted to enable the query log file.I copied one of the example my.cnf files to /etc and added an entry: --log to enable the log file but when I boot red hat I get a message that If you are specifying the option on the command line, then you

Re: error 1045 happened randomly

2003-12-01 Thread Duncan Hill
On Monday 01 December 2003 11:46, Francis Mak wrote: it works successfully, however, sometimes it just give me Error 1045: Access Denied for user '[EMAIL PROTECTED]' it happens RANDOMLY. Could anybody please let me know how to fix this??? Remove the password from the login and

Re: Version 4.1.1

2003-12-01 Thread Egor Egorov
Daniel Kiss [EMAIL PROTECTED] wrote: Does anyone know when MySQL 4.1.1 will be released? I was told that around November 15th. Well, it's almost December now. Soon. Probably this week. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored

RE: error 1045 happened randomly

2003-12-01 Thread Wouter van Vliet
Francis Mak wrote: Hi, sorry if this has been answered previously, however I tried to google, I found a few people having this issue, but no solutions provided. I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary, not rpm and not compiled by myself) + REDHAT 9 all I

RE: error 1045 happened randomly

2003-12-01 Thread Francis Mak
Duncan, thanks for your tips. I will give it a try. so this is a known bug in mysql? and for sure using blank password is not a long term solutions, what if it is a share hosting env.? any answer from mysql team? many thanks. francis On Monday 01 December 2003 11:46, Francis Mak wrote:

RE: error 1045 happened randomly

2003-12-01 Thread Wouter van Vliet
Duncan Hill wrote: On Monday 01 December 2003 11:46, Francis Mak wrote: it works successfully, however, sometimes it just give me Error 1045: Access Denied for user '[EMAIL PROTECTED]' it happens RANDOMLY. Could anybody please let me know how to fix this??? Remove the

Re: error 1045 happened randomly

2003-12-01 Thread Duncan Hill
On Monday 01 December 2003 12:24, Wouter van Vliet wrote: Duncan Hill wrote: Remove the password from the login and the problem appears to go away. I've hammered my test DBs with thousands of serial logins, and the problem only shows when a login has a password. I'm sory, and I don't

RE: error 1045 happened randomly

2003-12-01 Thread Francis Mak
- I am 100% sure that all scripts are using include (db.php); so all pages are using the same login and password and hostname - since I am using password, so it shows Using Password YES as well. - The error indeed occured on the same page. e.g. when you are viewing index.php, it may run

Escaping single quotes

2003-12-01 Thread Matthew Stuart
I am going to take over an existing website and in its present format it is a site powered by an Oracle DB. I will be migrating to MySQL. The site is a news based site and has the use of the single quote or apostrophe (') through most of it's articles. I think that each article at present is

Re: Images in a table

2003-12-01 Thread Peter Burden
Richard Bewley wrote: Yes, you can insert the binary into a table. Richard -Original Message- From: Zenzo [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 1:42 PM To: MySQL List Subject: Images in a table If your application is WWW based I've done some notes for students

RE: error 1045 happened randomly

2003-12-01 Thread Wouter van Vliet
Francis Mak wrote: - I am 100% sure that all scripts are using include (db.php); so all pages are using the same login and password and hostname - since I am using password, so it shows Using Password YES as well. - The error indeed occured on the same page. e.g. when you are viewing

Re[2]: About maxdb

2003-12-01 Thread Stefan Hinz
Eduardo, I have an application written in Visual Basic and MS-ACCESS. I want to migrate it to MySQL but MySQL does not support sub sub query. Does the maxdb supports sub query ? Yes. MySQL also supports subqueries as of 4.1, which will become Alpha very soon.

RE: error 1045 happened randomly

2003-12-01 Thread Francis Mak
ok, I have tried giving a blank password and after 15mins of refreshing(previously it give me error in just around 2-3 mins.) I don't see the Access Denied message anymore. Duncan, Wouter, thanks!! though blank password is not a good solution, but at least it fix the issue. I think I have to

mysqlimport error

2003-12-01 Thread Jay Blanchard
Good morning, We recently put a new server online (FreeBSD) with MySQL version 4.0.15. I have a couple of AWK scripts which used to work properly (on another FreeBSD server with 3.23.n MySQL) with mysqlimport. Now I am getting the following error... /usr/local/bin/mysqlimport: Error: The used

Re: error 1045 happened randomly

2003-12-01 Thread Duncan Hill
On Monday 01 December 2003 12:51, Wouter van Vliet wrote: don't do that on your production server. Or, in my eyes better yet, downgrade to the latest stable verion of MySQL. And compile it yourself, .. always better since it's totally fit for your system then. And there I was, hoping to take

Re: error 1045 happened randomly

2003-12-01 Thread Duncan Hill
On Monday 01 December 2003 13:08, Francis Mak wrote: though blank password is not a good solution, but at least it fix the issue. I think I have to go back to previous version, :( and I am looking forward to use 4.1 stable in my next project, since the full unicode support. does mysql team

Re: Installing MySQL on Fedora

2003-12-01 Thread Egor Egorov
Todd Cary [EMAIL PROTECTED] wrote: I tried installing MySQL on Fedora and all seemed to go fine, but there is no mysqladmin. Have I missed something here? And I am not sure where the mysql executable resides. The version is MySQL-3.23.58-1.i386.rpm You should install client package.

Export in XML

2003-12-01 Thread Todd Cary
Is there a way to export/import MySQL tables in XML format? Todd -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Export in XML

2003-12-01 Thread Jay Blanchard
[snip] Is there a way to export/import MySQL tables in XML format? [/snip] Well Todd, it is a little more complex than this. How much do you know about XML? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Soundex in text searches

2003-12-01 Thread Victoria Reznichenko
Chris Priest [EMAIL PROTECTED] wrote: I am currently looking at trying to port an existing Informix application over to MySQL but I have fallen short on one particular feature. Under Informix using its text datablade, I can have a pattern match on the text search such that '+Tomas' would

Re: Export in XML

2003-12-01 Thread Todd Cary
Jay - I am not an expert with XML, however I use it with Delphi and Delphi's TClientDataset. In this usage, I use the builtin SaveTo and LoadFrom methods. Todd Jay Blanchard wrote: [snip] Is there a way to export/import MySQL tables in XML format? [/snip] Well Todd, it is a little more

Re: Export in XML

2003-12-01 Thread Fagyal, Csongor
Todd Cary wrote: Is there a way to export/import MySQL tables in XML format? trying_to_be what=funny Yep. It's called perl :-)) /trying_to_be Sorry 'bout that... ;-) - Csongor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Export in XML

2003-12-01 Thread Jay Blanchard
[snip] I am not an expert with XML, however I use it with Delphi and Delphi's TClientDataset. In this usage, I use the builtin SaveTo and LoadFrom methods. [snip] Is there a way to export/import MySQL tables in XML format? [/snip] Well Todd, it is a little more complex than this. How much do

RE: Export in XML

2003-12-01 Thread jeffrey_n_Dyke
first part of your questionphpMyAdmin can export in XMLthe less complex peice, in my mind... www.phpmyadmin.net [snip] Is there a way to export/import MySQL tables in XML format? [/snip] Well Todd, it is a little more complex than this. How much do you know about XML? -- MySQL

Two version

2003-12-01 Thread Arnoldus Th.J. Koeleman
I try to run to different version 3.23 4.0 with ome my.cnf file with different mysqld section but Only one is started. Anybody have any idea how to run two versions

RE: Export in XML

2003-12-01 Thread Dan Greene
I think that to answer Todd's question, no there is no inherent way in MySQL to export results as XML the way that sqlserver and oracle do. Another solution that comes to mind (if you're using java) is to write a simple class that converts a result set to an array of hashmaps (row in array is

Re: Images in a table

2003-12-01 Thread Zenzo
I would be pleased. Thanks Glenn Stauffer [EMAIL PROTECTED] wrote: Zenzo wrote: How can I insert images in a table if I can do it with MySQL? __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ I can send you some simple code to do

Re: Version 4.1.1

2003-12-01 Thread Nils Valentin
Hi Dan, for me its already the 2nd of December ;-) here in Tokyo. On Sunday 30 November 2003 22:43, Daniel Kiss wrote: Hi all, Does anyone know when MySQL 4.1.1 will be released? I was told that around November 15th. Well, it's almost December now. Thanks, Dan -- kind regards

Re: Images in a table

2003-12-01 Thread Mickael Bailly
Here is a sample code in PHP: $image = file_get_contents('/tmp/my_image.png'); $res = mysql_query('insert into img_table ( data ) values (\''.addslashes($image).'\')'); Works with a table like: create table img_table (bigint not null auto_increment primary key, data LONGBLOB not null

RE: Export in XML

2003-12-01 Thread John Griffin
Look at http://www.mysql.com/doc/en/mysql.html. The -X option may give you what you need. -Original Message- From: Dan Greene [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 9:57 AM To: Todd Cary; Jay Blanchard Cc: [EMAIL PROTECTED] Subject: RE: Export in XML I think that to

RE: Export in XML

2003-12-01 Thread Dan Greene
The most guarenteed way to have a feature in a product pointed out is to make a public statement that it's not available :) keyboard in mouth, Dan Greene -Original Message- From: John Griffin [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 10:49 AM To: Dan Greene; Todd

Re: Export in XML

2003-12-01 Thread Todd Cary
John - Right under my nose! Thanks Todd John Griffin wrote: Look at http://www.mysql.com/doc/en/mysql.html. The -X option may give you what you need. -Original Message- From: Dan Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, December 01, 2003 9:57 AM To: Todd Cary; Jay

RE: Export in XML

2003-12-01 Thread Jay Blanchard
[snip] The most guarenteed way to have a feature in a product pointed out is to make a public statement that it's not available :) Look at http://www.mysql.com/doc/en/mysql.html. The -X option may give you what you need. [/snip] As always, more than one way to skin a cat. -- MySQL General

Re: Export in XML

2003-12-01 Thread Todd Cary
Dan - Or from my place, "It pays for me to read the docs - thoroughly". Oh! Docs! What are they? :-[ Todd Dan Greene wrote: The most guarenteed way to have a feature in a product pointed out is to make a public statement that it's not available :) keyboard in mouth, Dan Greene

Re: error 1045 happened randomly

2003-12-01 Thread Duncan Hill
On Monday 01 December 2003 11:46, Francis Mak wrote: I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary, not rpm and not compiled by myself) + REDHAT 9 Hmm, I just read this part again.. RedHat 9 is the consistent part between your systems and mine. Wonder if glibc or openssl is at

Re: Export in XML

2003-12-01 Thread Chris Boget
Or from my place, It pays for me to read the docs - thoroughly. Oh! Docs! What are they? :-[ Or just mysqldump --help :p Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql to LaTeX tables

2003-12-01 Thread Xavier Fernández i Marín
Hi, Is there any application to export MySQL results of queries to LaTeX tables? (preferably under GPL) Thanks, Xavier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

datetime ORDER BY is erred

2003-12-01 Thread Elton
I'm using MySQL v4.0.14 that ships with Panther_Server. I have been trying to get it to sort datetime fields properly without success; this is what I get: Is this a known bug? Is there a workaround? Any help would be appreciated. Elton -- MySQL General Mailing List For list archives:

Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
Oops, my pasted graphic did not pass; here is what I get: mysql select date_close,aircraft,route from Avail_Legs Order By date_close; +-+--+---+ | date_close | aircraft | route | +-+--+---+ | 2003-11-01 14:00:00

RE: error 1045 happened randomly

2003-12-01 Thread Francis Mak
um.. I dont know if glibc/openssl will cause the problem. I am not very linux expert here.. but showing you this may help giving out some info? # rpm -qa|grep glibc glibc-devel-2.3.2-11.9 glibc-common-2.3.2-11.9 glibc-2.3.2-11.9 glibc-kernheaders-2.4-8.10 and openssl, I

Formatted index

2003-12-01 Thread Kevin Carlson
Does MySQL support formatted indexes such as in the statement below? alter table DateInfo add index monthYear (DATE_FORMAT(updateDate, '%m/%Y')) If not, does anyone know of any plans to support this in the future? Thanks, Kevin -- MySQL General Mailing List For list archives:

RE: datetime ORDER BY is erred in panther_server

2003-12-01 Thread Daevid Vincent
I'm sure this won't matter, but did you try putting a order by date_close DESC or ASC? Daevid Vincent http://daevid.com -Original Message- From: Elton [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 9:04 AM To: [EMAIL PROTECTED] Subject: Re: datetime ORDER BY is erred

read: Off subject regarding the mysql list!

2003-12-01 Thread karl james
Hey guys, (off Subject) I want all emails that come from mysql list to go into a mysql folder that I have setup for it, but no matter what rule I choose in Microsoft outlook it doesn't work. Can anyone baby step me cause im sure you all do this do to the many emails that we get from the mysql

Re: datetime ORDER BY is erred

2003-12-01 Thread Victoria Reznichenko
Elton [EMAIL PROTECTED] wrote: Oops, my pasted graphic did not pass; here is what I get: mysql select date_close,aircraft,route from Avail_Legs Order By date_close; +-+--+---+ | date_close | aircraft | route |

RE: read: Off subject regarding the mysql list!

2003-12-01 Thread Jay Blanchard
[snip] I want all emails that come from mysql list to go into a mysql folder that I have setup for it, but no matter what rule I choose in Microsoft outlook it doesn't work. [/snip] move messages from [EMAIL PROTECTED] to the MySQL folder -- MySQL General Mailing List For list archives:

Re: Formatted index

2003-12-01 Thread Keith C. Ivey
On 1 Dec 2003 at 13:41, Kevin Carlson wrote: Does MySQL support formatted indexes such as in the statement below? alter table DateInfo add index monthYear (DATE_FORMAT(updateDate, '%m/%Y')) What sort of queries would that help you with? The only thing I can see is if you were trying to

Re: read: Off subject regarding the mysql list!

2003-12-01 Thread Chuck Gadd
karl james wrote: Hey guys, (off Subject) I want all emails that come from mysql list to go into a mysql folder that I have setup for it, but no matter what rule I choose in Microsoft outlook it doesn't work. filter on the TO address. The list does not re-write the FROM address. -- MySQL

RE: read: Off subject regarding the mysql list!

2003-12-01 Thread Bob Loeffler
Hi Karl, I have my rule in Outlook set up as: Apply this rule after the message arrives with lists.mysql.com in the message header move it to the MySQL and PHP folder I hope that helps. Bob Loeffler :) -Original Message- From: karl james [mailto:[EMAIL PROTECTED] Sent: Tuesday,

Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
So, maybe it was a bug that was fixed in 4.0.16; how do I upgrade to v4.0.16? I'm sort of a novice with MySQL and am using what was pre-installed with Apple's Panther_server -- have never installed it myself. Elton On Dec 1, 2003, at 1:18 PM, Victoria Reznichenko wrote: Elton [EMAIL

RE: read: Off subject regarding the mysql list!

2003-12-01 Thread David Brodbeck
-Original Message- From: Bob Loeffler [mailto:[EMAIL PROTECTED] I have my rule in Outlook set up as: Apply this rule after the message arrives with lists.mysql.com in the message header move it to the MySQL and PHP folder I was about to suggest the same thing, except that I'm

Test e-mail: Please disregard

2003-12-01 Thread Bob Loeffler
This is a test e-mail for Karl. Please disregard it. Thanks, Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql error log and syslog

2003-12-01 Thread Tom Kleinpeter
Hello, I have about half a dozen servers running mysql. I'd like to be able to consolidate all of the error logs in one place so that I can just tail -f one log file to watch for any problems. It seems like this would be very easy to do if I could send the error log to syslog, and have the

Threads and signals in MySQL client

2003-12-01 Thread Peter Burden
Hello, I'm working on a multi-threaded application that includes MySQL client functionality in each thread. I'm using libmysqlclient_r and the appropriate init functions etc. The application also uses signals between threads for various purposes and thus manipulates signal masks on

Re: Formatted index

2003-12-01 Thread Kevin Carlson
Keith C. Ivey wrote: On 1 Dec 2003 at 13:41, Kevin Carlson wrote: Does MySQL support formatted indexes such as in the statement below? alter table DateInfo add index monthYear (DATE_FORMAT(updateDate, '%m/%Y')) What sort of queries would that help you with?... This helps with queries

mysqld_multi

2003-12-01 Thread Arnoldus Th.J. Koeleman
I try to set up multiple daemons on the same with different versions and I cant get it working has anybody a example file so I can test if I can get it working. I have attached my file -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Formatted index

2003-12-01 Thread Keith C. Ivey
On 1 Dec 2003 at 16:32, Kevin Carlson wrote: select * from DateInfo where DATE_FORMAT(updateDate, '%m/%Y') = '03/2003' I have an index on the updateDate column but it does not seem to be used since I am altering the value with the DATE_FORMAT function in the where clause. How about

Ignor writes no block them.

2003-12-01 Thread trevor%tribenetwork.com
Greetings, In converting a master into a slave, I would like to IGNORE all writes instead of blocking them. If I block writes with LOCK TABLES then once the server is converted into a slave and the tables are unlocked all of the blocked writes in the interrum period will be

mysql 'start' spawns 10 instances of mysqld

2003-12-01 Thread Scott Stingel
Hi- having a problem with a new installation of MySQL 4 on a Xeon-based system (Tyan S2723), single processor installed. Whenever I start mysql, I then check using ps -ef and find that not only has mysqld_safe started, but in addition I have 10 new 'mysqld' processes. Why are there so many

Table corruption results after using mysqldump --opt

2003-12-01 Thread Jared Klett
hi all, I have MySQL 3.23.58 running on Solaris 9 x86, and it's been working fantastically. I recently added this to a crontab: /usr/local/mysql/bin/mysqldump --all-databases --opt -u jklett /storage/backup/mysql-all-databases.sql 21 And the backup file gets created with the right amount

[Stats] MySQL List: November 2003

2003-12-01 Thread Bill Doerrfeld
- Searchable archives for this list are available at http://www.listsearch.com/mysql.lasso --

Re: Table corruption results after using mysqldump --opt

2003-12-01 Thread Chris Waskowich
On Dec 01, 2003, at 18:00, Jared Klett wrote: b.) Is there a proven way to backup MySQL databases that have to be up and running 24/7/365? Well, I don't know so much about a 'proven' way - but I use replication on another server and it works pretty good for me. When i want to make a static

Re: datetime ORDER BY is erred

2003-12-01 Thread Chris Waskowich
On Dec 01, 2003, at 14:35, Elton wrote: So, maybe it was a bug that was fixed in 4.0.16; how do I upgrade to v4.0.16? I'm sort of a novice with MySQL and am using what was pre-installed with Apple's Panther_server -- have never installed it myself. Elton, I've had some weird issues with the

Re: Images in a table

2003-12-01 Thread colbey
Be warned about hitting the default max_packet_size limitation of mysql which will cause large files to not insert. This link shows another way to overcome that limitation: http://php.dreamwerx.net/forums/viewtopic.php?t=6 On Mon, 1 Dec 2003, Mickael Bailly wrote: Here is a sample code in

Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
I downloaded a the 4.0.16 from mysql.com (a .dmg file), ran the installer on my local 10.3.1 cpu (not the server) -- did not want to mess-up my server. However, I did not compile anything, just ran the install.pkg. Will installer work as a upgrade to my Panther_server's 4.0.14? By the way, I

Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
If I'm installing on Panther_Server, to upgrade 4.0.14, what file is correct: mysql-standard-4.0.16 mysql-standard-4.0.16-apple-darwin6.6-powerpc.tar Elton On Dec 1, 2003, at 5:37 PM, Elton wrote: I downloaded a the 4.0.16 from mysql.com (a .dmg file), ran the installer on my local 10.3.1 cpu

Re: datetime ORDER BY is erred

2003-12-01 Thread Joakim Ryden
On 12/1/03 3:50 PM Elton wrote: If I'm installing on Panther_Server, to upgrade 4.0.14, what file is correct: mysql-standard-4.0.16 mysql-standard-4.0.16-apple-darwin6.6-powerpc.tar Both. The tar file is a tar archive and the pkg file is a Mac OS X pacjage. :) --Jo -- MySQL General Mailing

Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
That's strange. To test my datetime ORDER BY is erred, as mentioned, I only ran the installer for the mysql-standard-4.0.16.dmg; installing it on my OSX_10.3.1 cpu, that had no prior installation -- and its working. The install notes for mysql-standard-4.0.16-apple-darwin6.6-powerpc.tar

Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
Joakim, The mysql-standard-4.0.16.dmg installer release notes says, Beginning with MySQL 4.0.11, you can install MySQL on Mac OS X 10.2 (Jaguar) using a Mac OS X `PKG' binary package instead of the binary tarball distribution. Please note that older versions of Mac OS X (for example, 10.1.x) are

Re: datetime ORDER BY is erred

2003-12-01 Thread Joakim Ryden
On 12/1/03 4:42 PM Elton wrote: Joakim, The mysql-standard-4.0.16.dmg installer release notes says, Beginning with MySQL 4.0.11, you can install MySQL on Mac OS X 10.2 (Jaguar) using a Mac OS X `PKG' binary package instead of the binary tarball distribution. Please note that older versions of

How To Delete A Particular Record From a Table?

2003-12-01 Thread Caroline Jen
Hi, I am new in using database. I have created a table in a MySQL database. I want to delete a record from the members table. The record I want to delete is: user_name=John Smith. I tried: MySQLdelete John Smith from members; it does not work. MySQLdelete username='John Smith' from members;

unixtime update syntax

2003-12-01 Thread Ron McKeever
Hi I have a db that gets data dumped into it. One of the columns gets unix timestamp data utime. I what to covert that into a datetime column so I can utlize indexes and such. But I still what the unixtime to remain. I know I can get the data I want with php or mysql to convert it, but I need

RE: How To Delete A Particular Record From a Table?

2003-12-01 Thread Bob Loeffler
Hi Caroline, The syntax is: delete from table where condition...; So, try this: delete from members where username='John Smith'; When deleting records from a table, always make sure you have a good condition clause, because if you don't have one, or if it's not correct, you could delete

Re: Formatted index

2003-12-01 Thread Kevin Carlson
Keith C. Ivey wrote: On 1 Dec 2003 at 16:32, Kevin Carlson wrote: select * from DateInfo where DATE_FORMAT(updateDate, '%m/%Y') = '03/2003' I have an index on the updateDate column but it does not seem to be used since I am altering the value with the DATE_FORMAT function in the where clause.

Re: Mysql won't start

2003-12-01 Thread Michael Burke
On Mon, 2003-12-01 at 07:00, Chuck Gadd wrote: Michael Burke wrote: I'm using mysql on redhat 9 and wanted to enable the query log file.I copied one of the example my.cnf files to /etc and added an entry: --log to enable the log file but when I boot red hat I get a message that If

Re: datetime ORDER BY is erred

2003-12-01 Thread Elton
Thanks Joakim and to all who have helped me on this topic; all is working properly under 4.0.16. Elton On Dec 1, 2003, at 6:48 PM, Joakim Ryden wrote: On 12/1/03 4:42 PM Elton wrote: Joakim, The mysql-standard-4.0.16.dmg installer release notes says, Beginning with MySQL 4.0.11, you can

read (Off subject Help) ACCESS!!

2003-12-01 Thread karl james
Does anyone use Microsoft access? I need help with creating a query that will delete records, If you can help me please email me directly! Karl James [EMAIL PROTECTED] http://www.theufl.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: mysql 'start' spawns 10 instances of mysqld

2003-12-01 Thread Matt W
Hi Scott, Those aren't processes. There is 1 process with many threads and your system is reporting them as separate processes. :-) Hope that helps. Matt - Original Message - From: Scott Stingel Sent: Monday, December 01, 2003 4:47 PM Subject: mysql 'start' spawns 10 instances of

Re: Mysql won't start

2003-12-01 Thread Chuck Gadd
Michael Burke wrote: InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 031201 20:00:49

Reducing and counting duplicate rows

2003-12-01 Thread Skippy
I must admit I'm pretty stumped here. I'm using MySQL 4.0.12. I have several tables with info, and one which servers as a link between them (has id's that refer the id's in all the others). The info tables hold people(table 1), which get assigned to groups(2) by directives(3) and each time they

Error 2002

2003-12-01 Thread jeepcreep
Just loaded mySQL v4 to LINUX Mandrake v9.2 via RPM. The error 2002 talks of a mysql.sock file. I can't find this file anywhere on my box. Can't figure out why I can't find it as I'm preety sure the install was completed successfully. If I want to rebuild it, though, what's in it? -- MySQL

Re: Error 2002

2003-12-01 Thread Daniel Kasak
jeepcreep wrote: Just loaded mySQL v4 to LINUX Mandrake v9.2 via RPM. The error 2002 talks of a mysql.sock file. I can't find this file anywhere on my box. Can't figure out why I can't find it as I'm preety sure the install was completed successfully. If I want to rebuild it, though, what's in

MySQL Replication Master Not Logging Changes In Binlog?

2003-12-01 Thread Lukas Bradley
(Forgive me if this is a cross post.) The following setup is on MySQL 4.0.16 on Debian LINUX. It appears as if my replication master is not logging changes to any databases. My my.cnf is as follows: [code] server-id = 154 log-bin = /var/log/mysql/mysql-bin.log

Re: Error 2002

2003-12-01 Thread jeepcreep
That is what I did. That's when I get the error 2002 message. Maybe my problem is not with the mysql.sock file but something else. Daniel Kasak [EMAIL PROTECTED] wrote:jeepcreep wrote: Just loaded mySQL v4 to LINUX Mandrake v9.2 via RPM. The error 2002 talks of a mysql.sock file. I can't find

Select Records From the Database

2003-12-01 Thread Caroline Jen
I got null after selecting records from a table in the database. The table is created by me. I know how many records will be selected. Just cannot be null. I cannot help wonder if my SELECT statement is correct - I want records to be selected if user_role is equal to the userrole I supplied

(U) several questions ...

2003-12-01 Thread Johnson, Michael
CLASSIFICATION: UNCLASSIFIED Is there a board / site that has a plethora of MySQL scripts that I can Borrow for my own use ? Is there a site that has all of the error codes listed, the cause and possible solutions to fixing these ? Is there a way to write dynamic SQL in MySQL like we do in