CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Beginner: Re: [FishMonger] How to arrange lastupdate row in ascending order from database. : Edit Log



sh.ajay12
User

Feb 28, 2014, 6:46 AM


Views: 2894
Re: [FishMonger] How to arrange lastupdate row in ascending order from database.

Hello FishMonger,

this is my table description. how should i split it, as the data has been there for many months.

mysql> DESCRIBE nagios_device_test_audit;

Code
+---------------+--------------+------+-----+---------+-------+ 
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| shortname | varchar(15) | NO | | | |
| devicename | varchar(50) | NO | | | |
| testname | varchar(200) | NO | | | |
| param_value_1 | varchar(100) | NO | | | |
| param_value_2 | varchar(50) | NO | | | |
| param_value_3 | varchar(50) | NO | | | |
| param_value_4 | varchar(50) | NO | | | |
| param_value_5 | varchar(50) | NO | | | |
| changedtime | datetime | YES | | NULL | |
| lastupdate | varchar(100) | YES | | NULL | |
| action | varchar(20) | YES | | NULL | |
+---------------+--------------+------+-----+---------+-------+
11 rows in set (0.00 sec)



(This post was edited by FishMonger on Feb 28, 2014, 6:56 AM)


Edit Log:
Post edited by FishMonger (Veteran) on Feb 28, 2014, 6:56 AM


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives