I have the following table: name key uuid na1 k1 NULL na2 k2 NULL na3 k1 NULL If two or more rows have the same key value then I want to update the uuid value to the same uuid for…
I have a table source_flight_destination like this ID Flight source destination 1 Indigo II BB 2 Air Asia AA II 3 Indigo BB JJ 4 spice jet SS BB 5 Indigo JJ SS 6 Air Asia II KK 7 spice…
I am trying to insert data when starting my application but it fails continuously and this exception is thrown, I don't know what I am doing wrong, I have changed the Mysql dialect for version 8 it keeps failing.I have…
I use the C++ connector for MySQL and the X dev API code. On my test server (my machine), doing a single insert in loop is pretty slow (about 1000 per second) on a basic table with a few columns.…
I need to add a new UUID column to an existing SQLAlchemy / MySQL table where. For doing so I added in my database model: class MyTable(db.Model): uid = db.Column(db.BINARY(16), nullable=False, unique=True, default=uuid.uuid4) Doing so generates the following alembic upgrade…
I have a problem with an SQL query. I want to select every user that has unread messages. I have three tables users messages object_visited (has an entry [user_id,message_id], if the user has read the message) So I make a…
I think it's impossible, but I'm asking if there's a good way. There are A table / B table / C table. The table was joined LEFT JOIN based on table A with FK called id of each table. At…
I am using Laragon and I need to change MySQL port from 3306 to some other value. I tried editing the port in my.ini but when I start Laragon again it goes back to 3306. I am using windows 11.…
MySQL fulltext search doesn't match the word 'christoffer82' and its ilk with the root word 'christo' and I have no idea why. This login only appears once in the table (it doesn't appear in more than 50% of the results)…
i am very new to php mysql, i am using the following php from to input data. my var_dump shows all the values i have entered in the form correctly. database connection was also successful. but the data are not…