Interested to Buy Any Domain ? << Click Here >> for more details...
What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do?
- 1 Answers
- 5329 Views
- I also Faced
- E-Mail Answers
Answer / amith
On initialization places a zero in that column, on future
updates puts the current value of the timestamp in.
| Is This Answer Correct ? | 4 Yes | 0 No |
How do I start mysql client?
How to use sum function in where clause in mysql?
What is the purpose of using timestamp data type?
How would you enter characters as hex numbers?
What is definer in mysql?
What is mysql workbench used for?
What is the size of mysql database?
How do I rename a procedure?
Can you save your connection settings to a conf file?
What is row level locking?
Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END
How to include character strings in sql statements?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
