Re: opening a server to generalized queries but not too far

2010-06-16 Thread Adam Alkins
privileges to a specific table for a specific user. -- Adam Alkins || http://www.rasadam.com On 16 June 2010 14:17, Don Cohen don-mysq...@isis.cs3-inc.com wrote: This seems like a topic that must have been studied, but I'm having trouble figuring out what to search for in Google, since the usual

Re: list rows with no recent updates

2010-06-16 Thread Adam Alkins
. -- Adam Alkins || http://www.rasadam.com On 14 June 2010 16:02, MadTh madan.feedb...@gmail.com wrote: Hi, I ran a update command on around 2700 rows inside a mysql database table which has around 3000 table rows to change the ( say) price of each item ( with unique ID. unique product code

Re: opening a server to generalized queries but not too far

2010-06-16 Thread Adam Alkins
(which would be rather weak security imho). -- Adam Alkins || http://www.rasadam.com On 16 June 2010 14:48, Don Cohen don-mysq...@isis.cs3-inc.com wrote: Adam Alkins writes: Sounds like you just want to GRANT access to specific tables (and with limited commands), which is exactly what MySQL's

Re: setting the data directory.

2006-01-31 Thread Adam Alkins
-0011 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Adam Alkins http://www.rasadam.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Math Computations

2002-04-11 Thread Adam Alkins
Something like ? $db = mysql_connect(localhost,database_user,password); mysql_select_db (database_name); $query = SELECT * FROM table_name; $result = mysql_query($query); echo Computers | Department | Price Per PC | Total Amountbr; while ($row = mysql_fetch_row($result)){