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 tabl
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
posi
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 d
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 passwor
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, bu
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, 2
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) {
$MY
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 vers
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.
-
[root@b
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 exce
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:
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 OK
* 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 wou
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. H
Satish,
Friday, July 05, 2002, 9:26:23 PM, you wrote:
SS> I am a newbie to MySQL administratation. I just
SS> setup MySQL in my linux machine and want to change the
SS> data directory from /var/lib/mysql to something else.
SS> I put the .my.cnf file in the /etc/ directory and
SS> specified th
Son,
Saturday, July 06, 2002, 11:12:17 AM, you wrote:
SN>I got a problem with the Installation in LINUX, too.
SN>I 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 MySQL-
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 4.0
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 da
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 NOT
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
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 PASSWO
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 PASSWO
22 matches
Mail list logo
