Hello

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".

Thanks

Recommended Answers

There's no need, check the DAYNAME function.

Jump to Post

All 2 Replies

There's no need, check the DAYNAME function.

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.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.