I install MYSQL on Redhat 7.1 using RPMs ...
I start the server the same way you do, but
to start it automatically, i went to the control
panel (GNOME) Programs-System-Control Panel
and enter the services and levels configuration (Run level Manager)
and move the MSQLD service from NON
Hello!
I have two tables. One contains invoices, one contains customers.
How do I delete customers that are not linked to any invoice.
The relation is one to many (invoices -- customers).
I can select them with:
select customers.* from customers left join invoices on
You can use ODBC for mysql ... (download from www.mysql.com )
Install it , then just use it ...
To try it, make a Datasource for the ODBC ...
In vb make use a Datawizard form, select remote ODBC ...
then select the datasource you create it ...
and you have a simple maintainance form to a table