hank you.
Regards,
Rich
At 03:36 PM 12/14/01, sherzodR wrote:
>$dbh->mysql_insertid()
>
>
>
>Rich Duzenbury wrote:
>
> RD: Date: Fri, 14 Dec 2001 14:15:36 -0600
> RD: From: Rich Duzenbury <[EMAIL PROTECTED]>
> RD: To: [EMAIL PROTECTED]
>
Statement handles appear to have an accessor method to return the last
insert id:
$new_id = $sth->insertid;
But I cannot seem to locate one for the database handle. The closest I
have found is the
$new_id = $dbh->{'mysql_insertid'};
In the case of a $dbh->do(...) where there is no statement h
3.23.43
It would be handy to be able to call a mysql built-in as a column
default. The reason this would be handy is that I could then go to my
umpteen tables and just add one column and suddenly I could know who is
changing each record. Otherwise, I have to go to my umpteen x umpteen
inser
I've got the same issue that you do. Here is my thinking thus far:
Say I have a transaction table:
Record_Key
Service_Date
Item_Code
Item_Quantity
I'm considering this structure for the rate table:
Item_Code
Effective_Date
Rate
It's practical from a data entry perspective, but I can't seem to
I don't believe that the table is corrupt, I'm more inclined to believe
your zero theory.
create table crashme (a int(10) not null auto_increment primary key) type=isam;
insert into crashme set a=0; # actually inserts a = 1;
update crashme set a=0 where a = 1;
insert into crashme set a=0; # a
I've recently upgraded from 3.22.32 to 3.23.43 and I'd like to convert my
tables to the MyISAM format.
According to the docs regarding the upgrade
(http://www.mysql.com/doc/U/p/Upgrading-from-3.22.html),
this is the procedure:
ALTER TABLE table_name TYPE=MyISAM
On one of my tables, I receive t
I'm a little fuzzy on this, but I seem to recall that a .forward file can
call a program (perl script?) of your choosing for each mail message. Or,
perhaps procmail can do this task?
Regards,
Rich
At 01:05 PM 9/21/01, Christopher Bergeron wrote:
>Does anyone know of any applications that inse
At 12:33 AM 9/12/01, Eric Frazier wrote:
>You forgot to metion the great new feature becoming available. Secure
>telnet, it never existed before very recently for AS/400.
>Secure huh? Yeah. There are companies making web apps for the AS/400 that
>are advertising that you can use the web and it is
At 10:30 PM 9/11/01, you wrote:
>OK mine are more respected :) j/k another point of view.
Sorry, I didn't understand your comment.
>1st You are assuming this only runs on Intel machines.
> I have MySQL running on a Sun E-4500 (8 x400mhz procs / 8GB RAM) running
>Solaris 8 on a financial inst
I realize my opinion may be unpopular in this forum, however, I have to say
that if it's mission critical, I would want an IBM AS/400. As a
consultant, I work with numerous hospital and health care companies that
each manage tens of gigs of data on their machines. There is very little
unsche
> PHP has built in functions
>that will dump an entire row into an array (this works with CSV and SQL
>databases).well there is my 2 cents worth on PHP+MySQL
Um, not to start a language war, perl also can dump a row into an array, as
well as into a hash so that one can refer to fields by name,
I don't know how small the mysql distro can be made but I'm guessing pretty
small. I see that the mysqld on my box runs about 1.4mb. I have seen
linux setups that can boot entirely from a floppy (so less than 1.44MB) at
http://www2.linuxrouter.org:81/ , perhaps you may also be interested in t
Has anyone ported a MySQL client to IBM AS/400?
I have a customer (on AS/400) that would like to mirror some data to a
MySQL server.
Thank you for any help you can offer.
Regards,
Rich
-
Before posting, please check:
http
Umm, you didn't specify a username or password...you instead passed 'undef'.
This is the connect string I use:
$dbh = DBI->connect( "DBI:mysql:database=$pb_db; host=$pb_server;
port=$pb_port",
$pb_user,
$pb_password,
{Rai
I like MySQL, and I'm fairly new at it, but if I were to need to store and
retrieve tens of Gb's, I would want an IBM AS/400. Base configurations are
quite reliable, and you can easily add RAID and other types of redundant
support, up to and including redundant machines. I work with numerous
Only the first timestamp is updated by MYSQL. Create two timestamp
fields. MySQL will maintain the first one. Set timestamp2 to null when
the record is created.
Regards,
Rich
At 10:54 AM 6/27/01 -0500, Pete Harlan wrote:
>TIMESTAMP is not the solution to his problem; he wants the date to
>
/01 -0500, Rich Duzenbury wrote:
>Someone was asking about GUI's for mysql and I saw a number of
>responses. Unfortunately, in my case, mysql (on *nix) is limited to
>listening to requests only on localhost (security), so I can't use any of
>the windows clients.
>
>Ar
Someone was asking about GUI's for mysql and I saw a number of
responses. Unfortunately, in my case, mysql (on *nix) is limited to
listening to requests only on localhost (security), so I can't use any of
the windows clients.
Are there any gnome front ends to mysql? I'm looking for something
Mysql version 8.0, distrib 3.22.32
select (1 < 5 < 3) = 1
select ((1<5) < 3) = 1
select (1< (5 < 3)) = 0
In this version, apparently left to right.
Regards,
Rich
At 05:16 PM 6/14/01 +0100, Jon Haworth wrote:
> > And why do you think it should return 0 ?
> >
> > ( 1 < 5 ) returns 1.
> > ( 1 < 3
Ver 8.0, Distrib 3.22.32
I have a customer file, keyed by an auto-increment customer
number. Customers can have orders. The order file is keyed by an
auto-increment order sequence number, which works fine, but is not
convenient. Rather, I would like the order sequence number to start at 1
Ver 8.0, Distrib 3.22.32.
I have two fields in a table that are TIMESTAMP fields. I'd like to show
the amount of elapsed time between the two timestamps in a human readable
format. For example, I'd like to print 'Elapsed time: 1 year 4 months 27
days 9 hours 13 minutes 42 seconds. ' Or perh
21 matches
Mail list logo
