The code below is not compiling by HeidiSQL in a MYSQL base BEGIN if NOT EXISTS (SELECT * FROM pedido_itens WHERE ID_PEDIDO = OLD.ID_pedido) DELETE from pedido WHERE pedido.ID = pedido_itens.old.ID_PEDIDO; END if; END I'm trying to create a trigger…
Suppose I have a table products with product description apple yummy green fruit banana nutritional yellow fruit Notice that the description column may contain texts of arbitrary length (LONGTEXT). Now I want to get the table words with all of…
I would like to display businesses from within our database as an alphabetical list, sorted by first letter. Currently, Not all letters are represented. As a visual example, the user page would look like this: Display business by name -…
I'm a beginner in SQL and I tried looking for an answer without any luck. I would like to generate invoice numbers automatically with the following distinctions: I have 2 different structures invoicing I would like to avoid any numbering…
I want to get records from Leads table by applying where condition(e.g when LSH.status=5) should apply on only on top first record(i made LSH.leads_status_id DESC) from table leads_status_history, how to filter the records ? But currently by using below sql…
I'm noob in MySQL... It is difficult to describe my task, so I will show it with an example. I have two tables: meta_data: id key value 1 property_1 1,2,54,2 1 property_2 23424 1 property_3 cat 1 property_4 4324 1…
We got to print '*' 20 times followed by 19 times and so on till we only got to print 1! delimiter $$ create procedure test() begin set @ans = 20; while(@ans>0) do select repeat('*',@ans); set @ans = @ans -…
I am using MariaDB 10.6. I have a user "test" with a password, the password is MySQL encrypted, which is like '*E494B31EA7DDA68A012783C852F1AB397877B17A' The only thing is I don't have the plain password, or honestly, I don't want to store them.…
` @user.post("/add-user") async def write_user_date(user: User): conn.execute(users.insert().values( name=user.name, email=user.email, password=user.password, )) return conn.execute(users.select()).fetchall() ` That is my code, but every time when I post a data it's show ERROR: Exception in ASGI application Traceback (most recent call last): File "c:usershpdesktopfastapi…
I get an Error because of the Check Constraint and i dont know why. create table TStudenten ( StudId int unsigned auto_increment primary key, StudVorname varchar(25) not null, StudNachname varchar(25) not null, StudStrasse varchar(40), StudPLZ char(4), StudOrt varchar(20), StudGebDatum date,…