Subscribe to the newsletter here Tweet of the Day We are contributing this new section of the newsletter to our followers, users, and customers. Here are: Jose M. Arranz who has had plans to build jOOQ, when he happily discovered that jOOQ already exists https://twitter.com/jmarranz/status/417956223468982272 Majid Azimi who wishes for jOOQ to become the new de facto standard in all … Continue reading jOOQ Newsletter: January 22, 2014
Tag: DEFAULT VALUES
Lesser-Known SQL Features: DEFAULT VALUES
A lesser-known SQL feature is the DEFAULT keyword, which can be used in INSERT and UPDATE statements. Consider the following table, created using standard SQL syntax: CREATE TABLE timestamps ( id INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1), t TIMESTAMP DEFAULT CURRENT_TIMESTAMP, CONSTRAINT pk_values PRIMARY KEY (id) ) Now, in order to generate a … Continue reading Lesser-Known SQL Features: DEFAULT VALUES