 AUTO GENERATE -DATE- COLUMN OF MYSQL TABLE WITH ONE YEAR FULL DATES |
| shankar from vizag |
 Apr 23 2022, 01:04 AM
Post
#1
|
|
Advanced Member  Group: Members Posts: 202 Joined: 18-June 13 Member No.: 19,316  |
Greetings to the community
Please guide me step by step procedure to auto generate a date column of mysql table with dates of the current year. example Date other_col1 other_col2 2022-04-23 2022-04-24 2022-04-25 ... ... ... Kindly guide me, I am using php mysql regards |
  |
 
|
  |
Replies
| CharlesEF |
Apr 26 2022, 02:50 PM
Post
#2
|
|
Programming Fanatic Group: Members Posts: 1,981 Joined: 27-April 13 From: Edinburg, Texas Member No.: 19,088 |
Glad you got it working.
|
|
|
|
Posts in this topic
shankar from vizag AUTO GENERATE -DATE- COLUMN OF MYSQL TABLE WITH ONE YEAR FULL DATES Apr 23 2022, 01:04 AM
CharlesEF How about this?
ColumnName datetime default now... Apr 23 2022, 05:07 AM
shankar from vizag
How about this?
ColumnName datetime default now... Apr 24 2022, 12:35 AM CharlesEF I tried your suggestion but the query returns noth... Apr 24 2022, 01:43 AM shankar from vizag
I tried your suggestion but the query returns not... Apr 25 2022, 08:22 PM shankar from vizag Yes it works like following,
create table tbl(
... Apr 25 2022, 08:33 PM |
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:
|
Lo-Fi Version | Time is now: 18th May 2024 - 08:23 AM |
Invision Power Board
© 2024 IPS, Inc.
Licensed to: HTMLHelp.com, LLC