Does any one know if mySQL has a way of accessing when a record was last
updated?
Jeff
Alta Host - Web Site Hosting Solutions-
http://www.altahost.com
760-726-4863
-
Before posting, please check:
I am a MySQL novice, so there may be a simple explanation for this. But I
have been unable to find one in the list archives, although several people
seem to have had similar problems.
I am running MySQL 3.23.36 from the package that comes with Mandrake linux
8.0. I am using linux software-RAID
cs: ~/personal mail [EMAIL PROTECTED]
Subject: automatic roll-back
I am using BDB tables as offered by MySQL version 3.23.43-max.
My question is related to aborting transactions.
I am implementing a global transaction manager and using
several MySQL engines. Suppose the GTM fails, what happens
Howdy,
I'm running MySQL 3.23.43 on Redhat 7.1 and an older version of MySQL
3.22.something on Redhat 6.2. Download and install from the RPM's and it
works like a charm. I have never had a problem.
One day when it is working a little harder, I shall look at recompiling to
optimise, but so far,
ALTER TABLE Customers RENAME Customer_Table;
-Original Message-
From: TOMASSONI Dominique [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 23, 2001 7:48 PM
To: 'MySQL_mailing_list'
Subject: Rename a database
Hello the list,
Is it possible to change the name of a database ? And if it
At 10:14 PM -0600 11/23/01, Mike(mickalo)Blezien wrote:
Hello all,
I'm a bit confused. Does the Mysql-Max only come with BDB/Innodb
support or does
both the Mysql and Mysql-Max binaries both support transactions??
Max only.
thx's
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
MySQL has been updated:
Windows: http://fileforum.betanews.com/detail.php3?fid=967965401
Linux: http://fileforum.betanews.com/detail.php3?fid=974952174
FreeBSD: http://fileforum.betanews.com/detail.php3?fid=974952321
Thanks
Eddie Elmore
[EMAIL PROTECTED]
http://www.betanews.com
What is the semantics of passing a NULL mysql connection to
mysql_real_connect()? Does it create a new handler? This is the only
possible interpretation of the result value as documented. However it is
also (abundantly) documented that the handle must be created with
mysql_init(). So what stands?
Hi All,
Is there any way to modify the date format used by MyODBC when
returning dates? By example, I have a field in the database with the
value 2001-11-01 (this is Nov. 1st, 2001).
When I read it in my VB program I get the next date 11/1/2001; this
is because the computer date format
On Fri, 23 Nov 2001 23:46:40 -0600, Paul DuBois [EMAIL PROTECTED] wrote:
At 10:14 PM -0600 11/23/01, Mike(mickalo)Blezien wrote:
Hello all,
I'm a bit confused. Does the Mysql-Max only come with BDB/Innodb
support or does
both the Mysql and Mysql-Max binaries both support transactions??
Max
I recently downloaded both versions of mysql and would like to run both on
my computer at once for comparison purposes. My question is can I do this
using both winmysqladmin's. It seems that both products attempt to
overwrite the my.cnf file in C:\Windows, and I was wondering if there is
Hi Rick!
I see the msg about the configure adjustment in the next release but until
then I have a hack fix at the bottom of this message. Requires no
configure -switches, just add one line to configure.
On Sat, 24 Nov 2001, Rick Stones wrote:
Description:
If you build the 4.0.0. system
we used to setup a linux system as a share internet connection server with
28 client. the configuration of server is :
PII-233
128MB Ram
3.2GB HDD
server is running RedHat Linux 7.1 with Squid as proxy ,MySQL, Java J2SDK
1.4, Jakarta-Tomcat for our web application.
Best Regard !
Trong Phuc
-
Ok so I'm using Win98, and with this all I do to rename a database is go
into the MySQL folder then into Data folder and there you have all your
databases in their own folders, and then to change the database name just
change the folders name. It works for me. I have no idea how it's done in
At 15:34 -0500 2001/11/24, Barbara Ferrell wrote:
it is a primary key..i did not assign either NULL or NOT NULL when i created
it. i tried all kinds of commands in the MYSQL books.. i am in Linux...
Try the most excellent documentation, either online at www.mysql.com or the one that
came with
Hi all,
Is there anyway to delete the duplicate records in mysql
without creating new tables. I am wondering what query
will achieve this task where mysql doesnt supports like ROWID and
sub queries.
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_8_0
/ Carsten
--
Carsten H. Pedersen
keeper
For the questions...
cut
select tekst || tekst2 total from table;
should return a virtual column called total with as value
testtest
it returns a virtual column called total alright on it's value is 0
I also tried this with + instead of || in oracle this should give
an error
since it
Hi!
I haven't understood the syntax of LOAD DATA fully. (Though i have read the manual:)
I do have a csv-file with
;
as field-seperator.
When saving my excel-table as csv excel includes field which contain ; as content in
for example:
blabla;blabla;asdf;sdfg;34;blablabla
How to use the LOAD
On Sat, 24 Nov 2001, Vic wrote:
#!/usr/bin/perl -w
use CGI::Carp qw(fatalsToBrowser);
use CGI;
use DBI; # Version 1.20
use DBD::mysql; # Version 2.09
$q = new CGI;
$first = $q-param('first');
$last = $q-param('last');
print Content-type: text/html\n\n ;
$dbh =
it is a primary key..i did not assign either NULL or NOT NULL when i created
it. i tried all kinds of commands in the MYSQL books.. i am in Linux...
- Original Message -
From: [EMAIL PROTECTED]
To: Barbara Ferrell [EMAIL PROTECTED]
Sent: Saturday, November 24, 2001 2:02 PM
Subject: Re:
Hi,
I am new to MySQL. I installed it on Win 98 and trying
to invoke the mysqld. First it gave me a strange error
that innodb_data_file_path is not found. I copied the
following from manual (I dont really want to create
such 2GB files though !).
Hi!
I haven't understood the syntax of LOAD DATA fully. (Though i have read the manual:)
I do have a csv-file with
;
as field-seperator.
When saving my excel-table as csv excel includes field which contain ; as content in
for example:
blabla;blabla;asdf;sdfg;34;blablabla
How to use the LOAD
System: FreeBSD 4.2
MySQL 3.23.44 binary dist.
PHP: 4.0.6 compiled from source using --with-mysql
Had a request for a game server. Put it up. Now someone said stats is a
useful feature too. Hmm had box with some spare cycles.
Stats program requires mySQL and PHP. I'm running mySQL on a BSD/OS
Hi,
Please, how do i correct wrong column name (field name, not one of values
stored under the column name) in a table in mysql?
I supposed to type password when i was creating the as field but end up
typed passwod.
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_26_0
/ Carsten
--
Carsten
i'd like to connect to mysql sgdb but not by a specific database, only
the sgdb, using java to send the command show database and them afther
that select a database listed and connect to that database.
i tried jdbc:mysql://localhost:3306
i tried jdbc:mysql://localhost:3306/
but those have not
At 10:38 AM + 11/23/01, [EMAIL PROTECTED] wrote:
Description:
Say we have column named id int NOT NULL AUTO_INCREMENT
Say we have record, where id=0 (why not?)
Because AUTO_INCREMENT columns are for storing sequences of postive numbers.
Not negative numbers, and not zero.
Your
Hello Ravi,
Well, in the ./configure script, when I tried using just the
--with-mysql argument (without any argument like =/usr/local/mysql),
the configure script gave me this warning:
++
|*** WARNING
27 matches
Mail list logo