Hi Dan,
"Dan Buettner" <[EMAIL PROTECTED]> writes:
> The answer is - "it depends".
>
Thanks for your suggestions.
> A multi-column index can be helpful for performance over single-column
> - or it can do you no good at all, depending on how you build it and
> how you use it.
>
> MySQL currently
Surendra -
The answer is - "it depends".
A multi-column index can be helpful for performance over single-column
- or it can do you no good at all, depending on how you build it and
how you use it.
MySQL currently uses (at most) one index per instance of a table per
query. This means that addin
Hi,
I have 4-5 different types of models which can be tagged. So, in the taggings
table should I declare a multicolumn index on [taggable_type, taggable_id] or
a single column index on [taggable_id]. What are the pros and cons of either,
and which one is preferred?
If multicolumn, then in what o
I think if you do it as a enum field, it shows as a checkbox in phpmysql
define it as enum 'Yes','No'
>>>-Original Message-
>>>From: Brian E Boothe [mailto:[EMAIL PROTECTED]
>>>Sent: Tuesday, July 25, 2006 11:07 AM
>>>
know this is probably a simple question but if im going to setup a yes
or no checkbox on a table feild on MySQL thru phpmyadmin, how do i do
that ??
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Null means "no data entered". If Null is allowed and you don't specifically set a
field to a value then it will be Null. If Null is not allowed then the field will be
assigned its default value unless you specifically set it to something during an
insert.
--
MySQL General Mailing List
For lis
- Original Message -
From: "Mike" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 05, 2004 10:53 AM
Subject: Re: Table: NULL (yes or no)
>
> >I create two tables. And when I do
> >desc table_name;
>
> >NULL value can b
>I create two tables. And when I do
>desc table_name;
>NULL value can be 'Yes' or 'No'. What the difference when NULL >value is 'Yes' or 'No"
Not sure what you are asking, but if you have an ENUM column that can be Yes or No and
you do
I create two tables. And when I do
desc table_name;
NULL value can be 'Yes' or 'No'. What the difference when NULL value is
'Yes' or 'No"
Thanks
_
Worried about inbox overload? Get MSN
Colin Faber writes:
> I fail to see why ENUM() isn't used in this case, This is exacly what
> its for.
Well, if you have an enum('0','1'), the numerical values stored
in the database will be 1 and 2, and so you would have to put
your values in quotes when you insert, or you'll end up with
'' an
Hi.
On Thu, Oct 04, 2001 at 09:01:05AM +, [EMAIL PROTECTED] wrote:
[...]
> > Actually, it's in the manual (but just recently ;), but it tells
> > otherwise: http://www.mysql.com/doc/C/o/Column_types.html
>
> Ah. One question about using CHAR(1) as BOOL, though:
> Will the value be stored as
I fail to see why ENUM() isn't used in this case, This is exacly what
its for.
Carl Troein wrote:
>
> Benjamin Pflugmann writes:
>
> > Hi.
> >
> > On Tue, Oct 02, 2001 at 09:33:53AM +, [EMAIL PROTECTED] wrote:
> > [...]
> > > I've seen rumors about bool being an alias for tinyint(1), but
Benjamin Pflugmann writes:
> Hi.
>
> On Tue, Oct 02, 2001 at 09:33:53AM +, [EMAIL PROTECTED] wrote:
> [...]
> > I've seen rumors about bool being an alias for tinyint(1), but it's
> > not in the manual and I haven't tested it.
>
> Actually, it's in the manual (but just recently ;), but it
Hi.
On Tue, Oct 02, 2001 at 09:33:53AM +, [EMAIL PROTECTED] wrote:
[...]
> I've seen rumors about bool being an alias for tinyint(1), but it's
> not in the manual and I haven't tested it.
Actually, it's in the manual (but just recently ;), but it tells
otherwise: http://www.mysql.com/doc/C/o
An enum should work fine as you've described, but remember that the ENUM
type is a MySQL proprietary type and if you ever want to convert to
another database (Oracle, PostgreSQL, MSSQL, Etc.), you may have to find
an appropiate solution (i.e. convert to integer and use 0 and 1)...
On Tue, 2 Oct
I've decided on enum. Should work fine. I've used it before and it works fine
with PHP.
Thanks for everyone help,
Jord
On Tuesday 02 October 2001 12:13, you wrote:
> >If I wanted to define a table to have a cloumn which is either yes or no
> > for example. Would it be
DB Mailing List"
<[EMAIL PROTECTED]>
Sent: Tuesday, October 02, 2001 11:23 AM
Subject: Yes or No
> If I wanted to define a table to have a cloumn which is either yes or no for
> example. Would it be better to use a single char (0 or 1), or can I use an
> enum (I
Jordan Elver writes:
> Hi,
> If I wanted to define a table to have a cloumn which is either yes or no for
> example. Would it be better to use a single char (0 or 1), or can I use an
> enum (I find them more friendly ;)).
If you use an enum you might end up with the value &#x
18 matches
Mail list logo
