Camne Nak Select Guna Character...

[dekzorro 0]

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...

[hafizzd 0]

yang soklan sql tu lebih kurang cam ni la jawapan die

SELECT * FROM Persons WHERE FirstName='a%'

so maybe result die akan jadi

ali

ahmad

abu

camtu la

selamat mencuba

[abc686 0]

solan 2: ader tak command utk convert excell ke MySQL...

aku assume ko tau pasal odbc

1. Dlm Access, import data dr excel.

File -> Get external data -> Import

2. 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

[dekzorro 0]

timakcih kawan²..