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
MySQL Articles
Page 5 of 355
Difference between CouchDB and MySQL
When it comes to databases, often the choice of technology to be implemented is decisively important for the success of an application. In the context of an increasingly wide choice of options, knowing the distinctive features and benefits of one or another database affects the aspect of scalability, flexibility, and performance critically. In this article, we will explore quote CouchDB is and how it solves different problems than MySQL – two of the most commonly used database engines that work on entirely different paradigms for vastly different uses. What is CouchDB CouchDB is a free and document-based non-SQL database that ...
Read MoreJava application to insert null value into a MySQL database
In this program, we will connect to a MySQL database and insert a null value into a table using Java's JDBC API. We will use the PreparedStatement class along with the setNull() method to achieve this. After the value is inserted, you can check the table to see how the null value is reflected. Steps to insert null value into a MySQL database Following are the steps to insert null value into a MySQL database − Establish a connection to the MySQL database using the DriverManager.getConnection() method. Define the SQL query that ...
Read MorePrint all the Prime Numbers between Ëm\\\' and Ën\\\' In PL/SQL
Introduction This article discusses the printing of prime numbers between two given values using PL/SQL. It emphasizes the importance of efficiency, precision, readability, maintainability, and error handling in software development. Optimized algorithms and data structures are employed to efficiently identify prime numbers. The use of meaningful variable names, proper indentation, and comments enhances code comprehension and adheres to coding best practices. Error handling and validation are crucial for producing reliable software solutions. The article highlights that there is an infinite number of prime numbers, underscoring the need for efficient algorithms. The focus is on providing a comprehensive and engaging ...
Read MoreReferential Integrity Rule in RDBMS
Referential Integrity Rule in DBMS is based on Primary key and Foreign Key. The Rule defines that a foreign key have a matching primary key. Reference from a table to another table should be valid.Referential Integrity Rule example −EMP_IDEMP_NAMEDEPT_IDDEPT_IDDEPT_NAMEDEPT_ZONEThe rule states that the DEPT_ID in the Employee table has a matching valid DEPT_ID in the Department table.To allow join, the referential integrity rule states that the Primary Key and Foreign Key have same data types.
Read MorePrint Patterns in PL/SQL
Introduction This article simplifies how you can leverage real-world examples, syntaxes and programming techniques in PL/SQL to master printing different types of patterns effectively. Examples of Pattern Printing in PL/SQL We'll cover how to create pyramid patterns, diamond patterns, and number patterns with their respective code snippets and syntax. Going through the present section, you will have a clear understanding of how to implement these patterns in your PL/SQL programs. Pyramid Pattern For a comprehensive understanding of pattern printing in PL/SQL, delving into the pyramid pattern is an ideal starting point. Here's how to design a pyramid pattern using ...
Read MorePerforming DataBase Operations in XAMPP
Introduction Navigating through database operations in XAMPP can be challenging, particularly for beginners. Realizing this complexity, over 15 million active monthly users have turned to XAMPP for its ease of use and flexibility. This article offers a step-by-step guide on performing basic database operations in XAMPP, from data insertion to deletion. Let's take the first stride towards mastering your XAMPP database management skills together! Basic DataBase Operations in XAMPP Basic DataBase Operations in XAMPP include performing CRUD operations such as select, insert, update, and delete statements on a MySQL database using PHP. SELECT Statement The SELECT statement is a ...
Read MoreWhat are the differences between Stored procedures and functions?
Following are the main differences between functions and procedures:FunctionsProceduresA function has a return type and returns a value.A procedure does not have a return type. But it returns values using the OUT parameters.You cannot use a function with Data Manipulation queries. Only Select queries are allowed in functions.You can use DML queries such as insert, update, select etc… with procedures.A function does not allow output parametersA procedure allows both input and output parameters.You cannot manage transactions inside a function.You can manage transactions inside a procedure.You cannot call stored procedures from a functionYou can call a function from a stored procedure.You ...
Read MoreFix ERROR 1064 (42000) while creating a database in MySQL?
The ERROR 1064 (42000) mainly occurs when the syntax isn’t set correctly i.e. error in applying the backtick symbol or while creating a database without them can also create an error, if you will use hyphen in the name, for example, Demo-Table will result in ERROR 1064 (42000).To remove the error, you need to use backtick around the database name properly or use nothing. Following is the syntax wherein we haven’t used the backtick. This works correctly −create database yourDatabaseName;Since adding hyhen to the database name will result in an error. Let us implement it while creating the database name ...
Read MoreWhat does it mean by select 1 from MySQL table?
The statement select 1 from any table name means that it returns only 1. For example, If any table has 4 records then it will return 1 four times. Let us see an example. Firstly, we will create a table using the CREATE command. mysql> create table StudentTable -> ( -> id int, -> name varchar(100) -> ); Query OK, 0 rows affected (0.51 sec) Inserting records mysql> insert into StudentTable values(1, 'John'), (2, 'Carol'), (3, 'Smith'), (4, 'Bob'); Query OK, 4 rows affected (0.21 ...
Read MoreSELECT where row value contains string in MySQL?
To select the row value containing string in MySQL, use the following syntax.SELECT *FROM yourTableName where yourColumnName like ‘%yourPattern%’;To understand the above syntax, let us first create a table. The query to create a table is as follows.mysql> create table PatternDemo -> ( -> Id int, -> Name varchar(100), -> Age int -> ); Query OK, 0 rows affected (0.97 sec)Insert records in the table using insert command. The query is as follows.mysql> insert into PatternDemo values(1, 'James', 23); Query OK, 1 row affected (0.11 sec) mysql> insert into PatternDemo values(2, 'Joseph', 21); Query OK, 1 row affected (0.18 ...
Read More