Re: Bug or error in SQL syntax - Specifying and using a user variable inside a single select query

2002-05-06 Thread Gregg Graubins
> Gregg, > Monday, May 06, 2002, 6:57:55 PM, you wrote: > > GG> Upon reading into the user variables section of the mysql manual, I decided > GG> to make my life easier inside several of my queries by specifying some user > GG> variables. Note that I'm trying to h

Bug or error in SQL syntax - Specifying and using a user variable inside a single select query

2002-05-06 Thread Gregg Graubins
--+---++ 1 row in set (0.00 sec) == Does anyone have any insights or clues as to what the problem could be? Thanks in advance! === Gregg Graubins <[EMAIL PROTECTED]> (PGP key available) --

Re: Password error

2001-09-06 Thread Gregg Baker
Someone the other day said this worked: started safe_mysqld with --skip-grant-tables and then did: mysql -u root mysql mysql> UPDATE user SET password=PASSWORD('abc') WHERE User='root' -> AND Host='whichever host you want to match' - Original Message - From: "Mike Ryerse" <[EMAIL P

Thanks [root password]

2001-08-30 Thread Gregg
Snitz Forum 2000 is working great now! I don't know exactly what I did though. It never did run the setup.asp exactly as it should. A combination of MySQL root password privileges, GRANTS, UPDATES, just the right chmods and trying setup.asp, setup.asp?RC=5, setup_login.asp got it done. I want to

USE UPDATE and root password

2001-08-29 Thread Gregg Baker
FORUM_CATEGORY_CAT_ID(CAT_ID), KEY FORUM_CATEGORY_CAT_STATUS (CAT_STATUS) ) === ... and many more 3704 errors Now if I enter root and leave password blank, it says Installation Complete and has a test database link, I take the link and it's back to the "need to logo

Re: Problems getting into MySQL.com

2001-08-29 Thread Gregg Baker
yes, i just tried and failed - Original Message - From: "Philip Daggett" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 9:50 AM Subject: Problems getting into MySQL.com > Is anybody else not able to get onto mysql.com??? > > > --

Re: Root password revisited

2001-08-28 Thread Gregg Baker
Hi all, I got a "No Database Chosen". What's the syntax for adding the database? I tried *.*, mysql, and test between UPDATE and user but all returned syntax error. Thanks much, Gregg UPDATE user SET Password=PASSWORD("desiredpasswordher

Root password revisited

2001-08-28 Thread Gregg Baker
Hi all, I just joined list. I spent a couple hours in the archive and decided MySQL better improve their install message regarding setting the root password! Half the posts are about it going badly. ;) I believe I found the answer in the archives, but they all aren't the same answer. So is the co

Re: format masks for a Masked edit control

2001-02-21 Thread Gregg Housh
I would also like to add to this, that I think it would be a good addition to the documentation. Gregg - Original Message - From: Gregg Housh <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 20, 2001 4:08 PM Subject: format masks

format masks for a Masked edit control

2001-02-20 Thread Gregg Housh
. I just dont seem to be good at getting them right. Gregg

Re: Embedded MySQL: Opinion Please

2001-02-15 Thread Gregg Housh
http://www.qnx.com/ Tey actually have a headline right now about BerkleyDB being ported. While I take nothing away from the Mysql/Linux combo as a stable OS. I would stay that a specifically designed RTOS for embeded devices might be better in this situation. Gregg - Original Message

MySQL Windows GUI (admin tool)

2001-02-12 Thread Gregg Housh
such as having an offline version of your table on your laptop in access, that you can then syncronize the structure with your online mysql database (easier offline modling.) (thanks Philippe Jadin [EMAIL PROTECTED]) Gregg

Re: Re[2]: MySQL GUI for Windows

2001-02-12 Thread Gregg Housh
over the few others that are out there, if you like one of the others go for them. If you are making money off it, and can afford to pay for a good tool, then try mascon out. Gregg - Original Message - From: James Treworgy <[EMAIL PROTECTED]> To: Graeme B. Davis <[EMAIL PROTE

Re: Boolean Datatype

2001-02-06 Thread Gregg Housh
Let me add to this. I meant to say: He could create a function that would do it, and use it in his queries? Gregg - Original Message - From: Gregg Housh <[EMAIL PROTECTED]> To: Russ Davies <[EMAIL PROTECTED]>; Matt Friedman <[EMAIL PROTECTED]>; MySQL List <[E

Re: Boolean Datatype

2001-02-06 Thread Gregg Housh
http://www.mysql.com/doc/A/d/Adding_functions.html Could this help him out? Creating a User Defined Function? Gregg - Original Message - From: Russ Davies <[EMAIL PROTECTED]> To: Matt Friedman <[EMAIL PROTECTED]>; MySQL List <[EMAIL PROTECTED]> Sent: Tuesday, Februar

Re: 'USE_RAID' in mysql-3.22.32?

2001-01-29 Thread Gregg Housh
In the create table documenttation, it explains the USE_RAID, and a few other options pertaining to it. Gregg - Original Message - From: Brian Reichert <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 29, 2001 4:22 PM Subject: 'USE_RAID' in mysq