track_log.frm
5940028 -rw-rw1 mysqlmysql6076641280 May 4 08:02
track_log.MYD
5725520 -rw-rw1 mysqlmysql5857197056 May 5 04:02
track_log.MYI
//mikezero/
//radiotakeover
-
Before posting, please check
you could always try dropping a 'd' on the end of 'change'... as in
making the field 'changed' if it's a flag to see if the data has changed.
Gerald Clark wrote:
> It is not a good idea to use reserved words for field names.
> If you must, then use back ticks ( below the ~ on my keyboard) .
>
if you are using this while going through an API like perl,php,c,c++
then you could do a call like
"select LogID from Log WHERE LogIP="10.0.0.22" ORDER BY LogID DESC LIMIT
100"
and run mysql_num_rows() on the resultant mysql query object. hope this
is at least somewhat helpful.
Cummings, Sh
if a web based solution is possible for you, use phpMyAdmin.
http://phpwizard.net/projects/phpMyAdmin/
//mikezero/
//radiotakeover
neal wrote:
>What do you guys use for remote admin of mySQL? mySQL-front? MySQLGUI?
>Other?
>
>What's most popular and why?
try 'ps aux | grep mysql' rather than using top... i dont' think you can
grep a top session.
Jack Chen wrote:
if the server is running?
I tried to use:
top | grep mysql -
but not working. Any suggestions?
Thanks!
Jack Chen, Stein Lab, Cold S
are you getting this problem with an API like php or perl cgi.. or is
this command line. i was having a similar problem, but i couldn't
access anything. i was trying to remotely connect to the mysql via
command line and it would boot me. even on the server itself if i
included the '-h hostna
eck:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
//mikeze