Hot answers tagged

1

When it comes to Windows, something is always different. TWO_TASK works on Linux/UNIX, but not on Windows. The Windows version of TWO_TASK is LOCAL. SQL*Plus Environment Variables LOCAL Windows environment variable to specify a connection string. Performs the same function as TWO_TASK on UNIX. ... TWO_TASK UNIX environment variable ...


1

Below is my take on it: Have two separate price columns, once for $ and the other for €. If in some stage in the future you will start taking payments in more currencies, you will likely use one of the prices as the base price and do a currency conversion calculation. Depending on the complexity of the rules you have two choices: a. Add "bundles" and ...


1

The double quote " is actually specifying a field or an identifier. Use single quotes to specify your string filters: SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA='mysql' AND TABLE_NAME='servers' ; Problem #2 could be you are USEing the wrong database. For example, if your table servers is in the schema mysql and you are currently using ...


1

If you lump all the column_## columns into a JSON field, you can have a limit of 4GB. The question of how much gets complicated. InnoDB has 4 ROW_FORMATs: REDUNDANT, COMPACT, DYNAMIC, COMPRESSED. I think you could have 400 columns of VARCHAR(255) or TEXT (or ...) in ROW_FORMAT=DYNAMIC. That format uses a 20-byte pointer in the record to where the actual ...


1

Migrating the Data is a Job in itself Keeping Data in sync is a job is yet another job. Creating a new front end is yet another job. there's lots of ways to tackle the problem. there's a lot that can go wrong with data migrations, so if you've never done one before unless the business is yelling for it I'd move very slowly and carefully. 1st I'd ...



Only top voted, non community-wiki answers of a minimum length are eligible