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
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
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
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
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
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,
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: Some general
@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.
/- EXECUTE STATEMENT in Stored Procedures. (may be same question as
above
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
[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 redhat
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
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
- Original Message -
From: Andrew Burrows [EMAIL PROTECTED]
To: MYSQL General List mysql@lists.mysql.com
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 other tricky stuff and have a
few
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
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
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 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
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
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 is the
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 questions
Greetings,
I am trying
: 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 before you use it so you understand what
happens when someone
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 ideal type
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,
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