-
SQL时间处理函数大全
1. 当前系统日期、时间select getdate() 2. dateadd 在向指定日期加上一段时间的基础上,返回新的 datetime 值例如:向日期加上2天select dateadd(day,2,'2004-10-15') --返回:2004-10-17 00:00:00.000
Date: 2008-12-17 View: 1520
-
oracle pl/sql 基础知识
如果用ORACLE 做数据库编程,对于程序猿来说,常用的就是PL/SQL, 因为程序猿一般不实际数据库管理很深的知识。但必须对PL/SQL 很熟悉,这是开发部分,与管理部分不同。
整理了部分常用的 pl /sql 以备参考,今后记不住的时候,拿出来参考下,年纪大了,知道有那么个东西,但记不住,所以特别需要整理一下。
Date: 2012-08-23 View: 1520
-
Spring Batch Example – MySQL Database To XML
In this tutorial, we will show you how to read data from a MySQL database, with JdbcCursorItemReader and JdbcPagingItemReader, and write it into an XML file.
Date: 2019-08-18 View: 1520
-
Cant delete records in MySQL Workbench
In MySQL workbench, issue a simple delete all commands
Date: 2019-08-17 View: 1520
-
HSQL identify auto increase ID
In HSQLDB you can use IDENTITY keyword to define an auto-increment column, normally, this is the primary key. Review below examples :
Date: 2019-08-17 View: 1520
-
Spring embedded database examples
In this tutorial, we will show you a few examples to configure the embedded database engines like HSQL, H2 and Derby in Spring framework.
Date: 2019-08-17 View: 1520
-
MySQL Backup and restore a database or table
In this tutorial we will show you how to use backup and restore a MySQL database or tables.
Date: 2019-08-17 View: 1520
-
Oracle PL/SQL – After DELETE Trigger example
This article shows you how to use AFTER DELETE TRIGGER, it will fire after the delete operation is executed. In real life scenarios, it is mostly used for purposes like:
Date: 2019-08-11 View: 1520
-
Spring Boot JDBC + MySQL + HikariCP example
In this article, we will show you how to create a Spring Boot JDBC application + MySQL and HikariCP.
Date: 2019-08-11 View: 1520
-
MySQL Establishing SSL connection without servers identity verification is not recommended
Start a Spring Boot application and making a JDBC connection, hits the following warning messages on console :
Date: 2019-08-11 View: 1520
-
Spring Boot Show Hibernate SQL query
Add the following lines in application.properties to log the Hibernate SQL query.
Date: 2019-08-11 View: 1520
-
Oracle PL/SQL – Rename Trigger
This article shows you how to use ALTER TRIGGER to rename a trigger.
Date: 2019-08-11 View: 1520
-
Oracle PL/SQL – After UPDATE Trigger example
This article shows you how to use AFTER UPDATE TRIGGER, it will fire after the update operation is executed.
Date: 2019-08-11 View: 1520
-
Oracle PL/SQL – Display source code for a Trigger
The following SQL shows you how to get the source code for a specified trigger :
Date: 2019-08-11 View: 1520
-
Oracle PL/SQL – After INSERT Trigger example
This article shows you how to use AFTER INSERT TRIGGER, it will fire after the insert operation is executed.
Date: 2019-08-11 View: 1520