Re: About installation on Linux

2002-07-06 Thread Son Nguyen
I got a problem with the Installation in LINUX, too. I download the MySQL 4.0.1Server (i386) (7M) in http://www.mysql.com/ and use root access to install mysql database with the command: shell = rpm -i MySQL-4.0.1-2.i386.rpm And I saw the message: PLEASE REMEMBER TO SET A

Re: About installation on Linux

2002-07-06 Thread Son Nguyen
I got a problem with the Installation in LINUX, too. I download the MySQL 4.0.1Server (i386) (7M) in http://www.mysql.com/ and use root access to install mysql database with the command: shell = rpm -i MySQL-4.0.1-2.i386.rpm And I saw the message: PLEASE REMEMBER TO SET A

encrypting password fields

2002-07-06 Thread Ki Mien
Hi mySql gurus, I have a table that contains my customers username and password. I would like to know how I can encrypt these values so that they are not stored how in the way that my customers have keyed them from the front end. I have read the documentation on password(), and encrypt but it

mysqldump

2002-07-06 Thread Papa Carlo
Hello , VERSION 3.23.49 mysqldump incorrectly export char/varchar binary and *BLOB fields. it export binary fields like text strings example : CREATE TABLE users ( US_ID int(10) unsigned NOT NULL auto_increment, USERNAME varchar(16) NOT NULL default '', US_ACTIVE tinyint(3) unsigned

Re: Access denied error

2002-07-06 Thread Egor Egorov
VINOD, Saturday, July 06, 2002, 6:49:50 AM, you wrote: V I own a domain with MySQL support. I have created a database V \lnet_cal\ on the web and also table \yarntype\, using PHP Myad- V min on the webspace and also granted all access privileges to V user \lnet_root\ to the database.

Re: Re: Re: Re: Temporary Table

2002-07-06 Thread Egor Egorov
Ruda, Friday, July 05, 2002, 7:55:51 PM, you wrote: RG Forgive me the wrong addressing - I didn't observed RG that. RG Yes I used same connection all the time. I am a RG SQL-newbee and I suspect that the problem is the RG installation or configuration. RG I use Windows 2000 Pro, MySQL

Re: Re: About installation on Linux

2002-07-06 Thread Victoria Reznichenko
Son, Saturday, July 06, 2002, 11:12:17 AM, you wrote: SNI got a problem with the Installation in LINUX, too. SNI download the MySQL 4.0.1Server (i386) (7M) in SN http://www.mysql.com/ SN and use root access to install mysql database with the command: SN shell = rpm -i

newbie mysql-SQL question

2002-07-06 Thread Laszlo G. Szijarto
Thank you in advance for your help. I'm trying to run two tables with identical table structures into a single continuous resultset. To simpify, I have one table with columns ID int and NAME varchar(32) and another table2 with columsn ID int and NAME varchar(32), and each table has 100 items.

Re: newbie mysql-SQL question

2002-07-06 Thread Roger Baklund
* Laszlo G. Szijarto I'm trying to run two tables with identical table structures into a single continuous resultset. To simpify, I have one table with columns ID int and NAME varchar(32) and another table2 with columsn ID int and NAME varchar(32), and each table has 100 items. How would I

Re: Re: Re: Re: Temporary Table

2002-07-06 Thread Ruda Gossen
Thanks Egor, but the table names in the example are already lower case and I pasted them in SQL window of the client. Since yesterday I have test to type the script manually at the prompt in a DOS-window and then all worked well. Trying to do the same in the SQL-window of MySQL-Front all was

Re: Re: Re: Re: Temporary Table

2002-07-06 Thread Keith Yoder
I, too, have been unable to get temporary tables to work from MYsql-FRONT. They work every other way I try them (command line, delphi zeos component, etc). - Original Message - From: Ruda Gossen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, July 06, 2002 10:18 AM Subject: Re:

Re: excel spreadsheet to mysql

2002-07-06 Thread Keith Yoder
You could save it as a cvs file and inport it using LOAD DATA INFILE - Original Message - From: chris ochap [EMAIL PROTECTED] To: Mailing List MySQL [EMAIL PROTECTED] Sent: Friday, July 05, 2002 6:26 PM Subject: excel spreadsheet to mysql is there a way to import a large excel

Need help on Matching MySQL, Apache PHP

2002-07-06 Thread duo fu
Dear Friends: I have installed Apache 1.3.26, MySQL.3.23.51 successfully. However, I failed to install tarball versions of PHP4.21 with Apache1.3.26 under my REDHAT 6.2. I always got the error message when I tried to start the APache. -

Re: Need help on Matching MySQL, Apache PHP

2002-07-06 Thread dan radom
I would suggest you build apache and php from source. instructions can be found at http://www.php.net/manual/en/install.apache.php. dan * duo fu ([EMAIL PROTECTED]) wrote: Dear Friends: I have installed Apache 1.3.26, MySQL.3.23.51 successfully. However, I failed to install tarball

Mysql_connect problem

2002-07-06 Thread Christopher Moreno
I'm having a problem with mysql_connect(). Here is the code I am using: function db_connect() { global $dbhost, $dbusername, $dbuserpassword, $default_dbname; global $MYSQL_ERRNO, $MYSQL_ERROR; $link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword); if(!$link_id) {

Re: encrypting password fields

2002-07-06 Thread MikeParton
I have MySQL 2.0.39 on Win NT and I use md5() to create a digest of the password. Perhaps not the highest level of password encryption, but works for the level of security I need. - Original Message - From: Ki Mien [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, July 06, 2002

impossible WHERE noticed after reading const table

2002-07-06 Thread Mike
If I do a SELECT * from TABLE I get all the records in the DB (as it should) If I do a SELECT id from TABLE all the id's in the table are retrieved except id's 113-119 for some reason To use record 117 as an example: If I do a SELECT * from TABLE WHERE id=117 it returns no records, but

Re: encrypting password fields

2002-07-06 Thread MikeParton
oopsthat's my Apache version. I am using MySQL 4.0.1 and have used md5() with MySQL 3.23.49-max-nt - Original Message - From: MikeParton [EMAIL PROTECTED] To: Ki Mien [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, July 06, 2002 3:02 PM Subject: Re: encrypting password fields

BLOB insert problem used ' '

2002-07-06 Thread Mark Worsdall
Hi, After a good old slurp of an image I am trying to stick it into my table. # Slurp file foreach (@image_list) { my $image = /usr/home/shadow/Vision/$_; # Load image into memory my $imagePIC = do { local ($/, *PIC); # slurp mode, local file handle open PIC, $image or die

Easy Auto-Increment

2002-07-06 Thread Brad W. Galiette
Is there any easy way to create a column in a MySQL table which automatically increments with each successive INSERT request? (I understand that AUTO_INCREMENT inserts a value that is one greater than the greatest that already exists in the table; however, this creates a problem --- from the

Re: Easy Auto-Increment

2002-07-06 Thread Paul DuBois
At 22:59 -0400 7/6/02, Brad W. Galiette wrote: Is there any easy way to create a column in a MySQL table which automatically increments with each successive INSERT request? (I understand that AUTO_INCREMENT inserts a value that is one greater than the greatest that already exists in the table;