Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
You can use the DECLARE command to declare a variable inside a MySQL procedure. Let us create a stored procedure in MySQL −mysql> DELIMITER // mysql> CREATE PROCEDURE DECLARE_VARIABLE_DEMO(IN value int) -> BEGIN -> DECLARE searchValue int; -> set searchValue=value; -> if searchValue=10 then -> select searchValue+100; -> else -> select searchValue; -> end if; -> END -> // Query OK, 0 rows affected (0.17 sec) mysql> DELIMITER ;Above, we have declared a variable. Now, let us call the stored procedure using CALL command −mysql> call DECLARE_VARIABLE_DEMO(10);This will ... Read More
You need to close connection in finally block. Following is the Java code to close connection in JDBC and MySQL −import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; public class CloseConnectionDemoInFinallyBlock { public static void main(String[] args) { String JDBCURL = "jdbc:mysql://localhost:3306/web?useSSL=false"; Connection con = null; try { con = DriverManager.getConnection(JDBCURL, "root", "123456"); System.out.println("connection is open"); } catch (Exception e) { e.printStackTrace(); } finally { try { con.close(); } catch (SQLException sqlException) { sqlException.printStackTrace(); } } } }This will produce the following output −connection is openHere is the screenshot of the output −
For this, you can use NOT LIKE operator. Let us first create a table −mysql> create table DemoTable -> ( -> StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> StudentName varchar(20), -> StudentAdmissionYear varchar(20) -> ); Query OK, 0 rows affected (1.22 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(StudentName, StudentAdmissionYear) values('Chris', '2017'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable(StudentName, StudentAdmissionYear) values('David', '2015'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable(StudentName, StudentAdmissionYear) values('Bob', '2019'); Query OK, 1 row affected (0.18 sec) mysql> insert ... Read More
Let us first create a table −mysql> create table DemoTable -> -> ( -> StudentName varchar(20), -> StudentSubject varchar(20) -> ); Query OK, 0 rows affected (0.58 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John', 'MySQL'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('Adam', 'MySQL'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values('John', 'Java'); Query OK, 1 row affected (0.34 sec) mysql> insert into DemoTable values('Carol', 'Java'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('John', 'MongoDB'); Query ... Read More
For this, use LEFT in MySQL. Let us first create a table −mysql> create table DemoTable -> ( -> Title text -> ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Java database connectivity to MySQL database'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values('Python with django framework'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('C with data structure and algorithm'); Query OK, 1 row affected (0.33 sec)Display all records from the table using select statement −mysql> select ... Read More
You need to use intvalue=1. The statement intvalue=’1’ is internally converted to cast(‘1’ as int) by MySQL.Let us first create a table −mysql> create table DemoTable1566 -> ( -> intvalue int -> ); Query OK, 0 rows affected (0.64 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1566 values(1); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable1566 values(55); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable1566 values(75); Query OK, 1 row affected (0.32 sec) mysql> insert into DemoTable1566 values(90); Query OK, 1 row affected (0.19 sec)Display all ... Read More
Use the MySQL LIKE operator to match even when punctuation is present. Let us first create a table−mysql> create table DemoTable -> ( -> Comments varchar(20) -> ); Query OK, 0 rows affected (1.10 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Good, Morning'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('Nice'); Query OK, 1 row affected (0.51 sec) mysql> insert into DemoTable values('good, bye!'); Query OK, 1 row affected (0.11 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following ... Read More
For this, you can use STR_TO_DATE(). Let us first create a table −mysql> create table DemoTable1565 -> ( -> ArrivalDatetime varchar(40) -> ); Query OK, 0 rows affected (0.82 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1565 values('10/01/2019 21:29:35'); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable1565 values('10/13/2019 4:56:00'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable1565 values('10/13/2018 12:40:46'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable1565 values('10/13/2019 21:30:00'); Query OK, 1 row affected (0.58 sec)Display all records from the table using select ... Read More
For this, you can use the CASE statement. Let us first create a table−mysql> create table DemoTable -> ( -> Name varchar(20), -> Marks1 int, -> Marks2 int -> ); Query OK, 0 rows affected (0.72 sec)Insert some records in the table using insert command−mysql> insert into DemoTable values('Chris', 45, null); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('David', null, 78); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('Bob', 67, 98); Query OK, 1 row affected (0.14 sec)Display all records from the table using select statement −mysql> ... Read More
You can troubleshoot by trying a telnet to SAP system.Open a command prompt on the system you are running your .net application and try to telnet server having SAP system installed.Telnet 127.0.0.1 3300If you using a local system, try using a hostname instead of loopback IP address and make an entry in host file of the system.How to find host file in the system?Press the Windows key.Type Notepad in the search field.In the search results, right-click Notepad and select Run as administrator.From Notepad, open the following file: c:\Windows\System32\Drivers\etc\hosts.Make the necessary changes to the file. Click File -> Save to save your ... Read More