Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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
For this, use MySQL FIND_IN_SET(). Let us first create a table −mysql> create table DemoTable1563 -> ( -> StudentId int, -> StudentName varchar(20) -> ); Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1563 values(1001, 'Chris'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable1563 values(1010, 'Bob'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable1563 values(1005, 'Chris'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable1563 values(1015, 'David'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable1563 ... Read More
To sort from max to min value, use ORDER BY length(). Let us first create a table −mysql> create table DemoTable -> ( -> Price varchar(20) -> ); Query OK, 0 rows affected (0.92 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('80'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values('800'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('108'); Query OK, 1 row affected (0.50 sec) mysql> insert into DemoTable values('765'); Query OK, 1 row affected (0.14 sec)Display all records from the table using ... Read More
Do not prefix table name with field name like user_name. Instead, use user or username.If you prefix table name, then there may be a chance of ambiguity, so avoid prefixing table name.Let us first create a table −mysql> create table user -> ( -> username varchar(20), -> password varchar(20) -> ); Query OK, 0 rows affected (0.66 sec)Insert some records in the table using insert command −mysql> insert into user values('John', 'J_635'); Query OK, 1 row affected (0.34 sec) mysql> insert into user values('Carol', 'Carol2212'); Query OK, 1 row affected (0.16 sec) mysql> insert into user ... Read More
For this, use MySQL MONTH() and YEAR() methods. Let us first create a table −mysql> create table DemoTable1562 -> ( -> VoucherValue int, -> RechargeDate date -> ); Query OK, 0 rows affected (1.40 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1562 values(149, '2019-10-21'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable1562 values(199, '2019-10-13'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable1562 values(399, '2018-10-13'); Query OK, 1 row affected (0.25 sec) mysql> insert into DemoTable1562 values(450, '2019-10-13'); Query OK, 1 row affected (0.20 sec)Display all ... Read More
For this, you can use a sub query along with MIN(). Let us first create a table−mysql> create table DemoTable -> ( -> Name varchar(20), -> Score int -> ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John', 56); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values('John', 45); Query OK, 1 row affected (0.24 sec) mysql> insert into DemoTable values('John', 58); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('Chris', 43); Query OK, 1 row affected (0.15 ... Read More