· 8 years ago · Jul 03, 2018, 02:24 PM
1drop table if exists users;
2create table users (
3 id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
4 name varchar,
5 email varchar,
6 username varchar,
7 password varchar,
8 register_date CURRENT_TIMESTAMP() not null
9);
10
11cur.execute("INSERT INTO users(name, email, username, password) VALUES(%s, %s, %s, %s)", (name, email, username, password))
12
13ERROR: syntax error at or near "CURRENT_TIMESTAMP"
14LINE 7: register_date CURRENT_TIMESTAMP() not null