Eine Einführung in
|
| SQLite | ||
| If I have a column whose name contains a space, e.g. "Account Balance", I can't seem to select it. SELECT Account Balance FROM MyTable gets an error SELECT 'Account Balance' FROM MyTable also gets an error. What should I do? | ||
| Specific to SQLite | ||
| Use double quotes - better yet - don't put spaces in field names. | ||
| DB2 | ||
| If I have a column whose name contains a space, e.g. "Account Balance", I can't seem to select it. SELECT Account Balance FROM MyTable gets an error SELECT 'Account Balance' FROM MyTable also gets an error. What should I do? | ||
| Specific to DB2 | ||
| none | ||
| MS Access | ||
| If I have a column whose name contains a space, e.g. "Account Balance", I can't seem to select it. SELECT Account Balance FROM MyTable gets an error SELECT 'Account Balance' FROM MyTable also gets an error. What should I do? | ||
| Specific to MS Access | ||
| Use square brackets - better yet - don't put spaces in field names. | ||
| PostgreSQL | ||
| If I have a column whose name contains a space, e.g. "Account Balance", I can't seem to select it. SELECT Account Balance FROM MyTable gets an error SELECT 'Account Balance' FROM MyTable also gets an error. What should I do? | ||
| Specific to PostgreSQL | ||
| Use double quotes - better yet - don't put spaces in field names. | ||
| Oracle | ||
| If I have a column whose name contains a space, e.g. "Account Balance", I can't seem to select it. SELECT Account Balance FROM MyTable gets an error SELECT 'Account Balance' FROM MyTable also gets an error. What should I do? | ||
| Specific to Oracle | ||
| Use double quotes - better yet - don't put spaces in field names. | ||
| MS SQL Server | ||
| If I have a column whose name contains a space, e.g. "Account Balance", I can't seem to select it. SELECT Account Balance FROM MyTable gets an error SELECT 'Account Balance' FROM MyTable also gets an error. What should I do? | ||
| Specific to MS SQL Server | ||
| none | ||
| MySQL | ||
| If I have a column whose name contains a space, e.g. "Account Balance", I can't seem to select it. SELECT Account Balance FROM MyTable gets an error SELECT 'Account Balance' FROM MyTable also gets an error. What should I do? | ||
| Specific to MySQL | ||
| Use back ticks - better yet - don't put spaces in field names. | ||
| Sybase | ||
| If I have a column whose name contains a space, e.g. "Account Balance", I can't seem to select it. SELECT Account Balance FROM MyTable gets an error SELECT 'Account Balance' FROM MyTable also gets an error. What should I do? | ||
| Specific to Sybase | ||
| none | ||
| Mimer SQL | ||
| If I have a column whose name contains a space, e.g. "Account Balance", I can't seem to select it. SELECT Account Balance FROM MyTable gets an error SELECT 'Account Balance' FROM MyTable also gets an error. What should I do? | ||
| Specific to Mimer SQL | ||
| none | ||