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
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
I have a few questions about indexes. I understand (1) what an index
is, and (2) why indexes are useful, but I don't have even a rough idea
about HOW they work. The internet resources I've been able to find don't
answer the questions I'm asking. I also tried
cat /var/lib/mysql/srms07/staff.
>Thanks!
>With regard to the ClOBs or Text fields, is that CLOB support?
>Or support for Text columns that hold up to 60,000 bytes of TEXT
data?
In MySQL they're BLOBs not CLOBs, see
http://dev.mysql.com/doc/refman/5.1/en/string-type-overview.html.
PB
http://www.artfulsoftware.com
No vi
: J A <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: Some general questions
Date: Tue, 28 Feb 2006 12:44:08 -0600
/>Does MySQL support the following:
>- Support for DDL commands and dynamic SQL inside stored
procedures? /
Yes.
/>- EXECUT
Thanks!
With regard to the ClOBs or Text fields, is that CLOB support? Or support
for Text columns that hold up to 60,000 bytes of TEXT data?
From: Peter Brawley <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: J A <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re:
>Does MySQL support the following:
>- Support for DDL commands and dynamic SQL inside stored
procedures?
Yes.
>- EXECUTE STATEMENT in Stored Procedures. (may be same question
as above)
Yes to a limited extent: PREPARE | EXECUTE accepts CREATE TABLE,
DELETE, DO, INSERT, REPLACE, SELECT, SET,
> I was asked to scope out the following features, and am not the person to
be
> implementing them.
> Hence the manuals weren't particularly helpful.
> I'm looking for definitive references one way or the other for the
following
> questions.
> SOS!
>
> Does MySQL support the following:
> - Suppo
I was asked to scope out the following features, and am not the person to be
implementing them.
Hence the manuals weren't particularly helpful.
I'm looking for definitive references one way or the other for the following
questions.
SOS!
Does MySQL support the following:
- Support for DDL comma
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
ata.
--
George Law
- Original Message -
From: "Andrew Burrows" <[EMAIL PROTECTED]>
To: "MYSQL General List"
Sent: Sunday, January 08, 2006 8:01 PM
Subject: General Questions regarding mysql and php
Hi MYSQL users,
Just started playing with mysql apache php and oth
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
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 better applicatio
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
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
> 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
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 advantage of d
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
: "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
So, examine some of
these tables if you like by performing an EXPLAIN table or SHOW CREATE TABLE
table
http://www.mysql.com/doc/en/ENUM.html
-Original Message-
From: Darryl Hoar [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 3:58 PM
To: [EMAIL PROTECTED]
Subject: general questio
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
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 ?
I have a schema defined for a database. I would like to copy that schema to
another
database. Is there a simple way to accomplish
Hello all,
I have several questions in general since I recently started using MySQL.
>From the manual I cannot find where these questions are covered. I hope
someone can assist me.
Firstly though, if this is not the correct mailing list for my questions,
please advise correct one.
Secondly, t
I have read the documentation thoroughly, however there are still some
things unclear to me, and others that I want opinions on.
I am dismayed at what I see as a fundamental lack of "server
administration" documentation. Much of the docs focus on the SQL aspects of
MySQL. There is only a minor
24 matches
Mail list logo
