Ejercicios de MySQL: insertar datos en la tabla libro de la base de datos librería
(2 votes, average: 5.00 out of 5)
Loading...1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | #Realizado por Santiago Candamil [void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data") $Connection = New-Object MySql.Data.MySqlClient.MySqlConnection $ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"libreria" $Connection.ConnectionString = $ConnectionString $Connection.Open() ################################### #Insertar en la tabla libro ################################### $Query = 'insert into libro (titulo, IDautor, añoedicion, CIFeditorial, precio, nejemplares, ISBN) values("SOM",6,2011,"C12345678",25,3,"9540615377117");' $Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection) $DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command) $DataSet = New-Object System.Data.DataSet $RecordCount = $dataAdapter.Fill($dataSet, "data") $DataSet.Tables[0] $Query1 = 'insert into libro (titulo, IDautor, añoedicion, CIFeditorial, precio, nejemplares, ISBN) values("SOR",5,2012,"C12345678",30,4,"6896369875304");' $Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query1, $Connection) $DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command) $DataSet = New-Object System.Data.DataSet $RecordCount = $dataAdapter.Fill($dataSet, "data") $DataSet.Tables[0] $Connection.Close() |
