Enjoy free codes

What is MySQL ?

2009-02-03T17:09:00.001-08:00

MySQL is a relational database management system. It is a Open Source SQL database provided by MySQL AB. MySQL is very fast, reliable, and easy to use. It also has a very practical set of features developed in very close cooperation with our users. MySQL was originally developed to handle very large databases much faster than existing solutions and has been successfully used in highly demanding production environments for several years. Though under constant development, MySQL today offers a rich and very useful set of functions. The connectivity, speed, and security make MySQL highly suited for accessing databases on the Internet.

how to create table

2009-02-03T17:02:00.000-08:00

1. CREATE TABLE `tutorial_users` (
2.
3. `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
4.
5. `username` VARCHAR( 50 ) NOT NULL ,
6.
7. `admin` TINYINT( 1 ) NOT NULL DEFAULT '0',
8.
9. PRIMARY KEY ( `id` )
10.
11. ) ENGINE = innodb;

When using variable variables this is invalid

2009-02-03T04:54:00.000-08:00

When using variable variables this is invalid: $my_variable_{$type}_name = true; to get around this do something like: $n="my_variable_{$type}_name"; ${$n} = true; (or $$n - I tend to use curly brackets out of habit as it helps t reduce bugs ...)