Re: Another newbie question
Posted by:
Rick James
Date: February 08, 2014 11:54AM
"already have" implies one of these:
* There is some kind of DATETIME or TIMESTAMP in the table to give time ordering.
* You need to interrogate (SELECT) the table to see if something is already in there.
The "proper" way to produce the report would be to have only the raw data (Country | Band | Mode | Details ). It should also include a DATETIME. Then, during the printout, you deduce the "New xx" information.
Also, TEXT is not a good datatype for everything. Consider VARCHAR(30) for country, ENUM for band and mode.
Subject
Written By
Posted
February 06, 2014 11:58PM
February 07, 2014 01:11AM
February 07, 2014 06:41AM
February 07, 2014 11:15AM
February 07, 2014 07:50PM
Re: Another newbie question
February 08, 2014 11:54AM
February 08, 2014 05:41PM
February 08, 2014 06:55PM
February 08, 2014 06:59PM
February 08, 2014 08:48PM
February 09, 2014 02:56AM
February 09, 2014 07:43PM
February 10, 2014 02:31PM
February 11, 2014 05:10AM
February 11, 2014 10:41AM
February 11, 2014 08:12PM
February 12, 2014 12:50AM
February 12, 2014 08:32AM
February 12, 2014 07:39PM
February 12, 2014 10:47PM
February 12, 2014 11:50PM
February 13, 2014 12:00AM
February 13, 2014 02:14AM
February 13, 2014 11:10PM
February 16, 2014 12:51AM
February 27, 2014 04:54AM
February 27, 2014 08:47PM