Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by Jennifer Nicholas
Page 8 of 21
How to resolve the ERROR 1115 (42000): Unknown character set: 'utf8mb4'?
You will get this type of error when your MySQL version is below 5.5.3. This is because “utf8mb4” introduced in MySQL version 5.5.3.Firstly, you need to check the current version. If its less than 5.5.3, then you need to upgrade to solve the above error.Check the current version −mysql> select version();Here, our MySQL version is over 5.5.3 −+-----------+ | version() | +-----------+ | 8.0.12 | +-----------+ 1 row in set (0.00 sec)Now the same query that gave an error 1115, will display correct result. To check all character set in MySQL now, use the below query.mysql> show character set;The ...
Read MoreHow to find the highest number in a column?
You can find the highest number in a column with the help of aggregate function MAX. The syntax is as follows −select max(yourColumnName) as anyVariableName from yourTableName;To understand the above concept, let us create a table with an int column. The following is the query to create a table.mysql> create table HighestNumberDemo −> ( −> BigNumber int −> ); Query OK, 0 rows affected (0.87 sec)Now insert some values in the table. The query to insert records are as follows −mysql> insert into HighestNumberDemo values(1234); Query OK, 1 row affected (0.43 sec) mysql> insert ...
Read MoreCreate a new table with the properties of an old table and without duplicates using MySQL LIKE Operator?
To achieve this with LIKE operator, the following is the syntax −CREATE TABLE yourTableName2 LIKE yourTableName1;To understand the syntax, let us create a table and insert some records into it. The following is the query to create a table −mysql> create table Employee −> ( −> EmployeeId int −> , −> EmployeeName varchar(100) −> ); Query OK, 0 rows affected (0.54 sec)Inserting records into the table with the help of insert command. The query is as follows −mysql> insert into Employee values(1, 'Carol'); Query OK, 1 row affected (0.18 sec) mysql> insert into Employee values(2, 'John'); ...
Read MoreHow to add Exception Breakpoint in Xcode?
Sometimes while writing an iOS application or any other application we need to test multiple cases and debug the application of any known and unknown bugs. There are certain places in the code where we want our app to stop so that we can know the values of certain variables at the point and fix that bug. Before we learn how to add a break point, first let’s seeWhat’s a break point?A break point is a place in our code where the app pauses on a certain event. A break point may be added manually in xcode or may be ...
Read MoreHow to detect the screen size of iPhone 5?
Detecting screen size of an apple device is an easy and simple task. The UIKIT module of iOS SDK provides many functions and classes that deal with user interface, screen sizes and many other UI elements.One of them is UIScreen which deals with the device screen.UIScreen.main provides the current main screen of the device in use, which further has methods that return other features and properties of the current screen.To find if the current screen is an iPhone 5 or not, we’ll first have to find the current size of the screen and compare with a value. The height of ...
Read MoreWhat are all the custom URL schemes supported by the Facebook iPhone app?
A url Scheme is a way of iOS to open some third party applications from within a app. Some of the URL schemes that are supported by facebook to open different modules of facebook app from within some other app are mentioned below.1. To open facebook profile: fb://profile 2. To open request list: fb://requests 3. To open friends list : fb://friends 4. To open notes: fb://notes 5. To open the list of notifications : fb://notifications 6. To open albums: fb://albums 7. To open feeds/ home : fb://feed 8. To open events : fb://events 9. To open a page with id: ...
Read MoreGenerating a range of numbers in MySQL?
To generate a range of numbers in MySQL, you can use stored procedure. Firstly, we need to create a table. After that, we will create a stored procedure that generates a range of number from 10 to 1.The following is the query to create a table −mysql> create table GeneratingNumbersDemo −> ( −> Number int −> ); Query OK, 0 rows affected (0.55 sec)Now you can create a stored procedure that stores a range of numbers in the table. The following is the query to create a stored procedure −mysql> delimiter // mysql> CREATE PROCEDURE ...
Read MoreCalculate average of numbers in a column MySQL query?
Calculate the average of numbers in a column with the help of MySQL aggregate function AVG().The syntax is as follows −select avg(yourColumnName) as anyVariableName from yourTableName;To understand the above concept, let us create a table. The following is the query to create a table.mysql> create table AverageCalculateDemo −> ( −> SubjectMarks int −> ); Query OK, 0 rows affected (0.67 sec)The following is the query to insert some records into the table −mysql> insert into AverageCalculateDemo values(70); Query OK, 1 row affected (0.14 sec) mysql> insert into AverageCalculateDemo values(80); Query OK, 1 row affected ...
Read MoreHow can we simulate the MySQL INTERSECT query?
Since we cannot use INTERSECT query in MySQL, we will use IN operator to simulate the INTERSECT query. It can be understood with the help of the following example −ExampleIn this example, we are two tables namely Student_detail and Student_info having the following data −mysql> Select * from Student_detail; +-----------+---------+------------+------------+ | studentid | Name | Address | Subject | +-----------+---------+------------+------------+ | 101 | YashPal | Amritsar | History | | 105 | Gaurav | Chandigarh | Literature | | 130 | Ram | Jhansi ...
Read MoreWhat do you mean by Scope of variables inside MySQL stored procedure?
Suppose if we declare a variable inside a BEGIN/END block then the scope of this variable would be in this particular block. We can also declare a variable with the same name inside another BEGIN/END block which will be totally legal but its scope would be inside its BEGIN/END block. It can be understood with the help of the following example in which we are creating a procedure to show the scope of the variables −Examplemysql> Create Procedure Scope_variables() -> BEGIN -> DECLARE A Varchar(5) Default 'outer'; -> ...
Read More