s denied for user 'testuser'@'Serv1.corp.domain.in'
(using password: YES)
It connect successfully if i remove -h option because it connects by
localhost then
*Mysql version : 5.5.36-log *
root@Serv2:~# mysql -utestuser -p@8AsnM0! -h $(hostname)
Welcome to the MySQL monitor. Comm
ok
I have tried these :
ifconfig -a
lo0: flags=8049 mtu 16384
inet6 ::1 prefixlen 128
inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1
inet 127.0.0.1 netmask 0xff00
gif0: flags=8010 mtu 1280
stf0: flags=0<> mtu 1280
fw0: flags=8863 mtu 4078
lladdr 70:cd:60:ff:fe:eb:72:ea
media:
Hi
> > > | | ericomtxmacbookpro.local |
> > *E85DC00A0137C6171923BE35EDD809573FB3AB4F |
> > >
>
mysql> DELETE FROM mysql.user WHERE user='';
mysql> FLUSH PRIVILEGES;
maybe helps?
Cheers
--
Claudio
yes it is ...
also , the eclipse is also local ...
in both ... mysql-admin php application , plus inside eclispe plugin ...
same behavior in both
2014/1/13 Reindl Harald
> i doubt that the webserver is running on the same
> machine as your mysql command shell
>
> Am 13.0
Am 13.01.2014 21:47, schrieb shawn l.green:
> Hello Reindl,
> We are not saying he is using HTTP commands to log into his database
we excludes obviously the OP or his overall understanding :-)
Am 13.01.2014 18:54, schrieb Érico:
> using both urls I get the same error :
>
> http://localhost/mysql
Hello Reindl,
On 1/13/2014 3:01 PM, Reindl Harald wrote:
*your application* is connecting to mysql
*your application* is using a hostname
*your application* *may* use 127.0.0.1
*your application* should use localhost to *connect to the databse*
*your application* can only use TCP *if there is* a
*your application* is connecting to mysql
*your application* is using a hostname
*your application* *may* use 127.0.0.1
*your application* should use localhost to *connect to the databse*
*your application* can only use TCP *if there is* a *mysql user* with *that
host*
http://dev.mysql.com/doc/re
gt;> Welcome to the MySQL monitor. Commands end with ; or \g.
>>> Your MySQL connection id is 31
>>> Server version: 5.6.15 MySQL Community Server (GPL)>
>>>
>>> but in the browser I get the error :
>>>
>>> Access denied for user 'root
Hi
no connections outside command line are being accepted . I have connected
through command line , but not using eclipse for example ... it gets the
same error from the web app
my apache and pages are in the same computer that mysql
I am not getting password issues.. otherwise I would not conne
Hello Érico,
On 1/13/2014 1:49 PM, Érico wrote:
Hi
didn't work
look ... isn't this something related to this :
are you using "localhost" or "127.0.0.1" in the web-application
root@localhost != root@127.0.0.1 = different users
localhost: Unix-Socket
127.0.0.1: TCP
...
since I am not able to
27;root'@'127.0.0.1' identified by
> 'kernel26';
> >
> > ...
> >
> >
> > in eclipse using jconnector ... I get the same error :
> > when pinging :
> >
> > java.sql.SQLException: Access denied for user 'root'@&#
;
>
> ...
>
>
> in eclipse using jconnector ... I get the same error :
> when pinging :
>
> java.sql.SQLException: Access denied for user 'root'@'localhost' (using
> password: YES)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:10
by kernel26' at line 1
...
in eclipse using jconnector ... I get the same error :
when pinging :
java.sql.SQLException: Access denied for user 'root'@'localhost' (using
password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQL
or. Commands end with ; or \g.
>> Your MySQL connection id is 97
>>
>> Server version: 5.6.15 MySQL Community Server (GPL)
>>
>>
>>
>>
>> but using 127.0.0.1 no :
>>
>> ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h 127.0.0.1
&
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h 127.0.0.1
> -P 3306
> Enter password:
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)
> ericomtxmacbookpro:bin ericomtx$
>
>
>
> 2014/1/13 Erick Oc
'root'@'localhost' (using
password: YES)
ericomtxmacbookpro:bin ericomtx$
2014/1/13 Erick Ocrospoma
> From that error I would suspect you are trying to access to a database
> where has not external access. And yeah, try by doing
>
> $> mysql -u root -p -h loc
ror :
> >
> > Access denied for user 'root'@'localhost' (using password: YES)
> >
> > I can't find any information in error log and access log
> >
> > is there any command parameter that I should use when starting mysql so
> > th
r. Commands end with ; or \g.
>> Your MySQL connection id is 31
>> Server version: 5.6.15 MySQL Community Server (GPL)>
>>
>> but in the browser I get the error :
>>
>> Access denied for user 'root'@'localhost' (using password: YES)
>>
but in the browser I get the error :
>
> Access denied for user 'root'@'localhost' (using password: YES)
>
> I can't find any information in error log and access log
>
> is there any command parameter that I should use when starting mysql so
> thi
. Type '\c' to clear the current input
statement.
mysql>
...
but in the browser I get the error :
Access denied for user 'root'@'localhost' (using password: YES)
I can't find any information in error log and access log
is there any command parameter th
;mysqladmin" -p root shutdown next the root password
> was
> > asked for,I entered the correct password, when I entered the password the
> > below displayed error was the result
> >
> > mysqladmin: connect to server at 'localhost' failed
> > error: 'Acc
sword was
> asked for,I entered the correct password, when I entered the password the
> below displayed error was the result
>
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'ODBC'@'localhost' (using pa
; failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
How can I correct this?
Is this because of a firewall preventing access to port 3306?If a firewall
is preventing access how was it able to ask for the password?
I have Nortan Internet Sec
the result
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
How can I correct this?
Is this because of a firewall preventing access to port 3306?If a firewall
is preventing access how w
server at 'localhost' failed
error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'
How can I correct this?
Is this because of a firewall preventing access to port 3306?If a firewall
is preventing access how was it able to ask for th
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
user
'user1'@'200.93.42.209' (using password: YES)
[EMAIL PROTECTED] ~]#
I already checked the user was configured for any host ("%"), the
port 3306 is open (checked with nmap), but i dont know what i
need to do or see other variables. I am 100% sure of the
p
ing answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user
'user1'@'200.93.42.209' (using password: YES)
[EMAIL PROTECTED] ~]#
I already checked the user was configured for any host ("%"),
On 6/7/06, Aron Levy <[EMAIL PROTECTED]> wrote:
Hi James i follow your recomendation and verify that the hash produced
matches the password field in user exactly.
-- Aron L.
Well, that's weird, should be working. A shot in the dark: try
starting your server with "--old-passwords" as an option
I keep receiving the
following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209'
(using password: YES)
[EMAIL PROTECTED] ~]#
I already checked the user was configured for
ed for user
'user1'@'200.93.42.209' (using password: YES)
[EMAIL PROTECTED] ~]#
I already checked the user was configured for any host ("%"), the
port 3306 is open (checked with nmap), but i dont know what i need
to do or see other variables. I am 100% sure of t
@'200.93.42.209'
(using password: YES)
[EMAIL PROTECTED] ~]#
I already checked the user was configured for any host ("%"), the port
3306 is open (checked with nmap), but i dont know what i need to do or
see other variables. I am 100% sure of the passwords i am using for
Hi,
What about SELECT count(*) FROM table1 - SELECT count(*) FROM table1
WHERE status = 1 ? (this query should be mush faster)
Regards,
Jocelyn
jpow wrote:
Hi everyone, I have this problem of slow "count *" when I use a where clause.
1. I have a table of ~1m rows.
2. There is a "status" c
Hi everyone, I have this problem of slow "count *" when I use a where clause.
1. I have a table of ~1m rows.
2. There is a "status" column which can be 0 or 1.
3. Most of the rows have a status of 0, but maybe 10% of them have a
status of 1.
4. I need to know how many records are status 1 / 0 for
Laurent <[EMAIL PROTECTED]> wrote:
> User mysqladmin has not the rights to access mysql? How can that be?
Have you created the "mysqladmin" user? By default there is no such user and
it's not supposed to be there. There is no special meaning for it - mysqladmin
usually logs in as "root" user.
Have you tried another user.
-Original Message-
From: Laurent
To: [EMAIL PROTECTED]
Sent: 7/19/04 8:07 AM
Subject: Re: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (U
sing password: YES)
On Monday 19 July 2004 14:59, Victor Pendleton wrote:
> mysqladmin is an ex
On Mon, 19 Jul 2004, Laurent wrote:
> On Monday 19 July 2004 14:59, Victor Pendleton wrote:
> > mysqladmin is an executable. Did you set up an user named mysqladmin that
> > can connect from the localhost?
>
> Exactly, it should be able to connect, but it doesn't. Should I change the
> name from m
On Monday 19 July 2004 14:59, Victor Pendleton wrote:
> mysqladmin is an executable. Did you set up an user named mysqladmin that
> can connect from the localhost?
Exactly, it should be able to connect, but it doesn't. Should I change the
name from mysqladmin to mysql or something similar? I'll t
mysqladmin is an executable. Did you set up an user named mysqladmin that
can connect from the localhost?
-Original Message-
From: Laurent
To: [EMAIL PROTECTED]
Sent: 7/19/04 6:55 AM
Subject: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
User
User mysqladmin has not the rights to access mysql? How can that be?
Laurent
--
Linux is like an Indian tent: no Windows, no Gates, and an Apache inside!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hen, I try to connect to the database using the host parameter but I
> get the following error message:
>
> # mysql --user=foo --password=password -h host foo
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
>
> I've only mana
# mysql --user=foo --password=password -h host foo
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
I've only managed to find a single thread about this issue which was a
bug in the installation of mysql on RedHat 7. Many months have gone by
since the
Jack Woehr wrote:
I figured this out. It's the "ANY" setup in Privileges. Being set to
allow ANY user to login without password, MySQL interestingly interprets
that as "even known users with passwords MUST log in without passwords."
Well, that seems to be the effect, but that's not what it is doi
I figured this out. It's the "ANY" setup in Privileges. Being set to allow ANY user to
login without password, MySQL interestingly interprets
that as "even known users with passwords MUST log in without passwords." My two
solutions were either to delete the ANY privileges or
to create a second ac
' mysql -u abcd -pxxyyzzaa'
> o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
> YES)
> * As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have
> verified the password field for 'abcd' was
word
"xxyyzzaa"
* I can login using the command-line 'mysql -u abcd'
* I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
* As root I have execut
aa"
* I can login using the command-line 'mysql -u abcd'
* I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
* As root I have executed 'USE mysql; SEL
lrmt',...) failed: Access
denied for user: '[EMAIL PROTECTED]' (Using password: YES) at test.cgi line 20".
This script is running from apache. The apache log file displays the same
message when I run the script through Internet browser. And also I got this
error message when I run this s
TECTED]>
> To: "KKoTY" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Friday, February 06, 2004 6:21 AM
> Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
>
>
> > I have installed MyODBC 3.51 and created
Otherwise try to create user named ODBC, and you will see,
also it writes "Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)*",
so you are using some password, and question is from where this goes, and
which
password you have to give to user ODBC.
I still
ED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, February 05, 2004 3:38 PM
> Subject: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
>
>
> > Hi all,
> >
> > Is any one met with the error while connecting to MySQL Server
> >
>
February 05, 2004 3:38 PM
Subject: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
> Hi all,
>
> Is any one met with the error while connecting to MySQL Server
>
> *Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)*
>
> if
Arunachalam wrote:
Hi all,
Is any one met with the error while connecting to MySQL Server
*Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)*
OK, you tried to log into mysql as [EMAIL PROTECTED], using a password.
if so pleass let me know the remedy to resolve this
You have attempted to login with out supplying a username. Try logging in
like:
mysql -u -p
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/5/04, 8:38:13 AM, Arunachalam &l
Hi all,
Is any one met with the error while connecting to MySQL Server
*Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)*
if so pleass let me know the remedy to resolve this error.
I don't have the user named ODBC in my mysql Database.
my configuration is:
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
etly go crazy and or bald.
Does Paul.D. actually HAVE hair? Has anyone met him in person to verify the
existance of strands. lol- ;)
_TheMechE
-Original Message-
From: ike strong [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 22, 2003 12:16 PM
To: [EMAIL PROTECTED]
Subject: Error 104
meassage:
>
> Error 1045: Acess denied for user: '[EMAIL PROTECTED]'
> (Using password: YES)
You didn't specify user name.
>
> This is perhaps an old story here but very well new to
> me.
>
> Has anyone tackled or know what is causing this
> problem?
ECTED]'
(Using password: YES)
This is perhaps an old story here but very well new to
me.
Has anyone tackled or know what is causing this
problem? I'd appreciate some help with this one.
Thanks in advance
Ike
__
Do you Yahoo!?
Free Pop-Up Blocker -
I figured it out. Actualy silly me forgot to add the password() function
how embarising. :)
--
Jerry M. Howell II
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> now allowing clients to login but I'm not sure what would cuse it not to
> allow root to change the password, I dubble and triple checked my entry
> but still nothing happens. Once I login to root I do the following
>
> mysql> use mysql
> mysql> UPDATE user SET Password= ('x')
> -> WHERE
On Fri, Sep 05, 2003 at 01:34:01PM -0400, Fortuno, Adam wrote:
> Jerry,
>
> Don't forget that MySQL authenticates an entity, which is based on the user
> name and host. For example, on my MySQL boxes root can only login from the
> localhost. If I attempt to login with root from another host, I am
rry M. Howell II [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 1:24 PM
To: [EMAIL PROTECTED]
Subject: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
Hey there all,
Here is the problem I am haveing and was wondering if anyone can help
Hey there all,
Here is the problem I am haveing and was wondering if anyone can help
me here. I was getting the following error when loging into mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
After searching for an answer I found the ans
off this feature to get a quicker startup with -A
Database changed
but when I type :
load data infile '/user's_path/datafile' into table database's_table fields
terminated by ',' (field_1,field_2,field_3,field_4);
I returns:
ERROR 1045: Access denied for user: '[E
Database changed
but when I type :
load data infile '/user's_path/datafile' into table database's_table fields
terminated by ',' (field_1,field_2,field_3,field_4);
I returns:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]
that describes how MySQL sorts
user table entries when it compares them to incoming connection attempts.
>
>Neal
>
>
>-Original Message-
>From: neal [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, August 28, 2002 7:28 PM
>To: mySQL
>Subject: JDBC - Access denied (using pass
27;ve ever put on this machine, and I'm using 3.0 Beta. :)
Thanks.
Neal
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 8:03 PM
To: neal
Cc: suresh; mySQL
Subject: Re: JDBC - Access denied (using password: yes)
neal wrote:
> Tha
'localhost' its fine.
I don't really understand why but it fixed it...
Neal
-Original Message-
From: neal [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 7:28 PM
To: mySQL
Subject: JDBC - Access denied (using password: yes)
Does anyone know why I would rec
).
>
> Cheers.
> Neal
>
> -Original Message-
> From: suresh [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 28, 2002 7:50 PM
> To: neal
> Subject: Re: JDBC - Access denied (using password: yes)
>
>
>
> Are you using Connection con =
> Driver
t: Wednesday, August 28, 2002 7:50 PM
To: neal
Subject: Re: JDBC - Access denied (using password: yes)
Are you using Connection con =
DriverManager.getConnection("jdbc:mysql://localhost/database_name?user=root"
) ;
If not try this
regards
Kayamboo Suresh
At 07:27 ßã 02/08/28 -070
.
javax.servlet.ServletException: Invalid authorization specification: Access
denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Thanks.
Neal
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
Hi, all
recently, we compiled under mdk8 , then under rh6.2
version of mysql4.01 and also mysql4.02
sources as :
./configure --prefix=/usr/local/mysql --with-vio --with-opensssl=/usr/local/ssl
with-named-curses-libs=/usr/libs/libncurses.so.5
then make , make install, etc
all seems to work
at last,
i got an error 5 'Access Denied', then after some blah,blah, etc, etc,
it got started with InnoDB.
not InnoDB is yes.
now i can write a good SQL QUERY ;)
special thanks to Heikki and Bert
--
Hyt
To: Paul DuBois
Cc: [EMAIL PROTECTED]
Subject: Re: innodb is disabled, how can i make it yes?
hi Paul:
>
> Make sure it's not being started with --skip-innodb.
>
i am sure that the --skip-innodb is not in any of my configuration files.
sql
--
Hytham Shehab
---
Outgoing mai
Hytham,
- Original Message -
From: ""Hytham Shehab"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 03, 2002 6:21 AM
Subject: Re: innodb is disabled, how can i make it yes?
> hi Heikki,
> i do what u said:
> >
hi Heikki,
i do what u said:
> yourpathtomysqlbindir> mysqld-max-nt --console
cannot initialize innodb as 'innodb_data_file_path' is not set
...
i sword in god that i have set this data file path as:
innodb_data_file_path=c:/mysql/data/ibdata:300M
and this is a valid directory, and some ti
hi Heikki,
i do what u said:
> yourpathtomysqlbindir> mysqld-max-nt --console
cannot initialize innodb as 'innodb_data_file_path' is not set
...
i sword in god that i have set this data file path as:
innodb_data_file_path=c:/mysql/data/ibdata:300M
and this is a valid directory, and some times i ge
nesday, July 03, 2002 2:24 AM
Subject: Re: innodb is disabled, how can i make it yes?
> hi Paul:
> >
> > Make sure it's not being started with --skip-innodb.
> >
> i am sure that the --skip-innodb is not in any of my configuration files.
>
> sql
> --
> Hytham
hi Paul:
>
> Make sure it's not being started with --skip-innodb.
>
i am sure that the --skip-innodb is not in any of my configuration files.
sql
--
Hytham Shehab
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Dat
how variables like "have_%";
> ---
> variable_name | value
> ---
> have_bdb| yes
> have_innodb| disabled
> have_openssl | no
> ...
> ---
>
> why the innodb is disabled ?
>
> t
r and start the client, i type:
>show variables like "have_%";
>---
>variable_name | value
>-------
>have_bdb| yes
>have_innodb| disabled
>have_openssl | no
>...
>---
>
>why the i
have_%";
---
variable_name | value
---
have_bdb | yes
have_innodb| disabled
have_openssl | no
...
---
why the innodb is disabled ?
thanks in advance
sql
--
Hytham Shehab
---
Outgoing mail is certified Virus Free.
Chec
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
n front of a DIFFERENT
report. You can KEEP TRACK of your PROGRESS by watching which report people are
ordering from you. If you want to generate more income, send another batch of e-mails
or continue placing ads and start the whole process again! There is no limit to the
income you will generate f
1 - 100 of 114 matches
Mail list logo
