Re: Variables in stored procedure

2011-10-04 Thread Adam Gerson
aph', '31', 'yes'), ('310', '0', 'statpress_donotcollectspider', 'checked', 'yes'), ('311', '0', 'statpress_autodelete_spider', '1 day', 'yes'), ('312', '0'

Variables in stored procedure

2011-10-04 Thread Adam Gerson
n; while v_counter <= v_max do SET TABLENAME = CONCAT('wp_',v_counter, '_options'); INSERT INTO TABLENAME VALUES ('309', '0', 'statpress_mincap', 'edit_posts', 'yes'); set v_counter=v_counter+1; end while; commit

Re: % wildcard host permission not working

2008-04-29 Thread Adam Gerson
ds were different for a shared username from different hosts. On Apr 24, 2008, at 8:58 AM, Adam Gerson wrote: I set up a user and entered % for the host. I am not able to connect. However, if I change the host value to my FQDN it works fine. Shouldn't the wildcard allow me to connect from

% wildcard host permission not working

2008-04-24 Thread Adam Gerson
I set up a user and entered % for the host. I am not able to connect. However, if I change the host value to my FQDN it works fine. Shouldn't the wildcard allow me to connect from any host? Thanks, Adam -- Adam Gerson Assistant Director of Technology Apple Certified System Administ

test - please ignore

2007-04-05 Thread Adam Gerson

Re: Can mysql handle this load?

2003-07-09 Thread Adam Gerson
sprüngliche Nachricht- Von: "Adam Gerson" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Gesendet: Mittwoch, 9. Juli 2003 15:46 Betreff: Can mysql handle this load? I am writing an attendance system in php for my school. We have a little less t

Can mysql handle this load?

2003-07-09 Thread Adam Gerson
attendance in a separate table from the current days attendance and moving things over in the middle of the night. This way any operations on the current days data will go quickly, but reports on long term things will still be slow. Good idea? Thanks, Adam --- Adam