All posts in category 'MariaDB'

• Mariadb While Statement

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the WHILE statement (WHILE LOOP) in MariaDB with syntax and examples. In MariaDB, the WHILE statement is used when you are not sure how many times you will execute the loop body and the loop body may not execute even once.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Loops While statement While loop
  Read More

• Mariadb Where Clause

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB WHERE clause with syntax and examples. The MariaDB WHERE clause is used to filter the results from a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb where clause Syntax Parameters
  Read More

• Mariadb View

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to create, update, and drop VIEWS in MariaDB with syntax and examples. In MariaDB, a VIEW is not a physical table, but rather, it is in essence a virtual table created by a query joining one or more tables.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb view Create view Update view
  Read More

• Mariadb Upper Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB UPPER function with syntax and examples. The MariaDB UPPER function converts all characters in the specified string to uppercase.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb upper function Syntax
  Read More

• Mariadb Update Statement

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB UPDATE statement with syntax and examples. The MariaDB UPDATE statement is used to update existing records in a table.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb update statement Syntax Parameters
  Read More

• Mariadb Unique Constraints

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to create, add, and drop unique constraints in MariaDB with syntax and examples. A unique constraint is a single field or combination of fields that uniquely defines a record.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb unique constraint Syntax Example
  Read More

• Mariadb Union Operator

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB UNION operator with syntax and examples. The MariaDB UNION operator is used to combine the result sets of 2 or more SELECT statements. It removes duplicate rows between the various SELECT statements.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb union operator Mariadb union query Syntax
  Read More

• Mariadb Union All Operator

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB UNION ALL operator with syntax and examples. The MariaDB UNION ALL operator is used to combine the result sets of 2 or more SELECT statements.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb union all operator Mariadb union all query Syntax
  Read More

• Mariadb Ucase Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB UCASE function with syntax and examples. The MariaDB UCASE function converts all characters in the specified string to uppercase.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb ucase function Syntax
  Read More

• Mariadb Truncate Table Statement

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB TRUNCATE TABLE statement with syntax and examples. The TRUNCATE TABLE statement is used to remove all records from a table in MariaDB.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb truncate table statement Syntax Parameters
  Read More

• Mariadb Trim Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB TRIM function with syntax and examples. The MariaDB TRIM function removes all specified characters either from the beginning or the end of a string.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb trim function Syntax
  Read More

• Mariadb Substring_index Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB SUBSTRING_INDEX function with syntax and examples. The MariaDB SUBSTRING_INDEX function returns the substring of string before number of occurrences of delimiter.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb substring_index function Syntax
  Read More

• Mariadb Substring Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB SUBSTRING function with syntax and examples. The MariaDB SUBSTRING function allows you to extract a substring from a string.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb substring function Syntax
  Read More

• Mariadb Substr Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB SUBSTR function with syntax and examples. The MariaDB SUBSTR function allows you to extract a substring from a string.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb substr function Syntax
  Read More

• Mariadb Subqueries

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use subqueries in MariaDB with syntax and examples. In MariaDB, a subquery is a query within a query. You can create subqueries within your SQL statements.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb subqueries Subquery Syntax
  Read More

• Mariadb Strcmp Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB STRCMP function with syntax and examples. The MariaDB STRCMP function tests whether two strings are the same using the current character set.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb strcmp function Syntax
  Read More

• Mariadb Space Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB SPACE function with syntax and examples. The MariaDB SPACE function returns a string with a specified number of spaces.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb space function Syntax
  Read More

• Mariadb Show Grants For A User In Mariadb

  
  November 24, 2014

  AODBA
  Is there a query to run in MariaDB that will show all grants for a User? In MariaDB, you can use the SHOW GRANTS command to display all grant information for a user. This would display privileges that were assigned to the user using the GRANT command.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Retrieve grant information for a user Tutorial
  Read More

• Mariadb Set Up A Handler For Cursor's Not Found Condition

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to set up a handler for the NOT FOUND condition for a cursor in MariaDB with syntax and examples. If you try to fetch data from a cursor and there are no rows, MariaDB will raise a NO DATA error.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Cursors Not found handler Syntax
  Read More

• Mariadb Sequences (auto_increment)

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to create sequences using the AUTO_INCREMENT attribute in MariaDB with syntax and examples. In MariaDB, you can create a column that contains a sequence of numbers (1, 2, 3, and so on) by using the AUTO_INCREMENT attribute.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Auto_increment attribute in mariadb Autonumber in mariadb Sequences in mariadb
  Read More

• Mariadb Select Statement

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB SELECT statement with syntax and examples. The MariaDB SELECT statement is used to retrieve records from one or more tables in MariaDB.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb select statement Syntax Parameters
  Read More

• Mariadb Select Limit Statement

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the SELECT LIMIT statement in MariaDB with syntax and examples. The MariaDB SELECT LIMIT statement is used to retrieve records from one or more tables in MariaDB and limit the number of records returned based on a limit value.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb select limit statement Syntax Parameters
  Read More

