basically this is the first time iam using the iSQL *Plus, i am confused and i just want to no, when you create a table how can you view the actual table you have created, and how do you put data into the table?..
sahirak 0 Newbie Poster
drjohn 56 Posting Pro in Training
If you are at the mysql command line, enter SHOW TABLES .This lists all your tables
To see the fields you have created, try SHOW COLUMNS FROM tablename.
To insert data into a table at the command line
INSERT INTO tablename (list of its fields)
VALUES (list of the values, in th esame order as the fields above).
I really think you should get a good intro level book on MySQL as these are very basic things, and so you need to read up on th etopic before doing anything else.
This one will suit you http://www.sitepoint.com/books/sql1/
If you are using something like XAMPP Lite, it has phpMyAdmin which youwill also find helpful. It's an interface to MySQL.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.