About the source code

2003-05-27 Thread Erming Zheng
I just recently downloaded the source code and compiled it. It worked fine. But I am lost when I tried to read through it. Could anyone give me any explaination of the sttucture of the code. Or any reference about it? Thanks Erming __ Do you Yahoo!? The New Yahoo!

Auto decrement

2003-05-27 Thread Gary Broughton
Does anyone know if there is a way of setting an auto numbered field that starts at say 2,000,000 and decreases by one on each insert? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Recreate index not working.

2003-05-27 Thread Rodrigo Severo
Hi, I have some MyISAM tables that have backups only of the FRM and MYD files (the MYI files are huge). Yesterday I needed to restore some of them. To recreate the indexes I followed the procedures under section 4.4.6.9 How to Repair Tables of MySQL manual. I read and tried everything before

multiple unique updates

2003-05-27 Thread Andrew Hazen
Hi, Does anyone know a way to do multiple unique updates in one query, the way you can in an insert query? I have a table with several thousand records. Periodically every record in this table needs one field to be updated. Slows down the process if each record is updated with a separate

computed columns

2003-05-27 Thread David Shelley
I'm new to mySQL, but like what I see so far. I'm converting several databases from other products to mySQL 4.0.12 for improved speed and reliability. But I'm having trouble with computed columns. I don't see how to define them. Can't find it in the manual.pdf. I need 2 computed columns, 1st

Re: Auto decrement

2003-05-27 Thread Román Sánchez
Does anyone know if there is a way of setting an auto numbered field that starts at say 2,000,000 and decreases by one on each insert? Well, if you know the starting number you can use a normal autoinc field and retrieve the value you want by substracting: 2,000,000 - AutoIncField Regards

Re: How to write this query pls?

