-
Oracle PL/SQL BITAND function example
The BITAND function treats its inputs and its output as vectors of bits, the output is the bitwise AND of the inputs.
Date: 2019-08-11 View: 1520
-
Oracle PL/SQL CREATE function example
This article will help you to understand how to create a user defined function. It’s also known as stored function or user function.
Date: 2019-08-11 View: 1520
-
PHP + Windows Call to undefined function mysql_connect()
Install WordPress and hits the following error message :
Date: 2019-08-11 View: 1520
-
ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
Try to log into the MySQL server, but it prompts the following error message:
Date: 2019-08-11 View: 1520
-
How to check MySQL version
In terminal, type mysql -V (uppercase V) to display the current MySQL version installed on the server.
Date: 2019-08-11 View: 1520
-
Linux script to backup MySQL to Amazon S3
A shell script to backup MYSQL database and upload it to Amazon S3.
Date: 2019-08-11 View: 1520
-
JDBC PreparedStatement SQL IN condition
Java JDBC PreparedStatement example to create a SQL IN condition.
Date: 2019-08-11 View: 1520
-
Spring Boot + Spring data JPA + MySQL
The previous Spring Boot + Spring data JPA will be reused, modify to support MySQL database.
Date: 2019-08-11 View: 1520
-
Spring Boot MySQL : Table DB_NAME.hibernate_sequence doesnt exist
Spring Boot + Spring Data JPA + MySQL, and hits the following error message when the application starts :
Date: 2019-08-11 View: 1520
-
Spring Boot + Spring data JPA + PostgreSQL
The previous Spring Boot + Spring data JPA will be reused, modify to support PostgreSQL database.
Date: 2019-08-11 View: 1520
-
JDBC How to print all table names from a database?
A JDBC example to connect to a PostgreSQL, and print out all the tables from the default database postgres
Date: 2019-08-11 View: 1520
-
JDBC CallableStatement PostgreSQL Stored Function
A JDBC CallableStatement example to show you how to call a stored function from PostgreSQL database.
Date: 2019-08-11 View: 1520
-
How to Uninstall Oracle Database 19c on Windows
To uninstall Oracle database on Windows, we have to delete the all the related Ora* registry keys, files and folders manually.
Date: 2019-08-11 View: 1520
-
java.sql.SQLException: The server time zone value xx time is unrecognized
Making a JDBC connection to the MySQL server with the latest mysql-connector-java:8.0.16 and hits the following SQLException:
Date: 2019-08-11 View: 1520