How to reset auto-increment values?
May 26th, 2016
Auto-increment feature assigned to a column generates a unique key to the row. The attribute ge...
MySQL Advanced
Error handling in stored procedures
May 26th, 2016
When an error is found during execution of a stored procedure, it can be handled in MySQL in two ways. The current block may continue to execute by throwing a warning or exit from executin...
Raising Error Conditions with SIGNAL / RESIGNAL Statements
May 26th, 2016
The SIGNAL statements are used as a way to return an error message appearing during code execution. These statements provide...
Comparing two MySQL tables
May 26th, 2016
When data is moved from one database or server to another, we need to compare two tables to identify if the data is valid to be migrated or not. If we have a legacy database whose data has to be mi...
How to copying a table in MySQL
May 26th, 2016
Sometimes we need to copy a table from MySQL database to another one, whether because of a backup or building another, similar table, or any another reason. When a table has to be cloned for applic...
Article Categories
Tutorial Chapters
- HTML Tutorial
-
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
- HTML5 Tutorial
-
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
Directory