2003-05-27 Thread Peter Brawley
Ways around inner select statments Select ID, Sum(CASE WHEN phone.PHN = NULL THEN 1 ELSE 0 END) as PHNCount from person left outer join phone on ID where PHNCount = 0 GROUP BY phone.ID; The alias in the WHERE clause is illegal; it would have to be SELECT persons.ID, Sum( CASE WHEN

RE: How to secure a MySQL database from people with physical acce ss

2003-05-27 Thread David Brodbeck
-Original Message- From: mos [mailto:[EMAIL PROTECTED] I could encrypt certain table fields, but this will make writing the front end a pain because all SQL statements will now need to be changed any time a new column is encrypted. It also won't help you any, because the

How to fill an Blob with binary data

2003-05-27 Thread Thomas Hoelsken
Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Semi-Solved- Mixed up versions!!

2003-05-27 Thread [EMAIL PROTECTED]
Petre Agenbag schrieb: DOH! After some RTFM'ing, which is your 'really_little_part' in the great game called 'open-source' I found that the /etc/my.cnf was holding the info for the data dir and the sock, also, the old mysql client worked fine when using that as it was looking for the sock in the

Re: group by

2003-05-27 Thread Don Read
On 27-May-2003 Jose Miguel Pérez wrote: snip SELECT CASE WHEN age 15 THEN 1 WHEN age BETWEEN 15 AND 29 THEN 2 WHEN age BETWEEN 30 AND 45 THEN 3 WHEN age 45 THEN 4 END AS

Re: How to fill an Blob with binary data

2003-05-27 Thread colbey
Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with

RE: How to fill an Blob with binary data

2003-05-27 Thread Mike Hillyer
I know MySQL CC can place a text or image blob into the database, might be worth a look. Mike Hillyer www.vbmysql.com -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 10:54 AM To: [EMAIL PROTECTED] Subject: How to fill an Blob with binary

RE: How to fill an Blob with binary data

2003-05-27 Thread Thomas Hoelsken
Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 6:56 PM To: [EMAIL PROTECTED]

RE: How to fill an Blob with binary data

2003-05-27 Thread colbey
Mascon can do it .. it's a win32 app.. On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED]

RE: How to fill an Blob with binary data

2003-05-27 Thread Adam Clauss
I am in need of help with the same question (sent late last night, but apparently got passed over). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject:

Re: silly old hostname help?

2003-05-27 Thread Dan Nelson
In the last episode (May 27), [EMAIL PROTECTED] said: Rebuilding my (Mac OS X Server 10.2.x) server and installing MySQL again, I have forgotten how to fix this, which I've seen long ago: %mysql_install_db Sorry, the host 'rogers' could not be looked up. Please configure the 'hostname'

RE: How to fill an Blob with binary data

2003-05-27 Thread Mike Hillyer
Like I said, for Image and text blobs, use MyCC and it should work. Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data I am in need of

RE: How to fill an Blob with binary data

2003-05-27 Thread Keith C. Ivey
On 27 May 2003 at 19:10, Thomas Hoelsken wrote: isn't there any other solution instead of using PHP just for filling an Blob!? Of course there is, but if you need more specifics you need to give us more details. How are you executing your SQL statements? It's just a matter of getting your

RE: How to fill an Blob with binary data

2003-05-27 Thread Thomas Hoelsken
Thanks, FreeMascon is able to do it und it works fine. If anyone knows another solution, I'm interested in! Thomas --- _ / __// __// ___/Thomas Hoelsken [EMAIL PROTECTED] / /_ / __// /_ / IT-Coordinator /___//_/ // Operations Control FRA HE/I

RE: How to fill an Blob with binary data

2003-05-27 Thread Adam Clauss
In my case, its neither. Some random binary data. Could be ANY kind of file... (I'm doing mine programmatically). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:23 PM To: Adam Clauss; [EMAIL PROTECTED]

RE: How to fill an Blob with binary data

2003-05-27 Thread Christensen, Dave
What is the source of the binary data you want to use to fill the blob? -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:23 PM To: Adam Clauss; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Like I said, for Image and

RE: How to fill an Blob with binary data

2003-05-27 Thread Mike Hillyer
In what language? Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:30 AM To: Mike Hillyer; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data In my case, its neither. Some random binary data.

RE: How to fill an Blob with binary data

2003-05-27 Thread Adam Clauss
Copied from my original message: I am writing a database that will contain a blob field for some binary data. My question is, what is the most efficient way to load this binary data in? I could turn it into a string and pass it into an INSERT/UPDATE statement, but I am afraid that problems will

Re: User Variables doesn't work?

2003-05-27 Thread Peter Brawley
Not just MySQLFront. PhpMyAdmin chokes on it, too. - - Original Message - From: ML To: [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 9:08 AM Subject: Re: User Variables doesn't work? You are right, I tried from command line and it works, the problem occurs with MySQL

RE: How to fill an Blob with binary data

2003-05-27 Thread colbey
Depending on size of data there are a few different methods... Just like what most people do.. use plain insert statements with the data properly escaped and shouldn't have any problem going in. Pulling data out is pretty quick .. I can stream binary data out of my mysql storage servers via our

RE: How to fill an Blob with binary data

2003-05-27 Thread Karam Chand
Hello I prefer SQLyog at http://www.webyog.com/sqlyog Its FREE, extremely fast and very easy to use. Runs only on Windows though. Should give a try!!! Karam --- Thomas Hoelsken [EMAIL PROTECTED] wrote: Thanks, FreeMascon is able to do it und it works fine. If anyone knows another solution,

RE: How to fill an Blob with binary data

2003-05-27 Thread Adam Clauss
OK question then - when I use LOAD_FILE, does it automatically put escape characters in front of anything that needs it? I am in development on an SMTP server with an SQL backend rather than simply a filesystem. My concern is regarding file attachments which could be pretty much anything

replication - master and slave on the same computer

2003-05-27 Thread Vico Timmermans
Hi list, I have a question about replication in MySQL. I have mysql 4.0.12 (master and slave) on windows 2000. Can I make master and slave on the same computer? If I have the master on disk c, and the slave on disk d: 1) When do I put the my.ini file of the slave? 2) How can I stop and start the

RE: Catching Exceptions

2003-05-27 Thread Adam Clauss
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 3:16 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Catching Exceptions I noticed that the exceptions were being caught by pointer. I recommend that

Re: User Variables doesn't work?

2003-05-27 Thread Karam Chand
MySQLFront 2.5 had so many bugs that I had to leave it. I prefer SQLyog now. Its FREE !!! and has all the features ( plus some realy cool extra features ). You can try SQLyog at http://www.webyog.com/sqlyog Karam --- Peter Brawley [EMAIL PROTECTED] wrote: Not just MySQLFront. PhpMyAdmin chokes

Re: About the source code

2003-05-27 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 27 May 2003, Erming Zheng wrote: I just recently downloaded the source code and compiled it. It worked fine. But I am lost when I tried to read through it. Could anyone give me any explaination of the sttucture of the code. Or any

RE: replication - master and slave on the same computer

2003-05-27 Thread Dathan Vance Pattishall
You need to start 2 instances of mysqld both on different ports and different datadirs. I recommend reading Paul Dubois MySQL second Edition- The definitive guide to using, programming, and administering mysql 4 databases. He has a section on replication + running multiple instances of mysqld.

Re: replication - master and slave on the same computer

2003-05-27 Thread miguel solórzano
At 17:51 27/5/2003 +0200, Vico Timmermans wrote: Hi, Hi list, I have a question about replication in MySQL. I have mysql 4.0.12 (master and slave) on windows 2000. Can I make master and slave on the same computer? Yes. Assuming that you want the master on drive C and the slave on drive D, the

Re: computed columns

2003-05-27 Thread Jeff Shapiro
On Tue, 27 May 2003 12:18:13 -0400, David Shelley wrote: I'm new to mySQL, but like what I see so far. I'm converting several databases from other products to mySQL 4.0.12 for improved speed and reliability. But I'm having trouble with computed columns. I don't see how to define them. Can't

MySQL Errno: 2013

2003-05-27 Thread Kevin A. Miller
In our production environment, we are receiving sporadic but constant 2013 errors from one of our mysql dbs. The production environment consists of 5 servers running RH 6.2/apache 1.3.27/php 4.0.6, load balanced with a foundry server iron. Each app box queries a central db box, using pconnect,

RE: computed columns

2003-05-27 Thread David Shelley
Actually it's not FileMaker that the old database is in, it's R:Base. I was hoping mySQL supported calculated columns because they're mentioned a couple of times in the manual.pdf for version 4.0.3. Thanks for the suggestion on select concat ... I realize I could do that but I was hoping to make

Mailing Labels from MySQL database on web

2003-05-27 Thread Landy Atkinson
I have a club roster database set up on our web site in which the underlying data is in a MySQL database. I am using PHP to access the data and display it on a web page as a phone list, e-mail list, directory etc. Now what I need it to give the club secretary a way to print mailing labels.

RE: How to secure a MySQL database from people with physical acce ss

2003-05-27 Thread mos
At 02:22 PM 5/27/2003, you wrote: -Original Message- From: mos [mailto:[EMAIL PROTECTED] Correct, which is why I have a means of compressing and *encrypting* the .exe file. I don't understand how this helps... The EXE file has to contain a complete decryption routine or it can't be

RE: How to secure a MySQL database from people with physical acce ss

2003-05-27 Thread mos
At 11:36 AM 5/27/2003, you wrote: -Original Message- From: mos [mailto:[EMAIL PROTECTED] I could encrypt certain table fields, but this will make writing the front end a pain because all SQL statements will now need to be changed any time a new column is encrypted. It also won't

RE: computed columns

2003-05-27 Thread Jeff Shapiro
On Tue, 27 May 2003 15:23:28 -0400, David Shelley wrote: Actually it's not FileMaker that the old database is in, it's R:Base. I haven't heard of R:Base in YEARS. I was hoping mySQL supported calculated columns because they're mentioned a couple of times in the manual.pdf for version 4.0.3.

mysql_fix_privilege_tables behaves odd, explain this

2003-05-27 Thread Scott Haneda
Well this is very interesting At the start of the script they have root_password=$1 host=localhost user=root I added in just below the above echo -- echo $root_password echo -- Then

Re: Mailing Labels from MySQL database on web

2003-05-27 Thread Cal Evans
3 things I can think of. None of them really good. 1: VERY BAD Use PHP to generate VBScript to control MS Word. I've actually done this with Excel and while it works, it's not the best solution. (Not by a long shot) 2: BETTER Use PHP to build a PDF on the server in the proper Avery label

AuthentiX/MySQL/ASP Question

2003-05-27 Thread Reuben Patterson
I'm having trouble pulling a response.redirect to an IP located in a Group table. The user logs in ok, the currentUser variable is dim'ed and stores the data fine. The problem is matching the currentUser to the user.username stored in MySQL, and redirecting to the associated IP from the Group

Re: Practical samples for table types

2003-05-27 Thread Nils Valentin
Dear Edward, Thank you for the reply. I appreciate your informaton. Do you have by chance also any practical samples ? f.e Until which table size might it be better to use f.e MyISAM and when would you use another format (Heap or a TST table ? f.e When you have have mostly read only access

help with load from file

2003-05-27 Thread trogers
Hi, I have a text file where lines look like this: 3 Mac Performa6300CD 338211 LOV 109 \ \ \ 4 Mac G3BT/266350755 LOV 003 \ 9.1 104.103 Except they are not wrapped like in this email! Each column

Re: How to secure a MySQL database from people with physical access

2003-05-27 Thread Joel Rees
I have some doubts on how to secure a MySQL database (MyISAM InnoDb) against people who have physical access to the machine. Here are a few scenarios. 1) Let's say I want to use MySQL with my vertical market software but I don't want the customer to have access to my data outside of my

Re: help with load from file

2003-05-27 Thread Martin Gainty
Ted- check out http://www.mysql.com/doc/en/LOAD_DATA.html (go to mysql prompt and issue command LOAD DATA INFILE) keeping attention to format for INFILE Hth, Martin - Original Message - From: [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 9:25 PM Subject:

Select name, email where birthday = ??

2003-05-27 Thread Scott Haneda
Hello, I have a date field in my database Format is -MM-DD Once a day at 12:01AM a script is going to run that will Select name, email from users where birthday = ?? And the ?? Is where I am stuck, I don¹t care about the year at all, I just need to match on the month and day, how would I do

RE: Select name, email where birthday = ??

2003-05-27 Thread Adam Clauss
Where MONTH(birthday)=MONTH(now()) AND DAYOFMONTH(birthday)=DAYOFMONTH(now()) Adam Clauss [EMAIL PROTECTED] -Original Message- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 9:21 PM To: MySql Subject: Select name, email where birthday = ?? Hello, I

Re: help with load from file

2003-05-27 Thread trogers
I also have it prepared like this: 1,Mac,SE30,314784,LOV,115,,, 2,Mac,Performa6300CD,338211,LOV,109,,, Also, I did have all the \ as \N previously. But what about at the end of lines. What I had with \N wouldn't take so I was hoping someone might out what the error might be coming from by

Re: help with load from file

2003-05-27 Thread trogers
Yes, I simply don't understand this: === LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES

Re: Select name, email where birthday = ??

2003-05-27 Thread Marcel Forget
Try: select name, birthday from atable where month(birthday)=month(now()) and dayofmonth(birthday)=dayofmonth(now()); Marcel - Original Message - From: Scott Haneda [EMAIL PROTECTED] To: MySql [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 10:20 PM Subject: Select name, email where

Re: Practical samples for table types

2003-05-27 Thread Nils Valentin
In the meanwhile I found a bit information which goes into the direction what I look for. http://www.mysql.de/newsletter/2002-12/a91.html www.nusphere.com/products/library/gemini.pdf (page 11) I still would appreciate any feedback or additonal information from experienced MySQL users.

Re: what is the best data format to start with when importing data into mysql?

2003-05-27 Thread James Moe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 27 May 2003 11:17:34 +0200, Emiliano Rustighini wrote: I can ask for the data in any data format, but I would like to get some advice on what is best to ask for. I have found text format to be the most flexible method for transferring

Re: Select statement driving me crazy

2003-05-27 Thread James Moe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 27 May 2003 16:33:45 +0200, Anthony Ward wrote: SELECT userid,subject,date,code FROM testing WHERE userid=testid Use only single quotes. - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP

Big Insert query problem

2003-05-27 Thread Ganbold
Hi, I have FreeBSD 5.1beta with mysql 4.0.13. When I try to insert 18MB data into myisam table using command mysql emls big_query, it says Error 1030 (Got error 12 from table handler). After that myisam table crashes and I have to run mysqlcheck command to fix the index. The query is only