• Mariadb Rtrim Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB RTRIM function with syntax and examples. The MariaDB RTRIM function removes all space characters from the right-hand side of a string.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb rtrim function Right trim
  Read More

• Mariadb Rpad Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB RPAD function with syntax and examples. The MariaDB RPAD function returns a string that is right-padded with a specified string to a certain length.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb rpad function Syntax
  Read More

• Mariadb Rlike Condition

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB RLIKE condition (to perform regular expression matching) with syntax and examples. * Not to be confused with the LIKE condition which performs simple pattern matching.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb rlike condition Syntax Parameters
  Read More

• Mariadb Right Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB RIGHT function with syntax and examples. The MariaDB RIGHT function allows you to extract a substring from a string, starting from the right-most character.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb right function Syntax
  Read More

• Mariadb Reverse Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB REVERSE function with syntax and examples. The MariaDB REVERSE function returns a string with the characters in reverse order.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb reverse function Syntax
  Read More

• Mariadb Return Statement

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the RETURN statement in MariaDB with syntax and examples. In MariaDB, the RETURN statement is used when you are want to exit a function and return the result of the function.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Loops Return statement How to exit a function
  Read More

• Mariadb Replace Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB REPLACE function with syntax and examples. The MariaDB REPLACE function replaces all occurrences of a specified string.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb replace function Syntax
  Read More

• Mariadb Repeat Statement

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the REPEAT statement (REPEAT UNTIL LOOP) in MariaDB with syntax and examples. In MariaDB, the REPEAT statement is used when you do not know how many times you want the loop body to execute.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Loops Repeat statement Repeat until loop
  Read More

• Mariadb Repeat Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB REPEAT function with syntax and examples. The MariaDB REPEAT function repeats a string a specified number of times.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb repeat function Syntax
  Read More

• Mariadb Rename User Statement

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB RENAME USER statement with syntax and examples. The RENAME USER statement is used to rename a user in the MariaDB databasesite: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Rename user statement Syntax Example
  Read More

• Mariadb Regexp_substr Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB REGEXP_SUBSTR function with syntax and examples. This function, introduced in MariaDB 10.0.5, will allow you to extract a substring in a string using regular expression pattern matching.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb regexp_substr function Syntax
  Read More

• Mariadb Regexp_instr Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB REGEXP_INSTR function with syntax and examples. The MariaDB REGEXP_INSTR function is an extension of the INSTR function. It returns the location of a regular expression pattern in a string.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb regexp_instr function Syntax
  Read More

• Mariadb Regexp Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB REGEXP function with syntax and examples. The MariaDB REGEXP function allows you to perform regular expression matching.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb regexp function Syntax
  Read More

• Mariadb Procedures

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to create and drop procedures in MariaDB with syntax and examples. In MariaDB, a procedure is a stored program that you can pass parameters into.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Create procedure in mariadb Drop procedure in mariadb Syntax
  Read More

• Mariadb Primary Keys

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to create and drop a primary key in MariaDB with syntax and examples. In MariaDB, a primary key is a single field or combination of fields that uniquely defines a record.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb primary keys syntax Example Tutorial
  Read More

• Mariadb Position Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB POSITION function with syntax and examples. The MariaDB POSITION function returns the location of a substring in a string.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb position function Syntax
  Read More

• Mariadb Order By Clause

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB ORDER BY clause with syntax and examples. The MariaDB ORDER BY clause is used to sort the records in your result set.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb order by clause Syntax Parameters
  Read More

• Mariadb Or Condition

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB OR condition with syntax and examples. The MariaDB OR Condition is used to test two or more conditions where records are returned when any one of the conditions are met.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb or condition Syntax Parameters
  Read More

• Mariadb Open Statement

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the OPEN statement to open a cursor in MariaDB with syntax and examples. Once you've declared your cursor in MariaDB, the next step is to use the OPEN statement to open the cursor.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Cursors Open cursor Open statement
  Read More

• Mariadb Not Condition

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB NOT condition with syntax and examples. The MariaDB NOT condition (also called the NOT Operator) is used to negate a condition in a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb not condition Syntax Parameters
  Read More

• Mariadb Mid Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB MID function with syntax and examples. The MariaDB MID function allows you to extract a substring from a string.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb mid function Syntax
  Read More

• Mariadb Ltrim Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB LTRIM function with syntax and examples. The MariaDB LTRIM function removes all space characters from the left-hand side of a string.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb ltrim function Left trim
  Read More

• Mariadb Lpad Function

  
  November 24, 2014

  AODBA
  This MariaDB tutorial explains how to use the MariaDB LPAD function with syntax and examples. The MariaDB LPAD function returns a string that is left-padded with a specified string to a certain length.site: google sitemap xml, Open Graph and plain old meta-tags.
  Mariadb Mariadb functions Mariadb lpad function Syntax
  Read More