Tutorial First steps in setting up tables in mySQL
Short Description
In this tutorial we will find out how to create a database, then create a table and populate it with data. We will also look at one or two issues that may occur, and look at ways of solving them. The brief is to create a user database that can be accessed via a web browser for user authentication. This is effectively the means to provide a gateway into a secure or subscription only web site.
Website: www.jup-it-er.co.uk | Filesize: 140kb
No of Page(s): 11
Content
…
We could just issue the create database command, and everything would work fine. A new database will be created, and we are all set to create tables and populate the database and link up to our browser and invite users to log on to our site and… Whoa! Let’s just slow down a bit. OK. We could just issue the create database command, but there may already be a database with the same name on our server. What would happen then? Well, we could easily overwrite the existing database, if we are not careful. If it contains payroll data, for example, you and your colleagues won’t receive your pay cheque this month, and it will all be your fault when all those families get evicted from their homes . well, actually, it’s not as bad as that. MySQL won’t allow us to do it, so we are covered. However, good practice suggests that we cannot rely on the DBMS (Data Base Management System) to keep us out of trouble.
…
Get the file Download here
Related Searches: base management system, data base management, data base management system, payroll data, database command
Comments
Leave a Reply
