Re: General Questions About Indexes

2007-05-28 Thread Baron Schwartz
Hi John, John Kebbel wrote: INDEXES - A Science AND an Art I've been continuing to look for answers to my own questions. I've found a few ... I meant to write back and try to help, but got busy with other things. You have found some good answers for yourself. Q1. What good does it do to s

Re: General Questions About Indexes

2007-05-27 Thread John Kebbel
INDEXES - A Science AND an Art I've been continuing to look for answers to my own questions. I've found a few ... Q1. What good does it do to store the primary key or a unique key if you're normally SELECTing columns that don't use that primary or unique key? "As you can see, it only make

RE: General Questions regarding mysql and php

2006-01-09 Thread Jay Paulson \(CE CEN\)
e Law [mailto:[EMAIL PROTECTED] Sent: Sun 1/8/2006 8:42 PM To: Andrew Burrows; MYSQL General List Subject: Re: General Questions regarding mysql and php Andrew, I used to be a big redhat fan - but if you are looking to totally bring everything up to date, I would suggested opensuse. having used r

Re: General Questions regarding mysql and php

2006-01-08 Thread George Law
Andrew, I used to be a big redhat fan - but if you are looking to totally bring everything up to date, I would suggested opensuse. having used redhat for years, Suse's not a big step - everything is still RPM based, however, Suse's admin tool, YaST, kicks butt :) Suse 10 comes with Apache 2

Re: General Questions regarding mysql and php

2006-01-08 Thread 2wsxdr5
Andrew Burrows wrote: Hi MYSQL users, Just started playing with mysql apache php and other tricky stuff and have a few question to get me going after many years. Was wondering what the best GUI based administration tool is used today, I lasted used phpMyAdmin, is this still used or are there b

Re: General questions

2004-08-04 Thread SGreen
I checked. SIUE seems to be an institute of higher learning. Well, here's your chance to do some self-directed,internet-based learning (probably the point of your project, isn't it. :-( ) RTFM my dear student! Then, if you don't understand what you read, use a search engine to find out what o

RE: General questions

2004-08-04 Thread JOHN MEYER
1. What is the user or connection limit for both versions of MySQL (Database Server and MaxDB)? Search the web site 2. How much memory does MySQL take when started up? Search the web site 3. Does MySQL take advantage of dual CPU systems? Search the web site 4. Define referential integrity. Do a

Re: General questions

2004-08-04 Thread jeffrey_n_Dyke
> I was wondering if anyone could answer a few questions for me. I have to do > some research for a school project. > 1. What is the user or connection limit for both versions of MySQL (Database > Server and MaxDB)? > 2. How much memory does MySQL take when started up? > 3. Does MySQL take ad

RE: general questions

2003-06-03 Thread Kyle Lange
Or alternatively, (as I read it), use a char(0). Poss. Values NULL or '' (empty string). Kyle -Original Message- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 11:04 AM To: [EMAIL PROTECTED] Subject: Re: general questions Actually, the idea

Re: general questions

2003-06-03 Thread Becoming Digital
: "Kieran Kelleher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, 02 June, 2003 16:23 Subject: RE: general questions Define the field as type ENUM [NOT NULL] with values "N" and "Y", but read and understand the ENUM type

RE: general questions

2003-06-03 Thread Kieran Kelleher
Define the field as type ENUM [NOT NULL] with values "N" and "Y", but read and understand the ENUM type before you use it so you understand what happens when someone tries to insert something other than Y or N. ENUM (Y/N) is what MySQL uses in the mysql permissions database. So, examine some of the

Re: general questions

2003-06-03 Thread Lutz Zetzsche
Hi Darryl, Am Montag, 2. Juni 2003 21:58 schrieb Darryl Hoar: > Greetings, > I am trying to figure out how to define a field type as boolean. Is > there a way? Or must > I define the field as integer and represent true/false with 1/0 ? To my knowledge the MySQL "equivalent" to the boolean type i