Check out the following web sites for SQL info:
http://www.mysql.com/
http://www.perl.com/ (search for DBI SQL)
http://www.smeal.psu.edu/...tabase/dbmsnote.html
http://www.microsoft.com/technet/default.asp
http://w3.one.net/~jhoffman/sqltut.htm
http://www.sqlcourse.com/
And the basic difference is that Structured Query Language databases are structured differently in terms of the type of fields that can be added to tables and also allow relational databases versus flat files that consume disk space, bandwidth, CPU/Memory and also take a lot more work to make them "relational".
(Found many of these resource searching the Web for SQL flat files databases)
Sort of...it is more involved since you need more modules (DBI for one) installed in your server/account and you also need to create DBI compatible tables (like MySQL).
You will have to re-write modifications that access and write from the "flat file database" into SQL codes that accesses and writes from the DBI compatible tables.
Yes...if you have an understanding of SQL and advanced Perl codes.
Regards,
Eliot Lee
http://www.mysql.com/
http://www.perl.com/ (search for DBI SQL)
http://www.smeal.psu.edu/...tabase/dbmsnote.html
http://www.microsoft.com/technet/default.asp
http://w3.one.net/~jhoffman/sqltut.htm
http://www.sqlcourse.com/
And the basic difference is that Structured Query Language databases are structured differently in terms of the type of fields that can be added to tables and also allow relational databases versus flat files that consume disk space, bandwidth, CPU/Memory and also take a lot more work to make them "relational".
(Found many of these resource searching the Web for SQL flat files databases)
Sort of...it is more involved since you need more modules (DBI for one) installed in your server/account and you also need to create DBI compatible tables (like MySQL).
You will have to re-write modifications that access and write from the "flat file database" into SQL codes that accesses and writes from the DBI compatible tables.
Yes...if you have an understanding of SQL and advanced Perl codes.
Regards,
Eliot Lee