RE: MySQL installed but no MySQLAdmin???

You also need to download and install the MySQL client programs rpm from the mysql.com website too. This will install mysql and mysqladmin client progs. Neil -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: Thursday, 14 February 2002 1:01 PM To: MySQL Subject: MySQ

Support contracts question

ut this is just an issue of logistics (and accounting freaking out for duplicating items). Hope this question makes sense. Neil Silvester Webmaster Heat and Control Ph: +61 7 3877 6429 [EMAIL PROTECTED] http://www.heatandcontrol.com --

MySQL Server uptime.

abase can't cut the mustard, obviously hasn't tried. Mysql 3.23.43 Up 212 days, Processed 199,654 queries (average = 0.01/sec) Processed 2 slow queries (woops ;-) don't you hate leaving out the where statement on joins) Neil Silvester Webmaster Heat and Control Ph: +61 7 3877 6

PHP and Mysql problem

I am having a little problem with a PHP 4 statement in one of my webpages. I am using a drop down box of selections that is built a table in a MySQL database. This is what I have so far (everything works well, the correct information is displayed for both the Category and ID column values.

Mzximum character count

characters. This way I could possibly decrease the varchar size (currently 100) to speed up the queries. My table is as below. CREATE TABLE competitor ( CompetitorsName varchar(35) not null, Website varchar(100), ID int auto_increment not null primary key ) TIA. Neil

PHP variable conversion problem.

uctcategory.ID=\"$cat\" AND competitorproducts.CatID=productcategory.ID" ); Any help would be mostly appreciated. Thanks. Neil Silvester Webmaster / Systems Administrator Heat and Control Inc. _ Get your FREE d

PHP variable conversion problem.

uctcategory.ID=\"$cat\" AND competitorproducts.CatID=productcategory.ID" ); Any help would be mostly appreciated. Thanks. Neil Silvester Webmaster / Systems Administrator Heat and Control Inc. _ Get your FREE d

PHP variable conversion problem.

uctcategory.ID=\"$cat\" AND competitorproducts.CatID=productcategory.ID" ); Any help would be mostly appreciated. Thanks. Neil Silvester Webmaster / Systems Administrator Heat and Control Inc. _ Get your FREE d

Alphabetical AUTO_INCREMENT?

How do I convert (or create from scratch) a table who's AUTO_INCREMENT column would be a, b, c, d, e and so forth up to z? At the moment I am using an INT column 1, 2, 3, 4, etc, but I would really be able to make good use in my queries if this column was alphabetical instead. Thanks.

Select statement problem

CatID=productcategory.ID and productcategory.ID like \"$cat%\" and competitor.CompetitorName like \"$CompName%\" and competitorproducts.ProductName like \"$CompProd%\" order by CompetitorName "); I am using PHP as a front end.

Text formatting for HTML output.

Currently I am using a standard field for information input to the MySQL database. When I display the allready information in the text fields to allow the user to manipulte the information, the formatting includes any carrige returns that have been entered. However when I display the text usi

RE: SELECT DISTINCT BINARY crashes mysql on null values

get the same effect? Neil Silvester Webmaster Heat and Control Pty Ltd -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 30 January 2002 7:45 AM To: [EMAIL PROTECTED] Subject: SELECT DISTINCT BINARY crashes mysql on null values >Descript

RE: Suppress WARNING

Or you can just add an @ in front of the function you are calling in your script which tells PHP to suppress all error warnings, which allows you script to continue running. Neil Silvester -Original Message- From: Ed Lazor [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 30 January 2002 3:52

RE: Really good idea on Performance Tuning???

eone else to do >it, not necessarily gaining the knowledge for the future). > >Generally, when talking about optimising MySQL servers and applications, >I'd go for training as a first choice: best return on investment for >that particular case. Absolu

Problem with MySQL DATE_FORMAT or is it a PEBKAC??

could be doing wrong. has anyone come across this before? The MySQL version I am using is 3.23.39 (hmm. maybe I should upgrade this to start with). Cheers. Neil Silvester - Before posting, please check: http://www.mysql.com/m

Missing values in an INT type column

least help me along with it, or has anyone come across a need for this before. Neil Silvester Webmaster Heat and Control Ph: +61 7 3877 6429 [EMAIL PROTECTED] http://www.heatandcontrol.com - Before posting, please c