MySQL Joins Update Query Tutorial

<P>Open MySQL, connect to the database and open the command line interface.</P><P>Type "UPDATE plane JOIN passengers ON plane.seat = passengers.seat SET plane.occupied = 'Yes' WHERE passengers.name = 'Jim';" into the command line.</P><P>Press the "Enter" key to execute the query. MySQL will find all records in the passengers table that match "Jim" in the name column. It then locates all records in the plane table that have matching data in both tables' "seat" fields. MySQL then updates the records in the plane table to show that the seats Jim owns are now occupied. For example, if Jim buys seats 10 and 11 in the passengers table, this query will change the records for seats 10 and 11 in the plane table to reflect that those two sears are now occupied.</P><P>Type "SELECT * FROM table1" and press "Enter" to execute the query. Examine the results.</P>

MySQL Joins Update Query Tutorial

Open MySQL, connect to the database and open the command line interface. Type "UPDATE plane JOIN passengers ON plane.seat = passengers...

Continue Reading>>

How to Use Variables in Access Query

<P>Open the Northwind Microsoft Office Access database. The Northwind database is included in the Microsoft Office suite.</P><P>Click "Database Tools" then select "Visual Basic" to open the Microsoft Visual Basic Window. Click the "Insert" field and select "Module."</P><P>Copy and paste the following code into your new module to use "Supplier A" as a variable in a select query and view the first name and last name of "Supplier A":</P><P>Private Sub userQueryVariables()</P><P>Dim strSQL As String</P><P>Dim rst As Recordset</P><P>Dim dbs As Database</P><P>Dim supplier As String</P><P>supplier = "Supplier A"</P><P>Set dbs = CurrentDb</P><P>strSQL = "SELECT Suppliers.Company, Suppliers.[Last Name], Suppliers.[First Name] "</P><P>strSQL = strSQL & "FROM Suppliers "</P><P>strSQL = strSQL & "WHERE (((Suppliers.Company)='" & (supplier) & "'));"</P><P>Set rst = dbs.OpenRecordset(strSQL)</P><P>rst.MoveLast</P><P>rst.MoveFirst</P><P>Debug.Print (supplier & " Information:")</P><P>Do While Not rst.EOF</P><P>Debug.Print ("First Name: " & rst.Fields(2).Value)</P><P>Debug.Print ("Last Name: " & rst.Fields(1).Value)</P><P>rst.MoveNext</P><P>Loop</P><P>End Sub</P><P>Press "F5" to run your subroutine.</P><br /><p><a href="http://www.ehow.com/how_7431972_use-variables-access-query.html" rel="nofollow" target="_blank">View the original article here</a></p>

How to Use Variables in Access Query

Open the Northwind Microsoft Office Access database. The Northwind database is included in the Microsoft Office suite. Click "Database...

Continue Reading>>

How to Create a Table From a Query in Access 2003

<P>Open Access 2003. Click the "File" option on the menu bar. Click "Open." Click on your database name and select "Open." The database opens.</P><P>Click the "Query" object in the database. Select the "Create a query in design view" option. The Show Table dialog box appears. Add a table to the query by clicking the "Add" button. Close the Show Table dialog box by clicking the "Close" button.</P><P>Add fields to the query by double-clicking the field names from the table list. Click the "Query Type" icon on the menu bar. A drop-down list appears. Select "Make Table." Type a name for your query in the "Query Name" box. Click "OK."</P><P>Run the query by clicking the "Run" icon on the menu bar. Access prompts you to confirm the pasting of new records into a new table. Click "Yes." Access creates a new table based on the make table query.</P><br /><p><a href="http://www.ehow.com/how_7432007_create-table-query-access-2003.html" rel="nofollow" target="_blank">View the original article here</a></p>

How to Create a Table From a Query in Access 2003

Open Access 2003. Click the "File" option on the menu bar. Click "Open." Click on your database name and select "O...

Continue Reading>>