Modifying (altering) tables from a database
May 19th, 2016
Changing or modifying a structure of an existing table is done by using ALTER TABLE statement. The "structure" that may be changed with ALTER TABLE includes following opt...
Tutorials
-
CSS Tutorial
-
CSS Basics
-
CSS Selectors
-
CSS Assigning Property Values, Cascading, and Inheritance
-
CSS Media Types
-
CSS Box Model
-
CSS Visual Formatting Model
-
CSS Visual Effects
-
CSS Background Styling
-
CSS Font Styling
-
CSS Text Styling
-
CSS Tables
-
CSS Generated Content
-
CSS Lists and Automatic Numbering
-
CSS User Interface
-
CSS Aural Style Sheets
-
CSS Advanced
-
CSS Examples
-
CSS References
-
-
CSS3 Tutorial
-
CSS3 Basics
-
CSS3 Boxes and Borders
-
CSS3 Backgrounds
-
CSS3 Flexible Boxes
-
CSS3 Colors
-
CSS3 Gradients
-
CSS3 Font Styling
-
CSS3 Text Effects
-
CSS3 Writing Modes
-
CSS3 Multiple Columns
-
CSS3 Transitions
-
CSS3 Transformations
-
CSS3 Animations
-
CSS3 Filter Effects
-
CSS3 Image Values and Replaced Content
-
CSS3 User Interface
-
CSS3 Fragmentation
-
CSS3 Advanced
-
CSS3 Examples
-
CSS3 References
-
-
JavaScript Tutorial
-
JS Basics
-
JS Data Types
-
JS Operators
-
JS Conditional Statements
-
JS Arrays
-
JS Functions
-
JS Regular Expressions
-
JS Date and Time
-
JS Primitive wrappers
-
JS Objects
-
JS Built-in Objects, Global & Math
-
JS Scope and Memory
-
JS Anonymous Functions
-
JS Browser Object Model (BOM)
-
JS Document Object Model (DOM)
-
JS Document Object Model Extensions
-
JS Document Object Model 2 & 3
-
JS Events
-
JS Form Scripting
-
JS Error Handling
-
JS XML Scripting
-
JS Working with Clients
-
JS Advanced
-
JS Examples
-
JS References
-
-
PHP Tutorial
-
PHP Basics
-
PHP Data Types
-
PHP Operators
-
PHP Conditional Statements
-
PHP Control Structures
-
PHP Strings
-
PHP Arrays
-
PHP Functions
-
PHP Classes and Objects
-
PHP Regular Expressions
-
PHP Date and Time
-
PHP Forms
-
PHP Mail Handling
-
PHP File Handling
-
PHP Image Handling
-
PHP Audio Formats
-
PHP Databases
-
PHP XML Manipulation
-
PHP Web Services
-
PHP Mathematical Extensions
-
PHP Credit Card Extensions
-
PHP Advanced
-
PHP Examples
-
PHP References
-
-
MySQL Tutorial
-
MySQL Basics
-
MySQL Data Types
-
MySQL Table and Data Manipulation
-
MySQL Index, Keys and Constraints
-
MySQL Data Queries
-
MySQL Querying Operators
-
MySQL Combining Queries
-
MySQL Character Sets and Collation
-
MySQL Stored Procedures
-
MySQL Triggers
-
MySQL Views
-
MySQL Functions and Operators
-
MySQL Administrational Functions
-
MySQL Advanced
-
MySQL References
-
-
XML Tutorial
-
XML Basics
-
XML Structure
-
XML Document Type Definition
-
XML Entities
-
XML Characters
-
XML Namespaces
-
XML Path (XPath)
-
XML XSLT - XML on Web
-
XML XSLT - Affecting XML Structure
-
XML Styling with CSS
-
XML XLink - XML Linking
-
XML Document Object Model (DOM)
-
XML Document Object Model 2
-
XML Advanced
-
XML Examples
-
XML References
-
Latest Tutorials
Deleting (removing) tables from database
May 19th, 2016
To remove a table from database, the DROP statement must be used, and it usually comes with flags that are used to guide the removal syntax.
Syntax
DROP [TE...
Truncating tables and deleting data from them
May 19th, 2016
In order to delete all data from a table and not the table itself we may use the TRUNCATE TABLE statement.
Syntax
TRUNCATE TABLE employees;
I...
Adding rows to a table (INSERT INTO statement)
May 19th, 2016
The INSERT INTO statement is used very frequently in MySQL and is used to insert a new row in a table.
Syntax
INSERT INTO table_name VALUES (value1, value2,...
Updating data within a table (UPDATE statement)
May 19th, 2016
The UPDATE statement is used to update existing records in a table. The UPDATE statement is always used in combination with
Records deleting in MySQL (DELETE statement)
May 19th, 2016
The DELETE statement deletes record, or records, from MySQL table. In order to delete a specific row or rows the
Replacing rows within a table (REPLACE statement)
May 19th, 2016
The REPLACE statement is a MySQL addition to the SQL, and it is used or could be used to insert and update data in database tables. The REPLACE query work similarly to
What is Auto-increment in MySQL and how to set it?
May 19th, 2016
A very often and commonly used feature in databases in general (and MySQL is not an exemption) is to set a field of a row that will automatically increment the value upon inserting it in a database...
What is MySQL index?
May 20th, 2016
Indexing in MySQL is used to speed up and facilitate data retrieval. If an index has been attached to a column, the MySQL data query "jumps" immediately to that particular row, skipping t...
The UNIQUE constraint in MySQL
May 20th, 2016
The UNIQUE constraint uniquely identifies each record in a database table. The UNIQUE and
