Answers for "add date column in sql"

SQL
0

add colum date in sql

ALTER TABLE ADD COLUMN this_date DATE DEFAULT CURRENT_DATE;
Posted by: Guest on March-02-2021
1

create table with date column in sql

mysql> create table DemoTable
   (
   StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
   StudentName varchar(20),
   StudentAdmissionDate DATE
   );
Query OK, 0 rows affected (0.47 sec)
Posted by: Guest on December-04-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language