Numeric Data Types in MySQL | Explained
Numeric Data Types in MySQL In this article, we will see about numeric data types in MySQL. Numeric types allows as to stores numbers and it is divided into integer…
What is SELECT statement in MySQL
SELECT Statement in MySQL SELECT selects records from the table. When this command is executed from the command line, MYSQL prints all the records that match the query. So, in…
How to Use SimpleXML Extension in PHP | Pros and Cons
Simplexml Extension in PHP PHP supports both DOM and SAX parsing methods. The simple and easiest way to work with XML data in PHP is via its SimpleXML extension. This…
Best Example to Understand Describe Command in SQL
Describe Command in SQL Learn what is the use of describe command in SQL. This comment gives information about the fields in a table. Ex: CREATE TABLE EMPLOYEE ( empId…
SQL Insert Multiple rows From Select
SQL Insert Multiple rows From Select In this article, we are going to discuss how to sql insert multiple rows from select. If you know, the INSERT INTO command in…
Easiest way to Know MySQL Data Manipulation
Data Manipulation in MySQL Structured Query Language, or SQL, is the standard language use to communicate with a database to add, modify, delete records and data retrieval(selection) used by all…
How to Install SQLite on Windows
Step-by-Step Guide to Install SQLite on Windows In this article, I will tell you how to install SQLite on windows with simple steps: Visit the official website of SQLite for…
What are Primary key and Foreign key in MySQL
What are Primary Key and Foreign Key In general, a single database can hold multiple tables. Each table can be related using primary key > foreign key relationships. So, in…
How to Find Value in PHP Array
PHP Find Value in Array To find value in PHP array, we need to use the in_search() in-built function. Some people use the search_array function if we use it to…
How to Create a Table in MySQL Workbench
How to Create a Table in MySQL Workbench In this article, we will see how to create a table in MySQL workbench. In MySQL, data of a business, a company,…