I want to create a table. I'm having long and hard time about naming columns. If there are 3 columns having same characteristics. ex) tag_1, tag_2, tag_3 -> CREATE TABLE BOARD ( BOARD_ID bigint not null primary key, TAG_1 varchar(10)…
i have two tables tb1 tb1_id - store_ids - date 1 - 1,2,3,4 - 2023-01-01 2 - 3,4 - 2023-06-01 tb2 tb2_id - name - date 1 - gold - 2023-01-01 2 - mond - 2023-01-01 3 - burgar -…
I have a dogs table that looks like this: create table dogs (name char(10), breed, char(20), age int); insert into dogs (name, breed, age) values ('A', 'Breed 1', 1); insert into dogs (name, breed, age) values ('B', 'Breed 2', 2);…
I have a table that looks like this id name col1 1 foo A 2 foo C 3 bar A 4 bar D I want to select all names where col1 has no entry D The result should be "foo"…
i developed an application using Angular, Spring Boot and MySQL database. I want do publish it into docker hub but im still confused if i should create different images for each (Angular, API SpringBoot and MySQL) or i should just…
Is there any way that I can see what is stored in those indexes? I understand the query mentioned below lists down all the schema indexes and their details: SELECT DISTINCT TABLE_NAME, INDEX_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = 'your_schema'; (taken…
Table has field containing the list of IDs separated by "-". Example: 559-3319-3537-4345-29923 I need to check rows that use at least 4 of the specified identifiers using regex Example: before inserting to the db, I need to check the…
I am trying to get data from the mysql database using php and wordpress which I want to convert to json to get all the data from my mysql query. I have made the call using AJAX to the php…
How can we optimize the delete query. delete FROM student_score WHERE lesson_id IS NOT null AND id NOT IN(SELECT MaxID FROM temp) ORDER BY id LIMIT 1000 This select statement return "SELECT MaxID FROM temp" 35k lines and temp is…
I started a new Laravel 9.x + JsonApi project on docker-compose with 2 containters, 'web' and 'mysql'. Artisan migrations, seeding and db:show works fine. But when I'm trying to load a page from browser or Postman, it returns DB error…