|
|
| Specifications for Portal Preferences |
|
|
|
|
|
|
|
  |
|
Back to the Conceptual Data Model.
'users' Table in mySQL :-
mysql> describe users
-> ;
+-----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+----------------+
| UserID | int(11) | | PRI | NULL | auto_increment |
| UserName | varchar(50) | YES | | NULL | |
| Password | varchar(50) | YES | | NULL | |
| Email | varchar(100) | YES | | NULL | |
| Page_Careers | varchar(25) | YES | | NULL | |
| Page_DataModels | varchar(25) | YES | | NULL | |
| Page_Search | varchar(25) | YES | | NULL | |
| Page_SiteMap | varchar(25) | YES | | NULL | |
| Photo | int(11) | YES | | 0 | |
+-----------------+--------------+------+-----+---------+----------------+
9 rows in set (0.01 sec)
mysql> select username,password,email from users;
+----------+----------+-----------------------------+
| username | password | email |
+----------+----------+-----------------------------+
| barryw | miami3 | barryw@gmisystems.com |
| bdimple | miami3 | bdimple@databaseanswers.com |
+----------+----------+-----------------------------+
2 rows in set (0.00 sec)
********************************************
MySQL :-
tutorials TABLE :-
mysql> describe tutorials;
+----------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+-------+
| tutorial_code | varchar(10) | | PRI | | |
| tutorial_name | varchar(50) | YES | | NULL | |
| tutorial_description | varchar(255) | YES | | NULL | |
+----------------------+--------------+------+-----+---------+-------+
3 rows in set (0.01 sec)
DATA IN THE tutorials TABLE :-
mysql> select tutorial_code,tutorial_name from tutorials;
+---------------+------------------+
| tutorial_code | tutorial_name |
+---------------+------------------+
| INSTAL_9I | Instal Oracle 9i |
+---------------+------------------+
1 row in set (0.00 sec)
mysql>
|
|
|