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 li
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
conne
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 b
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
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');
mysql> FLUS
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 g
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 o
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:
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 of
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
gnize 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 wil
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 s
nd we add a row
>> for each setting of that
user.
>> 3. Create a separate table each time we want to add a
new setting,
>> UserId, WhateverTheNameOfThePreferenceIs.
>>
>> Anyone have any experience with this, or better
suggestions?
>>
>> Thanks,
>&
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 dbmail-ut
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.inno
you?
They have 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
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 d
no choice but to grant INSERT,DELETE,UPDATE
> on db.*, which negates the possibility of a read-only user.
>
> It would be nice if MySQL would have a more generic 'TEMPORARY TABLES'
> permission that would allow one to create, insert, delete from and
> drop temporary tables
> on db.*, which negates the possibility of a read-only user.
>
> It would be nice if MySQL would have a more generic 'TEMPORARY TABLES'
> permission that would allow one to create, insert, delete from and
> drop temporary tables without having to give up insert/update/dele
rror messages you get?
>
> Dan
>
>
> On 8/15/06, Curtis Maurand <[EMAIL PROTECTED]> wrote:
>> 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;
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 po
select into outfile
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 the where clause (check the
mysqladmin -u root password
Curtis
sheeri kritzer wrote:
> Hi Alaister,
>
> Your root password is not actually set. If you do
>
> mysql -u root -p
> and it fails, it means that the password is not
>
> if you do
>
> mysql -u root
>
> the mysql client will parse as the database you're trying
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
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 fil
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 per
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.
>> >
>> > Alterna
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
arbi
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 bo
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 da
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 th
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
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
th
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 y
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 l
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]
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:
ient for limiting access to data in commonly-used tables.
> >
> > It begs the question why you're giving your clients access to the native
> mysql client itself rather than developing an application to do this, in
> which you could quite easily limit such access.
> >
&g
> need examples to really understand something so I've had real challenges
> > learning bash since the references are extremely skimpy on concrete
> > examples.
> >
> > Good luck!
> >
> > Rhino
> >
> > - Original Message -
> > From: &
attern-matching search for the
> decrypted password:
> SELECT .. FROM account WHERE DECODE(password, 'foobar') LIKE '%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]
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.
> >
> > Curt
ame site but they are significally less
> >critical. After reviewing this and talking to some other people i'm switching
> >over to postgresql. I'm sure there is a place with mysql but I don't think i'd
> >trust it for anything critical unless you very confident
rpm -e
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
--
t; --
> Regards
> Leonardus Setiabudi
> IT Project 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
Fo
#x27;Dumping MySQL
> result set to a spreadsheet', Account: 'news.gmane.org', Server:
> 'news.gmane.org', Protocol: NNTP, Server Response: '441 You are not
> allowed to approve postings', Port: 119, Secure(SSL): No, Server Error:
> 441, Error Nu
ultiple transactions outstanding. Is this something 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.m
eed to have mysql installed on the red hat machine?
> I can connect to the slackware linux box from 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]
htt
xample I have the following row:
>
> | 567456 | 20040102 | Owg-08299-abzu_via.lap-2003 |
>
> 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
&g
select last_insert_id();
or in php use the mysql_insert_id() eg:
$somevalue = mysql_insert_id();
print ("The last auto incremented number was: $somevalue\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 In
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 an
ED]
>
> Member: ASDA, APS, ANA, Ephemera Society
> of America, Long Island Web Developers Guild
>
> <><><><><><><><><><><><><><><><><><><><><><><>
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 susp
.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 c
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
> 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://www.maurand.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#!/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
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
ng is because a solution has been presented to me in CF
> and
> MS SQL which I think will restrict future development and wondered whether
> a conversion to PHP and MySQL in the future be smooth or a waste of time.
> Not necessarily a full conversion but addons to the site at least.
>
&
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
rat
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? :)
>
> ··· yve
er
> must provide his password?
>
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $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]
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:
> &
desk by mid
> summer to late fall.
>
> If you're interested, SuSe has a good PDF on AMD64 and SuSe Enterprise Linux
> 1.0:
>
> http://www.suse.com/en/business/products/server/sles/misc/sles8_amd64.pdf
>
>
> Anyone have some practical experience with the software and
s is frought with danger as someone could
> come
> >> along and insert a new entry between my SELECT and INSERT.
> >>
> >> Because 'id' is the only guaranteed unique column, I cannot think of
> a
> >> way to do a SELECT after an INSERT to g
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..
mn < $time;
Curtis
Chris Webster said:
> Curtis 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:
>>>
>>&
actually, its worse. upon re-reading you need to compile in the mysql
drivers for mysql.
configure --with-mysql=
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.
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 t
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 b
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 databas
I
> assume there is no notification process available from the server
>
> TIA for any pointers.
>
> --
> --Chris
>
> I don't approve of political jokes.
> I've seen too many of them get elected.
>
>
> --
> MySQL General Mailing List
> F
(ie
> IA64)?
>
> Any other tips for someone 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]
(http://www.mysqltools.com/) and
> >> mySQL explorer that works almost as enterprise manager for MS SQL
> >> server. it even creates database diagrams with relations as in
> >> enterprise manager! only backdraw is that this program is not
> >> free, but
>
ld I just use .htaccess to grant usernames and passwords so no
> unauthorized user can access the submission form in the first place?
>
> Which is less resource hungry?
>
>
>
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
--
MySQL General Mail
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 t
e out just
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
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
and background images if I convert this to a MySQL table.
>
> Thanks!
>
> P.S. I have perused http://www.mysql.com/doc/en/index.html , and I found
> the answers to many of my other questions there.
>
>
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maura
s. I'm sure the x86 assembler is replaced on other 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]
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
a
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 lice
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
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 ope
just as:
$myquery = "select * from sometable";
$myresult = mysql_query($myquery, $mysql_link);
$rows = $mysql_fetch_array($myresult)
$count = 1;
while ($rows)
{
print(" $count$rows[0]$rows[1]...
$count++;
}
I would do the same thing in perl, C++, or Java.
Curtis
On Sun, 16 Feb 2003, Micha
). I 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 fu
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 -p -h
reload
Curtis
Stefan Hinz said:
> Karáth,
>
>> I just have installed the MySQL on a Suse linux.
>> I would like to administrate it from
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 cli
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 pas
using a chatty protocol like NetBIOS over
IP. 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 sec
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: Thur
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
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 whi
[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 ser
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
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
> implem
1 - 100 of 128 matches
Mail list logo
