I have two tables with one referencing the other. CREATE TABLE blogs ( article LONGTEXT, id VARCHAR(255) PRIMARY KEY ); CREATE TABLE blog_eval ( blog_id VARCHAR(255) REFERENCES blogs(id) ON DELETE CASCADE, user_id VARCHAR(255) REFERENCES users(id), is_like BOOLEAN, --true if like…
I'm trying to join 2 tables and count the number of entries for unique variables in one of the columns. In this case I'm trying to join 2 tables - patients and trials (patients has a FK to trials) and…
The database for an application I manage use UUIDs. These UUIDs are stored as char(36) with a utf8 character set. From a strict performance point of view, I know this is not optimal. The general recommendation seem to be to…
I'm attempting to initialize a table called, "character", in a MySQL server database, and I am getting the SQL syntax error provided below: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server…
here I have tried to rewrite the query with cte cuz of good readability but when I try to rewrite the data is mismatched how to solve the problem for this? Query; select count(1) as rage_tap from ue_summary.summary_funnel_1066 s join…
I have a dumped sql file named my_dump.sql. Within that dump file there are various tables. I'm interested in the table named foo_bars which has a bunch of records. I would like to modify this sql file by doing the…
I need to update a MySql database from inside a JS function within a WordPress Woocommerce page. I'm using Ajax to do this. The following code works fine as a stand-alone code but when I put it into the WordPress…
I have two tables, and I want to use a value from primary table (here: person.ref) to extract some data from a json field in a secondary table (here: person_details): create table person ( id int(8), ref varchar(20), primary key…
I am working on a project where I am trying to insert values into a MySQL table. Before starting this project I verified that I had the necessary JAR file setup and tested the SQL connection. I thought I was…
Having a table such as follows: CREATE TABLE Associations ( obj_id int unsigned NOT NULL, attr_id int unsigned NOT NULL, assignment Double NOT NULL PRIMARY KEY (`obj_id`, `attr_id`), ); this should occupy 16 bytes per row. So the overhead per…