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
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
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
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
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.
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
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
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.
* 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
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
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:
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
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.
-
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
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) {
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
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
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
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
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
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;
21 matches
Mail list logo