learning (my)sql 101

[dlanyer77]

---

base on you latest statement.

_________________________________________________

UPDATE mysql_data_files
SET location = 'Boracay Mansion'
WHERE fname = 'Joseph' AND lname = 'Ejercito'

or

UPDATE mysql_data_files
SET location = 'Boracay Mansion'
WHERE fname = 'Joseph' AND lname = 'Ejercito'
AND location IS NULL;

[anggwaponi]

bai dlanyer77 ug cold_fusion maayong adlaw .

salamat kaayo ninyong duha ... nalamdagan gyud ko gamay bahin aning SQL. sa pagkakaron, inubanan sa akong gamay nga research ... kabalo-balo na sab ko .

tingali magsugod na sab ko ACCESS o MS Access kay konektado man konuhay ni. hinaut naa mo ika-suggest unsaon o nganung mogamit ACCESS ang SQL o is it neccessary ba gyud and in what way ? hmmmmmmm ...

nagkakulbahinam na sab ni balik lyk before kadtu ako gi-post sa una mahitungod sa networking .

well, i'm sure nga daghan tingali nakakuha ug mga bag-ong pagtulun-an o at least nadungagan pud input .

once again, daghan gyud kaayo salamat .


matsalams :mrgreen:

[cold_fusion]

MsAccess has Jet engine which is already SQL based.
You can create SQL queries in the "Queries" tab either visually (dragging, point & click) or hardcode the SQL query yourself by using "SQL view".

[dlanyer77]

Bro, MS ACCESS is a database while SQL is the standard language designed to access relational database. Maybe you mean to say why MS ACCESS use SQL.

[cold_fusion]

Bro, MS ACCESS is a database while SQL is the standard language designed to access relational database. Maybe you mean to say why MS ACCESS use SQL.

I think many does not know that MsAccess has a built-in SQL engine. This is MsJET http://en.wikipedia.org/wiki/Microso...atabase_Engine .
Most use MsAccess as just a storage engine to VB, web or such and not using its full potential.
But MsAccess itself can be an independent system with the SQL engine and VBA running as application.

MsAccess can be even be the front-end of MsSQL or MySQL and is even better than VB.

[anggwaponi]

Bro, MS ACCESS is a database while SQL is the standard language designed to access relational database. Maybe you mean to say why MS ACCESS use SQL.

hello bai dlanyer77

ug mura saktu ka ana imo gisulti bai dlanyer77 ... he he he. saun ... maglisud pa man gud ko identify o distinguish anang mga butanga. pero salamat imo na gi-brought up :mrgreen:.

so unsaon man na bai dlanyer77 pag-function between MS ACCESS using SQL ? ... nakakita man gud ko na mura connect2x. then nakakita pud ko EXCEL gi-input sa SQL then mura gi-link sa MS Access (i dunno if saktu ba ko ... pero di na ako taghap2x ha, nakakita gyud ko ) .

nindut kun makahatag ka sample o link .

happy weekendsa tanan .


matsalams

[dlanyer77]

@anggwaponi

yes pwede kau ang MS EXCEL mo connect sa MS ACCESS and you can either put your SQL on MS EXCEL or to MS ACCESS. I even use MS EXCEL to connect to Oracle10g databases and use it like Oracle Discoverers functionality.