- PHP 5
- MySQL or some other DB (if you are planning to use a database)
When you select data, there’s a good chance that you’re looking for something specific. In using the SELECT statement you can attach a WHERE clause to limit the data that you are looking through. If you’re very good and know what you’re looking for then you can use the WHERE clause to find exactly what you want.
Like table names and columns, a user name must follow the same rules. There is one minor difference. A user name can contain a dollar sign.
CREATE USER username [ IDENTIFIED BY password ] [ PASSWORD EXPIRE ]