ASP Is Fun

ASP Is Fun

ASP Classic Code and Contracting

  • Home
  • ASP Course
  • Functions / Commands
  • Sample ASP Code
  • ASP Books
  • ASP Contract Programming
  • Blog

SQL Commands

WordPress Tips

WordPress Featured Image Permissions Problem on IIS

November 14, 2019 Lisa Shea 2

If you are using WordPress on a Microsoft Windows server, using IIS to manage your website, then you can easily run into permissions problems as […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
MySQL Settings

MySQL Workbench – Increasing Connection Time

November 13, 2019 Lisa Shea 0

If you do a lot of work with MySQL, you’re probably using MySQL Workbench to manage your databases and schemas. Once you start working with […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

MySQL Schema Inspector Reporting Wrong Row Counts

November 10, 2019 Lisa Shea 0

When you use reports in MySQL, you expect them to be accurate. Let’s take, for example, the MySQL Schema Inspector. When you use the schema […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

Comparing MySQL Data Across Schema

November 10, 2019 Lisa Shea 0

There are all sorts of reasons you might want to compare data between two tables in different schema. A common situation is that you’re moving […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

MySQL Dump Not Exporting All Rows

November 10, 2019 Lisa Shea 2

This example is a lesson in double-checking what you think you’re seeing. I just invested a half hour in trying to solve a problem which […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

Changing a MySQL Schema Name

November 10, 2019 Lisa Shea 0

You’ve got your MySQL database up and running. Everything is going smoothly. But then for some reason you need to change your MySQL schema name. […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

MSSQL and Character Set Issues

July 2, 2018 Lisa Shea 0

One of the most troubling parts of ASP and SQL for new programmers can be how to handle apostrophes and other special characters. Here is […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

Joining Tables in SQL

February 1, 2018 Lisa Shea 0

Do you have two tables, and want to be able to calculate totals and merge information across them? Just join them together! This isn’t even […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

MySQL Optimizing Tips

December 1, 2017 Lisa Shea 0

If you are working with a MySQL database, it is important to optimize the database so it runs as quickly as possible. Here are some […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

Create a Table with SQL Syntax

October 1, 2017 Lisa Shea 0

Need to create a table to put data in? It’s very easy to put together SQL Syntax to build the table to store your newsletter […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...

Posts navigation

« 1 2 3 »

Follow Us

  • Twitter
  • Facebook

Recent Posts

  • Setting a Default Font in Word
  • Android Zoom Not Working with Bluetooth Speakers
  • Google *Services on Credit Card Statement
  • Calendar in Microsoft Outlook – Printing Multiple Calendars on One Page
  • Errors Upgrading PHP for a WordPress Blog

Categories

  • ASP Course
  • Basics
  • Books
  • Contracting
  • Functions
  • Hosting
  • Musings
  • News
  • Sample Code
  • SQL Commands
  • Windows and IIS
  • WordPress

Ebooks

Newsletter

Subscribe to our mailing list

* indicates required

Advertising

Archives

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

RSS Link for ASPIsFun

  • RSS - Posts
All content on this site is written by ASP programmer Lisa Shea who is available for contract work. Content copyright (c) 2021. This site is part of the Minerva Webworks site suite.
Hosted By
Tweets by ASPIsFun
Follow Us
  • Twitter
  • Facebook

Copyright © 2023 | WordPress Theme by MH Themes

%d bloggers like this: