The solution is to change the type of the column post_parent: cd "C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\" mysql.exe –u root -p Enter password: *********************** mysql> use MyWordpressDatabase Database changed mysql> ALTER TABLE wp_posts CHANGE post_parent
Keyboard Shortcut Description F12 Go to definition Ctrl+Shift+8 Go back to place you invoked “Got to definition (F12)” Shift+F12 Go to references, if you used F12 you could use Shift+F12 to go back to
This article describes how to create a application that can show you all undisposed objects in running assemblies. http://www.codeproject.com/KB/dotnet/undisposed.aspx
This post will be edited each time I find a best practice for TSQL Never use <,>,<=,=> on datetime, always use datediff
After installing SourceGear Vault client v3.1.9 on a Microsoft Windows 7 RTM 64bit machine, opening a new tab in Microsoft Internet Explorer 8 (32 bit), by pressing ctrl + click on a link, the new
http://blog.brothersoft.com/tag/windows-7-theme-canada/
I just installed Microsoft Windows 7 and the things I noticed where: (these are not necessarily new features) > During the installation you can simply set Language: English, Regional Settings: Dutch and Keyboard layout: Us
SQL Server 2005 onwards: if not exists(select 1 from sys.columns where Name = N’columnName’ and Object_ID = Object_ID(N’tableName’)) begin — Column does not exist end http://stackoverflow.com/questions/133031/how-to-check-if-column-exists-in-sql-server-table
This article will be updated every time I run into a best practice. Checklist Microsoft Visual Studio 2008 Solution and Projects – Solution name should be Customer.Product.sln, like MyCustomer.MyProduct.sln – Project name should be Customer.Product.Subsystem.csproj,
To insert a image from filesystem to a Microsoft SQL Server 2008 database with a TSQL query, use: INSERT INTO MyTable(MyImageColumn) SELECT * FROM OPENROWSET(BULK N'C:\Image1.jpg', SINGLE_BLOB)