MySQL+Delphi 7 Data inserting

[Karys]

I'm pretty much new tu MySQL, and completly new to accessin MySQL DB through delphi

I allready manages to get my MySQL data viewed(i'm using the standart MySQL learning 'menagerie' DB) , but i can't get data inserted/updated/deleted any help is appreaciatted. A small example would be the best (with the 'menagerie' DB) Karys@parabole.lt

[Guest]

for Insert use INSERT SQL statment.

INSERT INTO tablename
(field1, field2...)
VALUES (value1, value2...)

For update,
UPDATE tablename
SET field1 = newvalue1, field2 = newvalue2

and for Delete use
DELETE FROM tablename WHERE field1 = value1.

Try to find a book for SQL language and read it before You continue with learning.

[Karys]

thank you for your reply, but your post is not the answer i was looking for. What i was mising was the ' ExecSQL ' procedure thnx anyways for the help, i know everything i need to know for now And i do know some basic SQL (mysql documentation rocks )

Topic can be locked

[yayaretina]

or you can try with the componnent from zeos, it's a ZupdateQuery. and the code is same.. just this componnent is especially for that order.insert,update,delete