http://www.mysql.com/doc/R/e/Resetting_permissions.html
after starting mysql with the --skip-grant-tables, you'll have to execute a grant
statement
http://www.mysql.com/doc/G/R/GRANT.html
GRANT ALL PRIVILEGES ON *.* TO root@localhost INDENTIFIED BY 'somepassword' WITH GRANT
OPTION;
then re
MySQL can only use 1 index per query. So take your first query for example:
update forum set approved='N' where id=644122 or thread=644122
it can only use the id key OR the thread key, not both. and since you have an 'or'
in your query MySQL must scan the entire table for either id being 64
http://www.mysql.com/doc/R/e/Resetting_permissions.html
after starting mysql with the --skip-grant-tables, you'll have to
execute a grant statement
http://www.mysql.com/doc/G/R/GRANT.html
GRANT ALL PRIVILEGES ON *.* TO root@localhost INDENTIFIED BY
'somepassword' WITH GRANT OPTION;
then rest
In the changes to 3.23.34 http://www.mysql.com/doc/N/e/News-3.23.34.html
o Added option max_user_connections to mysqld.
and in the show variables doc
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
o max_user_connections The maximum number of active connections for a single
user (0 = no limit
http://www.mysql.com/doc/A/d/Adding_UDF.html
thanks,
-- Andrew
- Original Message -
From: "Julio Faerman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 27, 2001 3:11 PM
Subject: User Defined Functions.
> Can i create my own functions with mysql ?
>
>
>
>
the deleted rows will get re-used by inserts.
however, you can always run OPTIMIZE TABLE XXX and that will clear the
deleted rows
thanks,
-- Andrew
- Original Message -
From: "Steve Wright" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 19, 2001 12:03 PM
Subject:
Hi guys,
In the latest MySQL release (3.23.44) it was noted:
o TCP_NODELAY was not used on some systems
Which systems would this affect? and is this client side or server side?
thanks,
-- Andrew
-
Before posting, please
no mysql right now (3.23) does not support inner selects.
however, it looks like you could join the 2 tables to get the result you
want
I'm assuming there are 2 tables inside the emp database ? or is emp the
table ?
anyway here is an idea:
select d1.ename, d1.deptno FROM emp.table1 d1, emp.t
good point. the only real way to duplicate auto increment logic is to
create a new table with 1 row and 1 field. and lock, select, and update that
row.
thanks,
-- Andrew
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: "'Andrew Schmidt&
ct the
max(sess_id).
well anyway, sorry I couldn't help more.
thanks,
-- Andrew
- Original Message -
From: "Leos Bitto" <[EMAIL PROTECTED]>
To: "Andrew Schmidt" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 12:50 PM
auto increment is really just a nice way of doing the following (really nice
way actually):
lock table x
select max(id) + 1 from table x
insert into table x values (newid)
unlock table x
this is under the assumption table x as 1 field called id which has a
primary key on it. and newid is the id
re is the file
[dev-405:andrew] ...var/db/mysql (8) # ll
/usr/local/var/db/mysql/mysql/user.MYD
-rw-rw 1 mysql mysql 1498 Jun 29 14:29
/usr/local/var/db/mysql/mysql/user.MYD
[dev-405:andrew] ...var/db/mysql (9) #
thanks,
-- Andrew
- Original Message -
From: "Jose de Leon"
I'm not sure how you were able to do that. Especially since you didn't
provide exactly what you did.
But here's what I get as ROOT (all privileges):
mysql> load data infile '/usr/local/var/db/mysql/mysql/user.MYD' into table
t;
ERROR 1085: The file '/usr/local/var/db/mysql/mysql/user.MYD' must
treat REPLACE as INSERT.
thanks,
-- Andrew
- Original Message -
From: "John Nagle" <[EMAIL PROTECTED]>
To: "Andrew Schmidt" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 2:58 PM
Subject: Re: UPDATE which changes nothin
In the change log for 3.23.29:
Fixed a bug in UPDATE involving multi-part keys where one specified all key
parts both in the update and the WHERE part. In this case MySQL could try to
update a record that didn't match the whole WHERE part.
I think that was fixed. Try upgrading your mysql server
but mysqldump generates an invalid statement.
mysql> CREATE TABLE TESTBADDUMP (
-> e_test enum('0','1') NOT NULL default ''
-> );
ERROR 1067: Invalid default value for 'e_test'
mysql>
I think that's what the orignator is trying to show. That mysqldump is
generating an in
I believe "show ceate table" was added in mysql 3.23 and subsequently 3.22
will not have it.
thanks,
-- Andrew
- Original Message -
From: "Rob Agar" <[EMAIL PROTECTED]>
To: "Mailinglist MySQL COM" <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 11:48 AM
Subject: does show create tabl
that's a unix shell command that basicly puts the process in the background.
if you type that command at your console you'll notice you get a prompt
right away.
This allows safe_mysqld to run in the background (somewhat like a daemon)
thanks,
-- Andrew
- Original Message -
From: "mysq
I guess I didn't phrase my point properly due to the emails I have been
recieving =).
I'm just stating that this feature isn't documented in the manual though it
probably should be.
sorry for the confusion.
thanks,
-- Andrew
- Original Message -
From: "And
Doing a :
mysql> show grants for root@localhost;
+---+
| Grants for root@localhost
|
() - they
weren't properly closing the SQL connections (Zeev)
regards,
-- Andrew
- Original Message -
From: "Hunter Hillegas" <[EMAIL PROTECTED]>
To: "Andrew Schmidt" <[EMAIL PROTECTED]>; "mySQL List"
<[EMAIL PROTECTED]>
Sent: Wednesday, Ap
taken from the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO
W_PROCESSLIST
SHOW PROCESSLIST shows you which threads are running. You can also get this
information using the mysqladmin processlist command. If you have the
process privilege, you can see a
ct NOW(), count(*) from test where foo in (2);
+---+--+
| NOW() | count(*) |
+---+--+
| |0 |
+---+--+
notice the date field is blank.
>Fix:
>Submitter-Id:
>Originator: Andrew Schmidt
>Organization:
>MySQL support: [none | li
Have you tried this under a 'stable' version of freebsd?
In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault.
now, I understand RC's are generally stable; but I would still make sure
that this bug doesn't show up in a stable os.
regards,
-- Andrew
- Original Message
it matters what you run the mysql client as
if I'm root
root: #> mysql -u foo -p
the program mysql is running as root and hense writes the history file to
root's home dir.
if I'm me
andrew: $> mysql -u foo -p
it'll write it to ~andrew/.mysql_history
regards,
-- Andrew
- Original Messa
Use GROUP BY
SELECT names, score FROM grades GROUP BY names
regards,
-- Andrew
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 11:14 AM
Subject: Distinct Selects...
> Q: I have the following table "grades":
>
> +++
make sure you have -L/usr/local/mysql/lib/mysql/ in your compile
and make sure that /usr/local/mysql/lib/mysql/ is in your shared object
cache.
ldconfig -r will list your current cache entries.
if /usr/local/mysql/lib/mysql/libmysqlclient.so.10 is not in there then add
the path:
/sbin/ldconfi
27 matches
Mail list logo
