I have a db table created as follows :
CREATE TABLE mktDB(
mktID number(19) not null,
featureId number(20) not null,
val varchar(100) not null,
primary key (id)
);
I want to view all the records along with an additional field having current date with each row in the db.
I tried the following sqlite query but it is erroneous :
SELECT *, CURRENT_DATE FROM mktDB,DATE;
Aucun commentaire:
Enregistrer un commentaire