Tutorials by tizag.com
In is a special kind of operator for use in your where clauses. Recall that in a where expression only one value is allowed to be sent through the query. With the in operator one can send multiple values in the where clause.
October 15,
2009
Today Views:
1 Total Views:
1,242
You may or may not know that MySQL databases are just files that are stored on your web server. This fact makes the whole backup and restore process extremely simple and painless once you have figured out how to do it.
October 14,
2009
Today Views:
2 Total Views:
1,059
In SQL case works with either the select or update clauses. It provides when-then-else functionality (WHEN this_happens THEN do_this) also known as conditional statements.
September 28,
2009
Today Views:
2 Total Views:
2,403
If you follow our warehouse example, a SQL table would be the physical shelving inside our vacant warehouse.
September 26,
2009
Today Views:
1 Total Views:
1,425
This lesson will teach you how to do a specialized join: left join.
September 24,
2009
Today Views:
1 Total Views:
4,831
Before you can do anything with MySQL in PHP you must first establish a connection to your web host's MySQL database. This is done with the MySQL connect function.
September 22,
2009
Today Views:
1 Total Views:
1,252
A very useful aspect of PHP is its ability to manage file uploads to your server. Allowing users to upload a file to your server opens a whole can of worms, so please be careful when enabling file uploads.
September 21,
2009
Today Views:
1 Total Views:
1,039
The alter clause changes a table by adding, removing, or modifying an existing table column.
September 10,
2009
Today Views:
2 Total Views:
1,256
The where clause sets a conditional statement for your queries. Your server will query the database searching for rows that meet your specific where condition. A typical query will have the following syntax.
September 3,
2009
Today Views:
1 Total Views:
1,097
In SQL, queries begin with the select clause. A typical query statement needs only two parts, we select what from where. The what will represent columns of your table you wish to select and the where represents the table name of your data table.
August 21,
2009
Today Views:
2 Total Views:
1,473
