Re: Anyone running Windows 2000?

2003-07-01 Thread Mark Rowlands
On Tuesday 01 July 2003 9:39 pm, Ola Ogunneye wrote: > Is anyone out there running mysql with Apache and php on windows 2000? If > you are out there, please respond and hopefully you may be able to help me. > I see that most of the posts are geared towards unix/solaris. > > I am a newbie that needs

groups, limits and counts.

2003-06-29 Thread Mark Rowlands
I have a tabletheres a surprise month protocol port utime 06 tcp21 12 06 tcp21 13 05 udp 43 100232 05 udp 21 100245 what I would like to do is select by month and by protocol but within protocol limit to the top 5 by count of

Re: Automatically running SQL command through a batch file

2001-07-04 Thread Mark Rowlands
On Wednesday 04 July 2001 21:37, Christopher Brown-Floyd wrote: > Is there a way to run a SQL command or create a database through a batch > file? jeez! for some one who is omniscient you don't know much read the friendly manual section 9.6 : Using mysql in batch-mode also check out mysqldu

Re: DBD::MySQL Help!!

2001-05-23 Thread Mark Rowlands
If this was the binary install, I had the same problemso I compiled from source.problem went away. > Hi, > > Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- > I know this is prolly not the best list for this question, but its the only > related list im currentl

Re: users and passwords...users and passwords...

2001-05-21 Thread Mark Rowlands
/mysql/bin/mysql_setpermission can also be handy but if you do stuff manually don't forget to do a /mysql/bin/mysqladmin flush-privileges a bit of manual reading probably wouldn't go amiss either :-) On Monday 07 May 2001 07:54, Daniel Goldin \(E-mail\) wrote: > I've had similiat

Re: create table with select syntax error problem

2001-05-17 Thread Mark Rowlands
- > From: "Mark Rowlands" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, May 17, 2001 3:11 > Subject: create table with select syntax error problem > > > CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(10) &

create table with select syntax error problem

2001-05-16 Thread Mark Rowlands
CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(10) unsigned DEFAULT '0' NOT NULL,PRIMARY KEY (sajtid)) select log.sajtid,count(*) from log,sajter where log.sajtid=sajter.id and log.mon = 5 group by log.sajtid; the create table on its own works, the select statement works,

Re: Can anyone help me.. for install on a Freebsd 4.2 box..

2001-04-24 Thread Mark Rowlands
On Thursday 19 April 2001 21:54, Ken Menzel wrote: > cd /usr/ports/databases/mysql323-server > make > make install > reboot this aint windows ya know skip the reboot /sbin/ldconfig -m /usr/local/lib/mysql /usr/local/bin/safe_mysqld --user=mysql

Re: Perl MySQL Interface

2001-04-12 Thread Mark Rowlands
let perl -MCPAN -e shell be your friend i /mysql/ will show you all the mysql stuff or i /dbi/ even On Thursday 12 April 2001 01:16, Chris Becker wrote: > go to perl.com - click CPAN and look for DBI and DBD, and look for docs on > how to install a perl module. You need to inst