Thursday , 22 October 2020
Stackode
Home > Tag Archives: MYSQL Develope

Tag Archives: MYSQL Develope

Select Query – SQL

Select Query – SQL statement is used to fetch the data from a database table which returns data in the form of result table. These result tables are called result-sets. Syntax: The basic syntax of SELECT statement is as follows: SELECT column1, column2, columnN FROM table_name; Here, column1, column2…are the fields of a table whose values you want to fetch. ...

Read More »

Indexes – SQL

Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index in a database is very similar to an index in the back of a book. For example, if you want to reference all pages in a book that discuss ...

Read More »

MAX Function SQL

MAX Function SQL is used to find out the record with maximum value among a record set. To understand MAX function, consider an employee_tbl table, which is having the following records: SQL> SELECT * FROM employee_tbl; +------+------+------------+--------------------+ | id | name | work_date | daily_typing_pages | +------+------+------------+--------------------+ | 1 | John | 2007-01-24 | 250 | | 2 | Ram ...

Read More »

Apa itu mysql.?

Apa itu mysql.? MySQL (bisa dibaca dengan mai-mai – es-es – ki-ki – el atau bisa juga mai-mai – se-se – kuel) kuel adalah suatu perangkat lunak database relasi (Relati Relational Relati onal Database Management System atau RDBMS), RDBMS seperti halnya ORACLE, Postgresql, MS SQL, dan sebagainya. Jangan disalah-artikan MySQL dengan SQL. SQL (singkatan dari Structured Query Language) Language sendiri ...

Read More »

Where Clause – SQL

Where Clause – SQL is used to specify a condition while fetching the data from single table or joining with multiple tables. If the given condition is satisfied then only it returns specific value from the table. You would use WHERE clause to filter the records and fetching only necessary records. The WHERE clause is not only used in SELECT ...

Read More »

ALTER TABLE Command – SQL

ALTER TABLE Command – SQL is used to add, delete or modify columns in an existing table. You would also use ALTER TABLE command to add and drop various constraints on a an existing table. Syntax: The basic syntax of ALTER TABLE to add a new column in an existing table is as follows: ALTER TABLE table_name ADD column_name datatype; ...

Read More »

MIN Function SQL

MIN Function SQL is used to find out the record with minimum value among a record set. To understand MIN function, consider an employee_tbl table, which is having the following records: SQL> SELECT * FROM employee_tbl; +------+------+------------+--------------------+ | id | name | work_date | daily_typing_pages | +------+------+------------+--------------------+ | 1 | John | 2007-01-24 | 250 | | 2 | Ram ...

Read More »

MySQL Database Server

MySQL Database Server – Software database mulai bermunculan seiring dengan bertambahnya kebutuan akan database server. Salah satu dari pendatang baru dalam dunia database ialah MySQL, sebuah server/klien database SQL yang berasal dari Skandinavia. MySQL terdiri atas server SQL, klien program untuk mengakses server, tools untuk administrasi, dan interface program untuk menulis program sendiri. Pengembangan MySQL dimulai pada tahun 1979 dengan ...

Read More »

AND and OR Conjunctive Operators – SQL

AND and OR Conjunctive Operators – SQL are used to combine multiple conditions to narrow data in an SQL statement. These two operators are called conjunctive operators. These operators provide a means to make multiple comparisons with different operators in the same SQL statement. The AND Operator: The AND operator allows the existence of multiple conditions in an SQL statement’s ...

Read More »

TRUNCATE TABLE Command – SQL

TRUNCATE TABLE Command – SQL – is used to delete complete data from an existing table. You can also use DROP TABLE command to delete complete table but it would remove complete table structure form the database and you would need to re-create this table once again if you wish you store some data. Syntax: The basic syntax of TRUNCATE ...

Read More »