Re: table lock
Eli Shemer wrote:
>
>
> The web site on the other end reads all the data from the table and
> generates standard html/css code with the information from the table.
> How can I make all of the apache child processes wait for the external
> script to complete its operation once it has started?
Alternatively,
Create a new table which has similar table definition as the one to which
your script is writing the data.
'
CREATE TABLE new_tbl LIKE orig_tbl;
'
populate new_tbl with your data and then rename it to orig_tbl - 'rename
table new_tbl to orig_tbl' (rename is atomic operation)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx