How to insert capital letters to Mysql?

How to INSERT a SELECT query in MYSQL?

• INSERT INTO Vendor (VName, VPhone, VLoc) VALUES ('Mike Douglas', '260-555-5555', 'Denver, CO)"; The Vendor table also has a field for CarID. There is a Car Table that has the following row: CarID: 89 | Make: Pontiac | Model: GrandAm | Miles: 87000 | Year: 1999 | Now, for the first INSERT command, how do I add the CarID for the above Car table row only and not all other rows? INSERT INTO Vendor(CarID) SELECT CarID FROM Car WHERE (Car.Miles=87000) and (Car.Year=1999) The above query would take that CarID from that one row in Car table, but how do I combine the two INSERT commands above so that the CarID gets updated in the Vendor table from a specific row in the Car table but also updates the above Vendor information too (Vname, VPhone, VLoc) ?

• Answer:

  http://www.google.com/search?q=insert+into+select&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a has links to some examples.