Below given are the some MySQL drivers
- PHP Driver
- JDBC Driver
- ODBC Driver
- C WRAPPER
- PYTHON Driver
- PERL Driver
- RUBY Driver
- CAP11PHP Driver
- Ado.net5.mxj
Below given are the some MySQL drivers
A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. SET column values that consist of multiple set members are specified with members separated by commas (“,”). A consequence of this is that SET member values should not themselves contain commas.
Example
mysql> CREATE TABLE myset (col SET(‘a’, ‘b’, ‘c’, ‘d’));
Query OK, 0 rows affected (0.43 sec)
mysql> select * from myset;
Empty set (0.20 sec)
mysql> insert into myset value(‘p’);
Query OK, 1 row affected, 1 warning (0.23 sec)
mysql> select * from myset;
+——+
| col |
+——+
| |
+——+
1 row in set (0.10 sec)
mysql> insert into myset value(‘a’);
Query OK, 1 row affected (0.18 sec)
mysql> select * from myset;
+——+
| col |
+——+
| |
| a |
+——+
2 rows in set (0.00 sec)
mysql> insert into myset value(‘p,a’);
Query OK, 1 row affected, 1 warning (0.07 sec)
mysql> select * from myset;
+——+
| col |
+——+
| |
| a |
| a |
+——+
3 rows in set (0.00 sec)
Following are the differences between CHAR and VARCHAR:
A regular expression is a powerful way of specifying a pattern for a complex search.
MySQL uses Henry Spencer’s implementation of regular expressions, which is aimed at conformance with POSIX 1003.2. MySQL uses the extended version to support pattern-matching operations performed with the REGEXP operator in SQL statements.
ENUM is a string object used to specify set of predefined values and that can be used during table creation.
CREATE table phpcodez(name ENUM(‘Average’,’Good’,’Excellent’));
CHAR_LENGTH is character count whereas the LENGTH is byte count. The numbers are same for Latin characters but they are different for Unicode and other encodings.
Object-oriented programming (OOP) is a programming language model organized around objects rather than “actions” and data rather than logic. Historically, a program has been viewed as a logical procedure that takes input data, processes it, and produces output data.