I'm a beginner in react native, I'm trying to get user information from mysql database through an axios API get request. Once logged in, I stored email address in AsyncStorage and later want to use that email address from AsyncStorage…
10 million rows. MySQL server V. 5.7 Two indexes called "tagline" and "experience". This statement takes < 1 second: SELECT count(*) FROM pa WHERE MATCH(tagline) AGAINST('"developer"' IN BOOLEAN MODE); This statement also takes < 1 second: SELECT count(*) FROM pa…
I have a table with a primary key using AUTO_INCREMENT. I want this column to start at 1 and increment by 3, but I can't find how to increase the amount the column increments by. ALTER TABLE tbl AUTO_INCREMENT =…
In SQL, how can I select the minimum value of a column a (integer) where the column b (integer) is the maximum value for that column, using only one select ? SELECT MIN(a) OVER (PARTITION BY MAX(b)) as res #seems…
I am using typescript for the first time and I am following a tutorial. The tutorials I have seen normally use a package to generate id for the table. My question is: is there no way to allow sequelize to…
I have 2 tables: First one is bom Article AB CD EF GH CREATE TABLE bom ( Article VARCHAR(250) ); INSERT INTO bom (Article) VALUES ('AB'), ('CD'), ('EF'), ('GH'); Second one is purchases Article OrderDate Price AB '2020-01-10' 12 AB…
Frontend: Reactjs Backend: Nodejs + Express Database: Mysql Workbench Hosting: Linode Now I have an event that is scheduled to run every 2 seconds to update the status column. However, I am worried that the event might affect the performance…
I have a couple of tables that looks like this: CREATE TABLE Entities ( id INT NOT NULL AUTO_INCREMENT, name VARCHAR(45) NOT NULL, client_id INT NOT NULL, display_name VARCHAR(45), PRIMARY KEY (id) ) CREATE TABLE Statuses ( id INT NOT…
SELECT max(t.a),t.b from( SELECT 10 as a,1 as b,1 as c UNION ALL SELECT 20,2,1 UNION ALL SELECT 30,3,2 UNION ALL SELECT 40,4,2 ) as t order by b desc; result = 40,1,1 result needed = 40,4,2 20,2,1 result to…
I need some help here, my request is : List the bookID and number of copy of this in Library (Number of copy in library = number of copy – number of copy student borrow but not return yet) and…