dekzorro 0 Report post Posted June 10, 2005 solan nyer gini:how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?camner nak solved??solan 2: ader tak command utk convert excell ke MySQL... Quote Share this post Link to post Share on other sites
hafizzd 0 Report post Posted June 13, 2005 yang soklan sql tu lebih kurang cam ni la jawapan dieSELECT * FROM Persons WHERE FirstName='a%'so maybe result die akan jadialiahmadabucamtu laselamat mencuba Quote Share this post Link to post Share on other sites
abc686 0 Report post Posted June 14, 2005 (edited) solan 2: ader tak command utk convert excell ke MySQL...aku assume ko tau pasal odbc1. Dlm Access, import data dr excel. File -> Get external data -> Import2. Dlm access jugak, lps import, export ke ODBC databases(dekat Save as type tu, pilih ODBC databases). Then ko select la ko nak export kat database mana.. ( select kat Machine Data Source) Edited June 14, 2005 by abc686 Quote Share this post Link to post Share on other sites
dekzorro 0 Report post Posted July 1, 2005 timakcih kawan².. Quote Share this post Link to post Share on other sites