Category "mysql"

Getting error in Export progress while selecting schema for export

I'm trying to export schema but it's giving me an error in Export progress section Error Fetching Table List From CityState (DbMySQLQuery.resultFieldStringValue

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