How can I make a field automatically use today's date in YYYY-MM-DD format (Date datetype)? I tried a few different ways, but nothing worked. I have even searched the MySQL manual online... Please help!
MySQL itself does not provide functionality so that a date field will default to "today's date" (in the MySQL table definition). You can for example insert today's date using a MYSQL function in the INSERT SQL. See CURDATE(), CURTIME(), NOW().