How to create tables for using in SQL/php website

Question

Sorry for asking basic question because I 'm knew.

i was building a dw site for listing multiple products. i was following DW, the Missing Manual book tutorials. The tutorial offers downloadable data tabels in a folder with .sql extension. I just cannot find anywhere an instruction as how the .sql folder is created.

Second question: if it can be created in Access 2007, please tell me how.

thank you sooo much.

David_Powers · Accepted Answer

Thanks, Walt.I have gained some knowledge about the types of relational tables from recent reading and it is great that you pointed out the aspects of migrating from Excel to SQL. What I am trying to work out is a product list for research labs. Here is a snapshot of how the categories look like. categoryID categoryName motherCategoryID1 reagents null2 proteins 13 DNA engineered Proteins 24 enzymes 25 antibodies 16 primary antibodies 57 labeled primary antibodies 68 unlabeled primary antibodies 69 second antibodies 510 buffers 111 pH buffers 1012 non-pH buffers 10......You can tell under the main category 'Reagents' there are several sub categories and each of those include another level of sub categories and it goes on more levels. It is easy work to create a product label, but I am pausing at how to make this category table, so I can properly relate the products.productID to categories.categoryID. I feel I should adopt the categoryIDs of those lowest level categories. For example, for product phosphate buffer, I should link it to #11 pH buffer rather than #10 buffers. More about the category table: Originally I thought I need a category table and a sub-category table, but that doesn't work, because some categories have one lower level sub-categories and some have several lower levels. Making different data sets for different categories will for sure solve this problem, but that makes the database much complicated. So I figured I may create a categories table like the one I just typed. I don't yet know if this is a totally dumb idea. At least this illustrates what I am trying to do. How would you database categories like this?Try reading the following article for guidance. http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html. Life becomes a lot easier when you understand the basic principles of normalization.

bnbwalt · Answer

Files with the .sql extension are just text files that contain SQL query language. In this case, my guess is that the files contain the SQL commands to create tables and maybe even populate them with some data. Not sure about the latter.

They can be imported into MySQL and even into Access. You may have to read the documentation on Access to find out how to import them.

Not sure about your question about a sql folder. Not sure what you mean by that.

Walt

B & B Photography

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.