• Welcome to Overclockers Forums! Join us to reply in threads, receive reduced ads, and to customize your site experience!

Can I use SQL to create a catalogue?

Overclockers is supported by our readers. When you click a link to make a purchase, we may earn a commission. Learn More.

grs

Member
Joined
Apr 3, 2006
Location
Dublin, Ireland
I'm new to SQL which I am running on a Clarkconnect server. It was required for torrentflux.
I have smoe limited experience of MS Access.
Can I use SQL to create an online catalogue for something like a library?
I've created a database with a table called books and I've managed to add several fields for data, title, author, year. How do I go about creating records to fill the fields?
 
use databasename;
insert into table 'field name' 'field name' 'value' 'value';

The above will get you started, the question is which SQL are you using, they are all different. If its mySQL, go here -> http://dev.mysql.com/doc/
 
I'm not sure of the version, does phpMyAdmin or MySQL mean anything?
Where do I type in that command?

Isn't there a way of just filling out tables with the data I want.
 
Last edited:
Back