What I am trying to do is to get the same column result twice with a single query. SELECT appellation FROM persona WHERE character_id IN (853,12,853) ORDER BY FIELD(character_id,853,12,853) This returns the result: character_id | appellation --------------------------- 853 | John…
I have a table with integer ID as primary key--auto increment. Because of frequent delete/insert, the ID values are like 1 1000 2340 5420 .... I want it always to be 1 2 3 4 .... So is there a…
I have two tables that have the same columns; AgencyA & AgencyB. Columns; Subject, Event_Combined and License_Fee. How can I combine the columns for each table? IE Subject column will have all the data from AgencyA and AgencyB. Ive tried…
I've built a simple website with authorization and registration system. So I have user accounts and I wonder where to store profile pictures for every user. I tried to store them in MYSQL in BLOB, but I don't think it…
I have a .csv file that is about 5mb (~45,000 rows). What I need to do is run through each row of the file and check if the ID in each line is already in a table in my database.…
I have table user: user_id status 1010 1 1010 3 1010 3 1011 5 1011 2 1011 3 1012 3 1012 3 i want to filter user_id with the condition that the number "3" in the status column cannot appear…
My code is: CREATE TABLE `table_a` ( `id` INT NOT NULL AUTO_INCREMENT, `value` varchar(255), PRIMARY KEY (`id`) ) ENGINE=InnoDB; CREATE TABLE `table_b` LIKE `table_a`; INSERT INTO table_a VALUES (1, 'A'), (2, 'B'), (3, 'B'); INSERT INTO table_b VALUES (1, 'B');…
I don't want to replace ALL dashes in a string, but rather replace only those dashes that are part of a GUID/UUID. Before the replace: Mary-Anne Smith is a physics professor at the University of Illinois. Her dissertation was focused…
Good evenings, sirs. I wonder how can i delete records in Sequelize after certain time passes? For example, I want to delete unauthorized records after 10 days.I am new to Sequelize so if you can give me an idea, i…
I'm really new to databases in general but could use some advice. I have a database that has about 6000 records (and growing but not crazy amounts). I'd like to build an API so that I can retrieve a property's…