Fix Error “1064 (42000): You have an error in your SQL syntax…” When Trying to Convert to an Integer in MySQL

by

If you’re getting error number 1064 that reads something like “1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘INTEGER )’ at line 1“, it could be that you’re using the wrong term for the integer.

MySQL doesn’t let us use just the INTEGER keyword when converting to an integer. We need to use either SIGNED or UNSIGNED, optionally followed by INTEGER or INT. When we do this, it produces a signed or unsigned BIGINT value.

Read more

SQLite ABS() Explained

by

In SQLite, ABS() is a built-in scalar function that returns the absolute value of its argument.

The absolute value is the non-negative equivalent of the argument. It can be thought of as the distance from zero that the number resides on the number line, without considering direction.

Read more

Fix Msg 3728 in SQL Server “… is not a constraint”

by

If you’re getting an error that reads something like “Msg 3728, Level 16, State 1, Line 1
‘DF__Dogs__DogId__6FE99F9F’ is not a constraint“, it’s probably because you’re trying to drop a constraint that isn’t in the database.

To fix this issue, check to make sure the constraint exists before dropping it. Alternatively, use the IF EXISTS clause to drop the constraint only if it exists.

Read more

MySQL VERSION() Explained

by

In MySQL, VERSION() is a built-in function that returns the MySQL server version.

The result is a string that uses the utf8mb3 character set. A suffix may also be appended to the version number indicating server build or configuration information.

Read more

How to Create a Repeating Sequence in SQL Server

by

When we create a sequence object in SQL Server, we have the option of making it a repeating sequence or a nonrepeating sequence. By repeating I mean, we can have the sequence continually start again once the min/max value has been reached. In other words, we can have the sequence reiterate over and over again.

We can do this with the CYCLE argument.

Read more

Fix “WRONGTYPE Operation against a key holding the wrong kind of value” when Setting a Hash in Redis

by

If you get an error that reads “WRONGTYPE Operation against a key holding the wrong kind of value” when setting a hash with a command like HSET or HSETNX, it’s probably because you’re trying to set a non-hash key that already exists. In other words, the key already exists, but it doesn’t contain a hash.

To fix this issue, be sure to use these commands on keys that either don’t already exist, or contain a hash.

Read more