Category "mysql"

Trying to get only cells with certain initials but giving me syntax error? SQL

So my assignment question is to "Get a list of all books withdrawn by people with the initials 'B.W.'. Show a column for the first name, last name, initials, an

Simple spring data jpa transaction to small table on mysql database is hanging indefinitely

I have a spring data jpa query that reads a row from a mysql table with a pessimistic lock. In my environment, this table only contains one row so it should be

What is the difference between Query builder, find and findone in typeorm?

I have used a query in typeorm using query builder as: getManager().CreateQueryBuilder(class_name_from_entity_file, 'xyz').select('column_name').where('active_s

Does querying int column with string datatype have any performance impact in mysql queries?

Assuming I have a table as: create table any_table (any_column_1 int, any_column_2 varchar(255)); create index any_table_any_column_1_IDX USING BTREE ON any_tab

Does querying int column with string datatype have any performance impact in mysql queries?

Assuming I have a table as: create table any_table (any_column_1 int, any_column_2 varchar(255)); create index any_table_any_column_1_IDX USING BTREE ON any_tab

Does querying int column with string datatype have any performance impact in mysql queries?

Assuming I have a table as: create table any_table (any_column_1 int, any_column_2 varchar(255)); create index any_table_any_column_1_IDX USING BTREE ON any_tab

Does querying int column with string datatype have any performance impact in mysql queries?

Assuming I have a table as: create table any_table (any_column_1 int, any_column_2 varchar(255)); create index any_table_any_column_1_IDX USING BTREE ON any_tab

Does querying int column with string datatype have any performance impact in mysql queries?

Assuming I have a table as: create table any_table (any_column_1 int, any_column_2 varchar(255)); create index any_table_any_column_1_IDX USING BTREE ON any_tab

Does querying int column with string datatype have any performance impact in mysql queries?

Assuming I have a table as: create table any_table (any_column_1 int, any_column_2 varchar(255)); create index any_table_any_column_1_IDX USING BTREE ON any_tab

Does querying int column with string datatype have any performance impact in mysql queries?

Assuming I have a table as: create table any_table (any_column_1 int, any_column_2 varchar(255)); create index any_table_any_column_1_IDX USING BTREE ON any_tab

Does querying int column with string datatype have any performance impact in mysql queries?

Assuming I have a table as: create table any_table (any_column_1 int, any_column_2 varchar(255)); create index any_table_any_column_1_IDX USING BTREE ON any_tab

Does querying int column with string datatype have any performance impact in mysql queries?

Assuming I have a table as: create table any_table (any_column_1 int, any_column_2 varchar(255)); create index any_table_any_column_1_IDX USING BTREE ON any_tab

Does querying int column with string datatype have any performance impact in mysql queries?

Assuming I have a table as: create table any_table (any_column_1 int, any_column_2 varchar(255)); create index any_table_any_column_1_IDX USING BTREE ON any_tab

Does querying int column with string datatype have any performance impact in mysql queries?

Assuming I have a table as: create table any_table (any_column_1 int, any_column_2 varchar(255)); create index any_table_any_column_1_IDX USING BTREE ON any_tab

Operand should contain 1 column in express mysql query

Am curretly facing the following error when i try to query using express code: 'ER_OPERAND_COLUMNS', errno: 1241, sqlMessage: 'Operand should contain 1 co

mysql: [ERROR] Found option without preceding group in config file c:\users\alec at line 1

I have an interview question that requires their pre-created SQL file to be run, everytime I try and run this in MySQL it produces this error and have no idea h

Attempting to INSERT values into a MySQL DB from C# code within a form, but getting "Column cannot be NULL

All - thanks in advance for your time. So, background info - I am trying to create a form for contact registration using C# to pass the information into my MyS

If not exist with Date SQL

i want to add the time, if there is free time as example im doing that with two textboxes where im entering the date Database 20.04.2020 - 20.05.2020 so there s

Do i have to put a foreign key relation to any column in a table with relation with another table? larvavel 8, Sql

I have multiple tables, and some do have columns which are related but I am not certain if I have to put the foreign key relations to all columns which are rela

LEFT JOIN to return only first row

I am making a join with two tables, tab_usuarios (users) and tab_enderecos (address). tab_usuarios structure: id_usuario nome usuario 1 Administrador admin 2 N