Mysl, MSSQL, Oracle, SQLITE, POSTGRES
Getting the last inserted ID in PHP(Mysql) is not too bad. I am assuming that you already have a connection to the database; echo mysql_insert_id(); or $result = mysql_query (‘SELECT LAST_INSERT_ID()’); $row = mysql_fetch_array($result); echo … Read more
If you try to run this query below in MySQL UPDATE XXX SET count = count + 5000 WHERE id IN ( SELECT id FROM XXX WHERE id > 2 ) ; You will get … Read more
“SQL Server Setup failed to modify security permissions on registry key SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib for user XXXX. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL … Read more
I am writing this post for all the Microsoft pundits out there whose answers to a question such as “How do i export data to an excel spreadsheet using ssis?” is the following “it is … Read more
Cannot connect to Database server – Cannot start SSH tunnel manager (mysql workbench 5.2.33 or earlier) Cause: Corrupted PYTHONHOME system variable. Solution : Add the mysql workbench python path to the system variable. The Mysql … Read more
