You are here: Home / Topics / Search / sql
Showing 8 Search Results for : sql

Arithmetic Operators in SQL

Filed under: SQL on 2023-08-10 06:48:49
Different number-crunching administrators are utilized in SQL to be specific Addition (+), Subtraction (-), Multiplication (*), Division (/), Modulus (%).For the further examples we will be referring to the following base table:Table: BOOKSBookNoNameCostDiscount9871Nancy Drew2005%9560Goosebump25010%

Types of SQL Data Types

Filed under: SQL on 2023-08-10 06:43:40
Types of SQL Data TypesNumeric data type:It includes datatypes like int, tinyint, bigint, float, real, etc.Date and Time data type:It includes datatypes like Date, Time, Datetime, etc.Character and String datatype:It includes data types like char, varchar, text, etc.Unicode character/string datatype

Comments in SQL

Filed under: MySQL on 2023-03-02 06:17:40
A comment in any text which is ignored by the compiler and is not executed. It is used to convey some information to the user and used for documentation only, to describe the command's purpose in an application. Comments can be placed anywhere in the statement between any keywords, parameters or pun

Introduction to Structure Query Language (SQL)

Filed under: MySQL on 2023-03-02 06:15:51
SQL (Structure Query language) is a standard database language for creating, maintaining, manipulating, and destroying relational database. QueryA query is a request/question expressed in a formal way with intent to get some result .A 'SELECT is a query used for retrieval of data.Relational Dat

Difference between the database and the table

Filed under: MySQL on 2022-10-07 11:30:51
There is a major difference between a database and a table. The differences are as follows:Tables are a way to represent the division of data in a database while the database is a collection of tables and data.Tables are used to group the data in relation to each other and create a dataset. This dat

Difference between MySQL and SQL?

Filed under: MySQL on 2022-10-07 10:54:10
SQL is known as the standard query language. It is used to interact with the database like MySQL. MySQL is a database that stores various types of data and keeps it safe.A PHP script is required to store and retrieve the values inside the database.SQL is a computer language, whereas MySQL is a softw

What are the technical specifications of MySQL?

Filed under: MySQL on 2022-10-07 10:53:17
MySQL has the following technical specifications -Flexible structureHigh performanceManageable and easy to useReplication and high availabilitySecurity and storage managementDriversGraphical ToolsMySQL Enterprise MonitorMySQL Enterprise SecurityJSON SupportReplication & High-AvailabilityManageab

What is MySQL?

Filed under: MySQL on 2022-10-07 07:40:20
MySQL is a multithreaded, multi-user SQL database management system which has more than 11 million installations. It is the world's second most popular and widely-used open source database. It is interesting how MySQL name was given to this query language. The term My is coined by the name of the da