Updating datbase


01-Feb-2020 17:38

Data can be updated into My SQL tables by executing SQL UPDATE statement through PHP function mysql_query.

Specifies the name of the directory that will contain migrations code files.

Specifies the directory to use for the app-domain that is used for running Migrations code such that the app-domain is able to find all required assemblies.

This is an advanced option that should only be needed if the solution contains several projects such that the assemblies needed for the context and configuration are not all referenced from either the project containing the context or the project containing the migrations.

Description End Sub Sub Insert Into() 'Declare some variables Dim cnn As adodb. Command Dim str SQL As String 'Create a new Connection object Set cnn = New adodb. Connection String = "Provider=SQLOLEDB.1; Integrated Security=SSPI; Persist Security Info=True; Initial Catalog=Northwind; Data Source=Excel-PC\SQLEXPRESS" 'cnn.

Active Connection = con 'delete all records first if checkbox checked If . Execute "delete from tbl_demo" End If 'set first row with records to import 'you could also just loop thru a range if you want. Close Set con = Nothing End With Exit Sub err H: Msg Box Err.

To update a record in any table it is required to locate that record by using a conditional clause.