Page 1 of 1

MySQL+Delphi 7 Data inserting

Posted: 15.01.2006, 20:13
by Karys
I'm pretty much new tu MySQL, and completly new to accessin MySQL DB through delphi :roll:

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 :roll:

Posted: 01.02.2006, 12:53
by 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.

Posted: 01.02.2006, 17:01
by 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 :D )

Topic can be locked ;)

Posted: 14.10.2006, 07:01
by 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