mercredi 1 juillet 2015

SELECT and ADD fields in SQL table

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