A brief MySQL tutorial

Creating and Deleting Databases

1) Creating a database mysql> CREATE database 134a; Query OK, 1 row affected (0.00 sec)
2) Deleting a database mysql> DROP database 134a; Query OK, 0 rows affected (0.00 sec)

Creating a Table

3) After we have created the database we use the USE statement to change the current database; mysql> USE 134a; Database changed
4) Creating a table in the database is achieved with the CREATE table statement mysql> CREATE TABLE president (
-> last_name varchar(15) not null,
-> first_name varchar(15) not null,
-> state varchar(2) not null,
-> city varchar(20) not null,
-> birth date not null default '0000-00-00',
-> death date null
-> );
Query OK, 0 rows affected (0.00 sec)

Examining the Results

5) To see what tables are present in the database use the SHOW tables:
mysql> SHOW tables;
+----------------+
| Tables_in_134a |
+----------------+
| president |
+----------------+
1 row in set (0.00 sec)
6) The command DESCRIBE can be used to view the structure of a table
mysql> DESCRIBE president;
+------------+-------------+------+-----+------------+-------+---------------------------------+
| Field | Type | Null | Key | Default | Extra | Privileges |
+------------+-------------+------+-----+------------+-------+---------------------------------+
| last_name | varchar(15) | | | | | select,insert,update,references |
| first_name | varchar(15) | | | | | select,insert,update,references |
| state | char(2) | | | | | select,insert,update,references |
| city | varchar(20) | | | | | select,insert,update,references |
| birth | date | | | 0000-00-00 | | select,insert,update,references |
| death | date | YES | | NULL | | select,insert,update,references |
+------------+-------------+------+-----+------------+-------+---------------------------------+ Read More ..

Architecture of the Trusted Internet Banking

The development of information technology, telecommunications, and Internet applications causes began the emergence of Internet-based business. One application that was getting noticed is the Internet Banking or often also called e-Banking. Some statistics indicate increasing number of perpetrators of e-Banking in the world. In Indonesia there have been several perpetrators Internet Banking. One well-known actors in society is a service "KlikBCA" of BCA. One very important aspect of banking services is the security aspects (security).

Unfortunately, these security issues are often overlooked (both technical and non-technical) and this caused some problems. In Indonesia there are already some news about people who feel their money was stolen through the Internet Banking transactions. The existence of the site "slippage" (typosquatter) that does not belong kilkbca.com BCA will be made to resemble klikbca.com but also tarnish the fact that Internet Banking in Indonesia. If this problem is not solved, then public confidence will be safe Internet Banking transactions become faded and avoidable causes of this service. Security problem is one of a fairly complex topic. The discussion in this paper can not completely and just focused on Internet Banking application. Read More ..

HTML and CSS

Hypertext Markup Language is standard language used to display the web document, you can do with HTML that is:

1. Controlling the display of the web page and its content.
2. Publishes an online document that can be accessed from around the world.
3. Create online forms that can be used to handle registration, transactions online.
4. Adding object-object such as image, audio, video, and also java applets in the HTML document.

Style Sheets is a very important feature in a Dynamic HTML. Although not a necessity in making the web, but the use of style sheets is an advantage. A style sheet is a place where you control and manage-style style there. Style sheets describe how the HTML document display on the screen. You can also call it as a template from HTML documents that use it. You can also make special effects on your website using style sheets.

Theoretically you can use style sheets with HTML technology. However, in practice only Cascading Style Sheets (CSS) technology that support in almost all web browsers. Because CSS has been in standard by the World Wide Web Consortium (W3C) for use in a web browser. This tutorial will explain about html and CSS. Read More ..