Demonstration of running the project AdvantShop.NET asp.net shopping cart via Visual Studio.NET 2008 + SQL Server 2005. For more information about ASP.NET eCommerce Shopping Cart, please go to www.advantshop.com
Archive for the ‘MYSQL’ Category
Run asp.net shopping cart AdVantShop.NET via Visual Studio.NET 2008 + SQL Server 2005
Posted: 2nd January 2011 by admin in MYSQLTags: 2005, 2008, AdVantShop.NET, ASP.NET, Cart, Server, shopping, Studio.net, Visual
0
MySQL Tutorial (5) UPDATE
Posted: 30th December 2010 by admin in MYSQLTags: MYSQL, Tutorial, UPDATE
With great power comes great responsibility, DO NOT FORGET to use a WHERE statement! You will use this pretty-much with EVERY UPDATE command! jream.com
The MySQL Console is good to get comfortable in, it’s the same thing we were doing with Heidi SQL, except it’s not as fun to type in and it’s easy to typo’s that you have to redo everything with. I’m showing you so that you know it’s available to you, I never use it, but [...]
MySQL Tutorial (11) Sub Query
Posted: 30th December 2010 by admin in MYSQLTags: MYSQL, query, Tutorial
This ones tricky guys! We are going to create a Query within a Query. Please take your time to see the code and think about what is happening so you understand. The SELECT statement in the SUB QUERY compares it to the MAIN QUERY’s WHERE statement. Confused? Study the code a few times! jream.com
Welcome to the MySQL ALIAS tutorial. A MySQL ALIAS is like a shortcut on your desktop, it points to the actual real thing. You can use these to shorten your SQL code and make everything much more readable. I use these all the time, mainly when I do joins and sub-queries, otherwise I don’t bother. [...]