Difference between revisions of "Netbeans/C3/Connecting-to-a-MySQL-Database/English-timed"

|and allow users to modify only those '''databases''' that are created by their application.  

|Let us now create tables, populate them with data, and modify the data maintained in tables.  

|In the '''Database''' explorer, expand the '''mynewdatabase''' connection node.  

|Let us type a simple query in this ''' SQL''' editor.  

|To execute this query, either right-click the '''Run SQL''' icon in the task bar at the top.  

|Or right-click within the '''SQL Editor''' and choose '''Run Statement.'''

|The '''IDE''' generates the '''Counselor''' table in the '''database. '''

|You can see this message in the '''Output''' window,

|which says that the command was executed successfully,

|To verify these changes, right-click the '''Tables''' node in the '''Database''' Explorer.  

|This updates the current status of the specified '''database. '''

|If you expand the table node, you can see the columns that you created.  

|i.e. Using the Create Table Dialog  

|In the '''Database''' Explorer, right-click the '''Tables''' node, and choose '''Create Table. '''

|In the '''Table''' name text field, type '''Subject'''

|Click on '''Add Column '''

|In the '''Add Column dialogue''', type '''id''' in the '''Name''' field.  

|Select the '''Primary Key''' checkbox in the '''Add Column dialog''' box.  

|This is to specify the primary key for your table.  

|Note that when you select the '''Key''' check box, the '''Index''' and '''Unique''' check boxes are automatically selected;  

|Also the '''Null''' check box is deselected.  

|This is because primary keys are used to identify a unique row in the '''database. '''

|Click OK.  

|We have now created a table named '''Subject''' that will hold data for '''Name, Description,''' and '''Counselor ID'''

|By running '''SQL''' queries on a '''database''', we can add, modify and delete data maintained in '''database''' structures.  

|Let us add a new record to the '''Counselor''' table.  

|A new SQL Editor opens in the main window.  

|In the '''SQL Editor''', let us type a simple query:

| To execute this query, right-click within the source editor, and choose '''Run Statement'''

|Let us now verify if the new record has been added to the table.  

|Right-click the '''Counselor''' table, and choose '''View Data. '''

|The results of this statement are displayed in a table view below the workspace.  

|i.e. '''Counselor''' and '''Subject'''

|Click '''Yes''' in the '''Confirm Object Deletion''' dialogue box.  

|Repeat the same for the '''Subject''' table  

|From the '''File ''' menu, choose '''Open File.'''

|And the script is executed against the selected '''database. '''

|This updates the '''database ''' component to the current status of the specified '''database. '''

|And below the workspace, you can see the data contained in the new tables.  

|In this tutorial you learnt to,

|configure '''MySQL''' on your computer  

|set up a connection to the '''database ''' server from the '''IDE '''

|create, delete, modify data and  

|run '''SQL''' queries  

|Create another database instance with tables  

|Populate these tables with necessary data to maintain your personal book library  

|And run these SQL statements to view data  

|I have created a similar '''database''' which maintains details of my personal movie library.  

|The Spoken Tutorial project team conduct workshops using Spoken Tutorials.  

|Gives certificates to those who pass an online test.  

|For more details please write to contact@spoken-tutorial.org

|Spoken Tutorial Project is a part of the Talk to a Teacher Project

| It is Supported by the National Mission on education through ICT, MHRD, Government  of India

|More information on this mission is available at link provided here

|This tutorial has been  contributed by IT for Change  

|Thank you