Summary of SQL statement execution in Delphi

Use tquery:
query1.close;
query1. SQL. clear;
query1. SQL. add (insert into mytable values (1,23, AA);
query1.execsql;
for select statements, change query1.execsql to query1.open.
Use tadoquery as the same as above.
Use TADODataSet ( select only ):
adodataset1.close;
adodataset1.commandtext: = select * From mytable;
adodataset1.open;

 For I: = 0 to ds1.recordcount-1 do
Begin
Showmessage (Ds1.fieldvalues ['name']);
Ds1.next;
End;

Use tadocommand (Cannot select): 
Adocommand1.commandtext: = insert into mytable values (1, 23, AA );
Adocommand1.execute

 

How to dynamically create a table in Delphi

Use the adoquery Control
Connect to the database first
Adoquery1.close;
Adoquery1. SQL. Clear;
Adoquery1. SQL. Add ('create Table Name (student ID char (20), name char (20), Class char (20 ))');
Adoquery1.execsql;
Yes.