The raiserror method raiserror(‘Oh no a fatal error’, 20, -1) with log This will terminate the connection, thereby stopping the rest of the script from running. Note that both severity level 20 or higher and the WITH LOG option are necessary for it to work this way. This even works with GO statements, eg. print … Read more
You can do the following (I guessed on table fields,etc) SELECT s.studentname , s.studentid , s.studentdesc , h.hallname FROM students s INNER JOIN hallprefs hp on s.studentid = hp.studentid INNER JOIN halls h on hp.hallid = h.hallid Based on your request for multiple halls you could do it this way. You just join on your … Read more
New versions of MySQL WorkBench have an option to change specific timeouts. For me it was under Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds): 600 Changed the value to 6000. Also unchecked limit rows as putting a limit in every time I want to search the whole data … Read more
You print the queryset’s query attribute. >>> queryset = MyModel.objects.all() >>> print(queryset.query) SELECT “myapp_mymodel”.”id”, … FROM “myapp_mymodel”
HOW TO FORCE UNLOCK for locked tables in MySQL: Breaking locks like this may cause atomicity in the database to not be enforced on the sql statements that caused the lock. This is hackish, and the proper solution is to fix your application that caused the locks. However, when dollars are on the line, a … Read more
SQL is a query language to operate on sets. It is more or less standardized, and used by almost all relational database management systems: SQL Server, Oracle, MySQL, PostgreSQL, DB2, Informix, etc. PL/SQL is a proprietary procedural language used by Oracle PL/pgSQL is a procedural language used by PostgreSQL TSQL is a proprietary procedural language … Read more
It’s a difference between RDBMS’s varchar (or similar) — those are usually specified with a maximum length, and might be more efficient in terms of performance or storage — and text (or similar) types — those are usually limited only by hardcoded implementation limits (not a DB schema). PostgreSQL 9, specifically, states that “There is … Read more
I’ve always solved this using lower: SELECT * FROM trees WHERE LOWER( trees.title ) LIKE ‘%elm%’
You need to tell MySQL which database to use: USE database_name; before you create a table. In case the database does not exist, you need to create it as: CREATE DATABASE database_name; followed by: USE database_name;
Use the convert function. SELECT CONVERT(varchar(10), field_name) FROM table_name