There is a table
When I insert a record (from the application / client), I fill in the "date" field.
Question :
Is it possible to automat (on the server side) somehow fill in the "year_month" field (type INT), after filling in the "date"? if this field should display “month” and “year” (entered in “date”), if this does not trigger this. Or it should be done by the client.
Thank.
select *, DATE_FORMAT(date,'%m%Y') as year_month from table
, than justselect *
. In the end, you can do the view:create view MyView as select *, DATE_FORMAT(date,'%m%Y') as year_month from table
is this column really on the table - Mikeview
in this case is the database view. - Ponio