Database

SQL conditional SELECT

Sounds like they want the ability to return only allowed fields, which means the number of fields returned also has to be dynamic. This will work with 2 variables. Anything more than that will be getting confusing. Dynamic SQL will help with multiples. This examples is assuming atleast 1 column is true.

Regex pattern inside SQL Replace function?

You can use PATINDEX to find the first index of the pattern (string’s) occurrence. Then use STUFF to stuff another string into the pattern(string) matched. Loop through each row. Replace each illegal characters with what you want. In your case replace non numeric with blank. The inner loop is if you have more than one … Read more

Best way to test if a row exists in a MySQL table

You could also try EXISTS: and per the documentation, you can SELECT anything. Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with SELECT 5 or SELECT column1 or anything at all. MySQL ignores the SELECT list in such a subquery, so it makes no difference.

grant select on view

The error message should be written like this: ORA-01720: “grant option” does not exist for COLLDESK.GESTIONES. Here’s how it works: You have 3 schemas: Schema1 – Holder of a table named “table1” Schema2 – Holder of a view “view1” selecting from schema1.table1 Schema3 – User, selecting from schema2.view1 – has no select granted on schema1.table1. … Read more

mysqld: Can’t change dir to data. Server doesn’t start

Since you used the Windows installer, everything is set up for you to run MySQL 5.7 as a Windows service, which is a great option in most cases. Instead of running mysqld.exe from the command line, Win + R Run services.msc Right-click on MySQL57 Start the service.

+ More