mysql select date_format(now(),'%m-%d%-%y
%h:%i:%s') AS time;
+---+
|
time
|
+---+
| 11-11-11 11:11:11 |
+---+
1 row in set (0.00 sec)
in your code, you can define ranges of say if the model year being
looked for is 2002, then present model years 2000 thru 2004.
--Curtis
blackwater dev wrote:
Thanks but doing it in code would require me to pull in the entire car table
and process it. With potentially tons of rows, seems
I think what's really being sought after, here is clustering.
--C
Eric Bergen wrote:
Dual master replication can be either dual master dual write or dual
master single writer. The latter is preferred. In this configuration
replication is connected in both directions but clients only ever
I figure that they'll either kill mysql or they'll limit the commnunity
version in ways that will make you purchase a commercial version if you
want to continue to use it. I figure there will be heavy migrations to
open source alternatives.
--C
Andy Shellam wrote:
I've just been made aware
http://www.mydigitallife.info/2007/04/23/remove-or-trim-first-or-last-few-characters-in-mysql-database-with-sql/
Richard Reina wrote:
Hello All,
I can't get trim to trim the blank space from a TEXT field in the query below
and was wondering if someone could tell what I am doing wrong?
SELECT
You're looking for something like:
This gets called 10 times from another function, but this is sort of
what you're looking for. This gives me a combo-box.
function qselect($mysql_link, $i)
{
$driverquery = select car_no, drv_name from cars order by car_no
+ 0;
$driverresult =
or as the docs read:
shell mysqladmin password your password
John Daisley wrote:
The root Password will be blank after initial install.
You can set it at a shell prompt with commands something like this...
shell mysql -u root
mysql SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
I'm not plugging the product, but I just ran into this:
http://www.dbconvert.com/product.php
It's $79.00.
--Curtis
Dan Nelson wrote:
In the last episode (Dec 29), mos said:
Someone has given me an Access 2007 file *.ACCDB and I don't have Access
2007. Is there a (preferably free) way to
I've been having the same trouble in a Xen virtual machine. After about
an hour and a half, mysql will be consuming 100% of cpu. There is
nothing wrong with the tables. I'm assuming its a dynamic vs. fix
amount of memory available to mysql. I'm guaranteed x amount of ram,
but that might
You need the mdac components. free download from MS.
Sivasakthi wrote:
Hi all,
I have tried to import the excel to db , but i get the following error,
The OLE DB provider Microsoft.Jet.OLEDB.4.0 has not been registered.
how can i install the Microsoft.Jet?
System Info:
OS Name Microsoft(R)
Its mainly because it was purchased by Oracle. BDB provided transaction
support. Innodb has been the defacto choice for a ACID transactions,
but Innodb was also purchased by Oracle in its attempt to kill MySQL
after its failed attempt to purchase MySQL. That's why MySQL has been
working
I cannot. Are you trying to connect via the localhost. It may still be
trying to connect to localhost.
You might try changing the bind-address statement to
bind-address = 0.0.0.0 so that it also listens to localhost as well.
Also if you're trying to connect to an ip address instead
I just checked my ubuntu config and I have:
Port = 3306
Bind-address = 0.0.0.0
Pid-file = /var/run/mysqld/mysqld.pid
Socket = /var/run/mysqld/mysqld.sock
Nothig is in upper case. My phone is doing that for me.
-Original Message-
From: Jesse [EMAIL PROTECTED]
To: Curtis Maurand [EMAIL
grant all on *.* to root@'%.def.com'; /* The percent sign is your
wildcard character. */
flush privileges;
I don't think you need to flush privileges as of 5.0. I still do just
to be sure.
Curtis
[EMAIL PROTECTED] wrote:
Hi Parikh,
Yes.. It worked with IP i.e when I granted privileges
two different sets of client libs.
Unless you're telling me that having them use the 5.0 client libraries
won't break working 3.23 apps...
On Wed, 2 Jul 2008, Curtis Maurand wrote:
Did you rebuild php against the 5.0 libraries as I suggested
yesterday? If you didn't it will only recognize
Did you rebuild php against the 5.0 libraries as I suggested yesterday?
If you didn't it will only recognize the 3.23 version. It will not be
able to talk to the 5.0 version.
Curtis
[EMAIL PROTECTED] wrote:
It would appear that the problem isn't getting MySQL 3.23 and 5.0 to
run on the
://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Curtis
Maurand
Head Honcho
Xyonet Hosting Services
Biddeford, ME
04005
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
I think this question has been asked, but I have not yet found an answer
to the problem.
I'm running MySQL 5.0.22 on Gentoo Linux AMD 64. Its blazingly fast,
mostly. I'm running a package called dbmail on it.
http://www.dbmail.org. All mail is stored in the database. After running
a
http://www.oracle.com/innodb/index.html
Riemer Palstra wrote:
On Thu, Nov 09, 2006 at 09:26:52AM -0800, Bill MacAllister wrote:
What happened to the Innodb web pages? What comes up for be is a
search page with a bunch of related links on it. I wanted to pull
down a copy of ibbackup
absolutely no interest in helping MySQL survive.
Sounds pretty fishy to me no matter what they're saying publicly.
Curtis
Bill MacAllister wrote:
--On Friday, November 10, 2006 08:46:50 AM -0500 Curtis Maurand
[EMAIL PROTECTED] wrote:
http://www.oracle.com/innodb/index.html
Please quit
I just checked it again and its working.
Francesco Riosa wrote:
Heikki Tuuri ha scritto:
Bill,
we are moving the DNS of innodb.com from Capnova to Oracle Corp.
I can now view http://www.innodb.com through my ISP, Elisa. Does
anyone still have problems accessing http://www.innodb.com?
If
'TEMPORARY TABLES'
permission that would allow one to create, insert, delete from and
drop temporary tables without having to give up insert/update/delete
privileges on the real tables
/QUOTE
Dan
On 8/15/06, Curtis Maurand [EMAIL PROTECTED] wrote:
here is what I get. I'm logged in as the user
This may sound like a stupid question, but I have to ask. I've been
running a script that goes like the following.
use ecommerce;
create temporary table customer_tmp as select * from customer limit 0;
load data infile '/home/bluetarp/ezauth/customers.txt' into table
\customer_tmp;
at which
' into table
customer_tmp;
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using
password: YES)
Dan Buettner wrote:
Or possibly that the mysql user on the box does not have access to the
data file in question. Can you post the error messages you get?
Dan
On 8/15/06, Curtis
and
drop temporary tables without having to give up insert/update/delete
privileges on the real tables
/QUOTE
Dan
On 8/15/06, Curtis Maurand [EMAIL PROTECTED] wrote:
here is what I get. I'm logged in as the user admin (really a regular
user.)
mysql create temporary table customer_tmp
select criteria into outfile name of output file
The path for the output file must be writeable by the user underwhich
mysql is running.
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
On Fri, 24 Mar 2006, Pure Web Solution wrote:
you can manipulate mysqldump using
mysqladmin -u root password new password
Curtis
sheeri kritzer wrote:
Hi Alaister,
Your root password is not actually set. If you do
mysql -u root -ppassword
and it fails, it means that the password is not password
if you do
mysql -u root password
the mysql client will parse
of software. Server 2K3 has been much more
stable than Windows NT and its security is better, but still not great.
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
go to
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/information/
benchmark-results/result-mysql-platform
While you're at it, take a look at Gentoo Linux
(http://www.gentoo.org). I've been having very good luck with it on
everything from a Duron 1GHz to Opterons. Very responsive. It compiled
a kernel on an opteron in about 5 minutes.
Curtis
Atle Veka wrote:
Excellent, I'll be waiting to see
the socket file is created in the spot specified in /etc/mysql/my.cnf.
In my case its:
socket = /var/run/mysqld/mysqld.sock
as always ymmv.
Curtis
ganesan malairaja wrote:
is it possible a firewall is denying mysql to create the mysql.sock file
if not where i can get this file
Using ODBC, however, you can link Access tables to MySQL tables and use
Access as the front end to MySQL. It works very nicely.
Curtis
Martijn Tonies said:
Alternatively you could use OpenOffice.org
(http://www.openoffice.org/)
which has built in MySQL support.
Alternatively, you
There are several PHP scripts that develop graphs. You'll have do some
work to feed the data to them, but I found them at:
http://www.hotscripts.com/PHP/Scripts_and Programs/Graphs_and_Charts/
Curtis
Jim wrote:
Jason Martin wrote:
Does anyone know of a web-based tool that will let you graph
Use the ODBC connector and write it in VB.
Curtis
Chris Mason wrote:
I have a mysql database runing on an internal linux server and I need to
connect to it with an appliication running on a windows workstation. The
application must start another application with command line informaiton
from the
If you follow the instructions properly, you can get the ISAPI version
of PHP to run and it it runs pretty well once installed.
Curtis
Don Stefani wrote:
GH wrote:
I am using IIS :(
On Windows... Which do i install first? PHP or MySQL?
Apache. :)
If your just working on a local dev
I didn't, but I'll give it a shot and see what happens.
Curtis
Michael J. Pawlowsky wrote:
Curtis Maurand wrote:
If I create one of the databases and then put the files for that
database from the old installation in place of the newly created
ones, the database is recognized, but i get errors
OK, now I really feel stupid. It helps to change the ownership of the
files to mysql:mysqlduh.
Curtis
Curtis Maurand wrote:
I didn't, but I'll give it a shot and see what happens.
Curtis
Michael J. Pawlowsky wrote:
Curtis Maurand wrote:
If I create one of the databases and then put
Hi,
I have done an incredibly stupid thing. I have a server that suffered
a bit of a failure. It wasn't a hard failure, but it was enough of one
to have to rebuild the server from scratch. I was and am running mysql
4.0.22 on Gentoo with a 2.6 kernel. It rocks. However, The dumb thing
Jay Blanchard wrote:
[snip]
I would like to migrate my MySQL servers from 4.0 to 4.1.
As I use PHP as well as Java with these servers I wonder what PHP 4
version would
be compatible with MySQL 4.1.
Has anyone used MySQL 4.1 with PHP yet?
[/snip]
PHP 4 is compatible with MySQL 4.1. My caution to
You have to rebuild PHP against the new MySQL libraries.
Curtis
Greg Donald said:
On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth)
[EMAIL PROTECTED] wrote:
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest as
I think that I'd look at postfix and dbmail. Postfix and dbmail both
allow userdata to be stored in MySQL databases. dbmail will also put the
message store in a mysql database. Very nice, very fast. RH9 has hit
eol. Gentoo rocks.
Curtis
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http
Reiser is good for lots of small files. ext3 would is better for
large ones. At least that's what I get from the benchmark data that I've
seen posted in various places.
Curtis
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
On Wed, 12 May 2004, Roy Butler wrote:
Jacob,
I'd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
'%1234%' ORDER BY
last_name LIMIT 0,10;
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
thing I miss from SQL
Server.
Thanks in advance for any help.
Todd Hackathorn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED
with mysql but I don't think i'd
trust it for anything critical unless you very confident your developers know what
they are doing.
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I know, I get it, I was trying for humor.
Curtis
On Wed, 3 Mar 2004, Michael Stassen wrote:
Curtis Maurand wrote:
:-)
someflag enum('TRUE','FALSE');
Not quite boolean, but it works.
Curtis
On Wed, 3 Mar 2004, Mark Warner wrote:
The thing which bothers me most
rpm -e package
Curtis
On Tue, 2 Mar 2004, Rafael Diaz Valdes wrote:
Please how can I remove a RPM installation. I used MySQL-server-4.1.1-1.i386.rpm to
install MySQL, but how can I delete it.
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General
are not
allowed to approve postings', Port: 119, Secure(SSL): No, Server Error:
441, Error Number: 0x800CCCA9
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Coordinator
PT Bina San Prima,
www.binasanprima.com
http://gtw.binasanprima.com/~leo
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that might be added
to MySQL in future or am I totally overestimating the expense of using
one thread per connection?
Regards,
Chris
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
a Windows machine using ODBC.
Any ideas on what I have not done, or what I have done wrong?
eric
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
|
Now i want to be able to search for (sorted by date):
Owg abzu lap
or
082 abzu_via 2003
or
Owg-08299-abzu_via.lap-2003
or
Owg 08299 abzu via lap 2003
or
99-abzu
Anyone can help me?
Thanks Chris
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
select last_insert_id();
or in php use the mysql_insert_id() eg:
$somevalue = mysql_insert_id();
print (The last auto incremented number was: $somevaluebr\n);
Cheers
Curtis
Paul Fine said:
Greetinsg.
If I have a table like with a column being the PK for the table and
being an Auto
Matthew Stanfield said:
Hi,
Usually, i'll use enum('0','1') in place of a boolean type.
Curtis
[snip]
well. The only annoying thing I can think of, from a programming
perspective, is MySQL's lack of a Boolean type - the manual says use
TINYINT(1) which works fine but is slightly
Business
-Original Message-
From: Curtis Maurand [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 1:44 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: remote connection
Its a permissions thing on the server end. You have to have set up a
user
account
Its a permissions thing on the server end. You have to have set up a user
account on the server. Very important are hostnames.
Curtis
John Almberg said:
I'm trying to set up a remote connection to a mysql database using Perl
DBI. I have done this without problem on another database. I
.NET v. MySQL is not really a question. The question your asking is .NET
v. J2EE.
MySQL doesn't care about the client as long as it communicates properly.
There are ODBC drivers as well as JDBC drivers. I think I've seen a C#
driver, but then its windows and ODBC/ADO or whatever they want to
http://www.dbmail.org
Curtis
On Wednesday 22 October 2003 13:29, the council of elders heard Apollo
(Carmel Entertainment) mumble incoherently:
I was wondering if there is an opensource mail server (IMAP, not
POP) that would keep all the messages in a MySQL database, not in a
regular file?
,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax: +250-50 15 19
Mobile: +250-08517768
Email: [EMAIL PROTECTED]
http://www.nefacomp.net/
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http
Download mysqlcc instead. It works much better and is easier to use.
mysqlgui is deprecated as far as i know.
Curtis
On Thursday 17 July 2003 18:08, Emanuele wrote:
HI!
I have problem to download
http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip
Is there some
#!/usr/bin/perl
use DBI;
my $database = desired database;
my $dbhost = desired database host;
my $username = your username;
my $password = your password;
my $data_source = DBI:mysql:$database:$dbhost;
my $dbh = DBI-connect($data_source, $username, $password);
my $sourcefile = the name and path
MySQL has posted a very interesting comparison on their website. It appears
to be a reasonably fair evaluation. PostgreSQL was faster than MySQL in some
areas and MySQL was faster than PostgreSQL in most areas.
For speed with all of that functionality, I'd be more inclined to look at DB2
and MySQL in the future be smooth or a waste of time.
Not necessarily a full conversion but addons to the site at least.
Andrew
-Original Message-
From: Curtis Maurand [mailto:Curtis Maurand]
Sent: 15 July 2003 17:02
To: [EMAIL PROTECTED]
Subject: Re: CF MySQL
Set up your
The only Windows webserver that I never had security problems with was
running apache, not iis.
Curtis
running mysql 3.23.56-nt and apache 1.23.-don't-know-exactly on windows
2000 professional sp3 (going to upgrade to sp4 soon) - no problems by
now
what's your question? :)
··· yves at
I'd be interested to see what happens when MySQL gets run on a G5.
SPECint and SPECfp numbers look very good. there is an 8GB RAM limit on
it, though.
Curtis
On Tue, 24 Jun 2003, Jeremy Zawodny wrote:
On Tue, Jun 24, 2003 at 05:37:24PM -0400, Curtis Maurand wrote:
Linux compiled
$29.95 per month!
http://sbc.yahoo.com
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://lists.mysql.com/[EMAIL PROTECTED]
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://www.suse.com/en/business/products/server/sles/misc/sles8_amd64.pdf
Anyone have some practical experience with the software and hardware?
David.
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http
No route to host is a TCP/IP connection thing. Check your settings.
Curtis
TheMechE said:
Here's the log. Retrying...
Moving info for table LogOutputStats
Setting fields and metadata.
Using original table.
Tracking field is ResRefID
Starting transfer.
As the Pharoh says... Ye who
methinks you have other troubles. i've been running MySQL on K6II-266 for
a long time and its been running fine serving up several databases with
multiple users. 512MB of RAM currently but it had only 128 until
recently. Its running Linux (RedHat 7.2). I recently switched to 4.03,
but it had
You need to recompile PHP against the 4.0.nn headers.
Curtis
Subscriptions said:
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything that makes since
to me. Can someone point me in a direction as to where I can find this
actually, its worse. upon re-reading you need to compile in the mysql
drivers for mysql.
configure --with-mysql=path to mysql include files
Curtis
Subscriptions said:
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything
Maurand wrote:
What's the client running on?
Not the same machine as the server. Could either be a windows or
linux box across ethernet.
--Chris
Curtis Maurand wrote:
I'd write a perl script to pool the device and send the data to the
database.
Sorry for not being clearer. I can get the data
What's the client running on?
Curtis
On Thu, 12 Jun 2003, Chris Webster wrote:
Curtis Maurand wrote:
I'd write a perl script to pool the device and send the data to the
database.
Sorry for not being clearer. I can get the data into the database
fine. Assuming new values or rows
access the submission form in the first place?
Which is less resource hungry?
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
as in
enterprise manager! only backdraw is that this program is not
free, but
it is the best i have ever seen so far
is there anyone out there that knows of a program that is
freeware/shareware and is good (like mySQL tools)?
/rewdboy
--
--
Curtis Maurand
mailto:[EMAIL
new to the Xeon chip family with linux would be nice too.
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On Tuesday 10 June 2003 22:49, CM Miller wrote:
globals back to ON.
Sorry, but I am a bit behind on MySQL digest, but
isn't turning Register Globals 'on' for php a security
risk?
Yes. He needs to take a look at the documentation on the PHP website. I also
sent instructions on how to make
what your requirements are and then see which database suites your needs.
If you need to work with extremely large databases (multi GB) I would go
with MySQL. It scales to large files extremely well.
Curtis Maurand
On Tue, 10 Jun 2003, Becoming Digital wrote:
You're on the MySQL list, so
from a command prompt mysqldump -opt database dumpfile
Curtis
On Sunday 08 June 2003 02:59, JeRRy wrote:
Okay thanks.
One last thing.
From the mysql prompt how can I generate a database
backup? (So I can see the database setup in notepad
so I can backup and transfer easily online.)
platforms.
Curtis
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the answers to many of my other questions there.
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Oooh, just dawned on my. On the windows side there is a gui front end
called mysqlfront which uses ODBC to talk to multiple databases. It will
pull the data from a mssql server and move it to a mysql server. I haven't
used it against a mssql server, but I did use it against an access database
You can require GPL components without having to distribute them. That way
you don't have to support them, either.
Curtis
Ben Clewett said:
Okay...
BTW, I have cleared purchacing licences with my own people, and we do
not have a problem. Neither do I not like MySQL, I do.
The licence
just as:
$myquery = select * from sometable;
$myresult = mysql_query($myquery, $mysql_link);
$rows = $mysql_fetch_array($myresult)
$count = 1;
while ($rows)
{
print( trtd$count/tdtd$rows[0]/tdtd$rows[1]/td.../tr
$count++;
}
I would do the same thing in perl, C++, or Java.
Curtis
On Sun,
Point well taken. I will do remotes that way.
Curtis
On Sun, 16 Feb 2003, Michael T. Babcock wrote:
Curtis Maurand wrote:
need to encrypt data and then retrieve it later (credit card data). I could
probably pass it through and md5 or des function via openssl I suppose and
then store
However, I currently have a need to extract and decode that data. I need
a two way function.
Curtis
On Sun, 16 Feb 2003, Michael T. Babcock wrote:
Curtis Maurand wrote:
need to encrypt data and then retrieve it later (credit card data). I could
probably pass it through and md5 or des
could
probably pass it through and md5 or des function via openssl I suppose and
then store it. Perl and PHP both have functions to handle that.
Curtis
Tonu Samuel said:
On Tue, 2003-02-11 at 15:39, Curtis Maurand wrote:
The manual suggests that the password function is really for intenal
The control center doesn't have a command to flush the tables or reload the
user tables. So the new user won't have access until you do:
mysqladmin -u some user with authority -ppassword -hyour db host
reload
Curtis
Stefan Hinz said:
Karáth,
I just have installed the MySQL on a Suse linux.
The manual suggests that the password function is really for intenal mysql
functions. Ideally you should use the encode or md5_encode functions.
update user set password=encode('password', 'salt') where user =
'your_user';
Curtis
On Wed, 5 Feb 2003, Natale Babbo wrote:
try to use the
Courier IMAP can. www.courier-mta.com
Curtis
On Wed, 5 Feb 2003, Paul DuBois wrote:
At 17:26 + 2/4/03, Ben Clewett wrote:
MySQL,
My first post, please go easy if this is the wrong pleace!
I'm trying to find an IMAP server which used MySQL so that my
Mozilla Email client can file
. Even though you haven't installed NetBIOS on your Win2K/XP/9n/ME box,
its still there (NetBIOS over TCP/IP) and is the primary method of
connection(less) between Windows machines. Even the MySQL ODBC connector
uses pure TCP/IP on port 3306
non secure network? SSH is your friend.
Curtis Maurand
That is CRM software. Its quite similar to saleslogix, though I did
not see anything about storing attachments for a customer. It
otherwise looks very, very cool.
Curtis
- Original Message -
From: Wee Keat [EMAIL PROTECTED]
To: Mark Stringham [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent:
I apologized to Mark in private for my blast that was also private.
Sorry to take up the bandwidth.
Curtis
- Original Message -
From: Mark Stringham [EMAIL PROTECTED]
To: Curtis Maurand [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 11:46 PM
Subject: Re: email
Yes, don't lock the table. MySQL will handle the lock for you on the
insert. this isn't access. its a multi-user system. with access you
have to lock the table.
Curtis
On Tue, 6 Aug 2002, Pradeep Dsouza wrote:
Dear list
I have written a large application which i call Edupro which
[admin admin]$ mysql mysql
or once you have the mysql prompt type: use mysql
then issue the command
Curtis
Page Works Web Solutions said:
Hi,
any ideas on this one
[admin admin]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server
Yes.
Denny said:
Hi,
How can i use Perl DBI to create tables in mysql?
Denny
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
How about:
UserID SMALLINT UNSIGNED AUTO_INCREMENT NULL PRIMARY KEY DEFAULT 1000
Curtis
Amer Neely said:
Amer,
Monday, May 13, 2002, 2:03:28 AM, you wrote:
AN Win/98
AN MySQL 3.23.46
AN I'm trying to use AUTO_INCREMENT=1000 to specify my staring value
in an AN ID column in batch
y'all are kidding, right?
On Mon, 1 Apr 2002, Dan Zarrella wrote:
i've read the bit on google about thier pigeon rank thing, sounds like a
cross between reality and alittle aprils' fools to me, either way id
apreciate a better explanation of this technology and how it may be
1 - 100 of 127 matches
Mail list logo
