in php, if i connect to a sql database, and say i do an INSERT, but i do not commit, will that entry be added to the database or not? I know commit makes it permanent, but i was wondering if i dont COMMIT it will it still appear in hte database table ?
@AdamGundryOct 03.2004 — #It may depend on the database, but normally if you do not specifically start a transaction (with BEGIN or similar) then the data will be automatically committed and visible to other connections. [url=http://www.databasejournal.com/features/mysql/article.php/3382171]This article[/url] explains the situation for MySQL.