If you want to append the content of one table to another table you can use this statement:
INSERT INTO table1 (field1, field2) SELECT field1, field FROM table2
Append one table to another
Reply
Visual Studio 11– optimized Reference Manager
Actually I am testing Visual Studio 11 Beta. I noticed that the reference manager was optimized: you can check or uncheck multiple items and the third party assemblies are separated in a new category “Extensions” (the default assemblies are listed in category “Framework”).
Missing msvcr100.dll
Today I had a problem starting my WPF application on a client machine. The application uses system.data.sqlite in version 1.0.79.0. I deployed the System.Data.SQLite.dll like mentioned in the readme file. The application failed loading data from sqlite database because msvcr100.dll is missed.
To fix this problem install the setup from http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki to the client pc or look for the necessary Visual C++ redistributable package and install this to the client pc. Here is for instance the address of the Visual C++ 2010 Redistributable Package for x86 systems: http://www.microsoft.com/download/en/details.aspx?id=5555
Howto backup MySQL webserver database automatically
MySQLDumper is a very handy tool for automatic backups of MySQL databases. You don’t have to care about the hosters maximum script execution time. The backup can be send per e-mail, placed in your webspace or can be send per FTP, can be split into several files.
Here is the list of functions: http://www.mysqldumper.de/funktionen/
And here are some screenshots: http://www.mysqldumper.de/screenshots/
The backup can be done per cronjob, so you don’t have to care about forgotten backups.
Lösungswege für das Buch Brückenkurs Mathematik
Ich arbeite derzeit das Buch Brückenkurs Mathematik für Studieneinsteiger aller Disziplinen (ISBN 9783827427632) durch. Nachdem ich gern den Lösungsweg einer Beispielaufgabe wissen wollte, habe ich etwas im Internet recherchiert und bin fündig geworden: die Lösungswege werden vom Springer Verlag zum Download angeboten.
Auf der Seite http://www.springer.com/springer+spektrum/mathematik/book/978-3-8274-2763-2?changeHeader findet man im rechten Bereich den Punkt “Zusätzliche Informationen” und kann sich über die folgende URL das PDF herunterladen: http://www.springer.com/cda/content/document/cda_downloaddocument/Lösungen_Walz_Auflage2%2B3.pdf?SGWID=0-0-45-1100138-p174102260
WordPress: howto link to an external URL in menu bar
This plugin allows you to make a WordPress page or post link to an external URL instead of its WordPress page or post URL: http://wordpress.org/extend/plugins/page-links-to/
Howto: move your Steam folder
If you want to move your steam folder than move the folder “C:\Program Files (x86)\Steam” to for instance “D:\Games\Steam”.
After moving the folder delete the file ClientRegistry.blob and start steam again.
If Steam-Guard is activated you have to enter your special access code that is emailed to you.
WordPress: replace some text in all your posts
This is a small piece of sql that replaces a string in all your posts.
Ensure that you have a backup of your database before modifying your database!
Call this command for instance in phpmyadmin:
Code Snippet
- update `wp_posts`
- SET `post_content` = REPLACE(`post_content`, "your old text", "your new text")
- WHERE INSTR(`post_content`, "your old text") > 0;
Ubuntu: Howto mount a network share
Code Snippet
- sudo apt-get install samba smbfs smbclient
- sudo mkdir /mnt/foldername
- sudo mount.cifs //yourserver/yourshare /mnt/foldername -o username=<yourusername>,password=<youpassword>
- bzw. sudo mount -t cifs //yourserver/yourshare /mnt/foldername -o username=<yourusername>,password=<youpassword>
Fix: Visual Studio Achievements and FxCop problem
Actually there is a problem with FxCop and Visual Studio Achievements (with Visual Studio Professional): the FxCop assemblies can’t be loaded.
Here is a workaround (note: you have to install FxCop 10.0 – not FxCop 1.36):
x86: You have to copy all files from “C:\Program Files\Microsoft Fxcop 10.0″ to “C:\Program Files\Microsoft Visual Studio 10.0\Team Tools\Static Analysis Tools\FxCop”.
x64: You have to copy all files from “C:\Program Files (x86)\Microsoft Fxcop 10.0″ to “C:\Program Files (x86)\Microsoft Visual Studio 10.0\Team Tools\Static Analysis Tools\FxCop”.