I have a mysql table with 2 columns, Id and date. How can I insert one more
Column "dayname" that will be filled through sql query with day names related to
The value in the column "date".


So if a column type is DAYNAME it will automatically do it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.