I have this table with the next records: CREATE TABLE `t_vias` ( `id` int(11) NOT NULL, `cpro` varchar(2) NOT NULL, `cmum` varchar(3) NOT NULL, `cpos` varchar(5) NOT NULL, `mun` varchar(75) NOT NULL, `via` varchar(100) NOT NULL); INSERT INTO t_vias VALUES…
I wrote a SQL query to fetch all movies and, if present, include the name 'Brad Pitt' for movies where he's a cast member. The query is as follows: select m.title, p_cast.person_name From movie m left join ( movie_cast m_cast…
it gives same error permission denied i thing i try all possible ways to solve it . i am using ubuntu . please if anyone knoe what is the proble help me .. . i change my user in mysql-server…
select Name,Marks, case when Marks='65' then Roll_num='113' when Marks='68' then Roll_num='114' when Marks='71' then Roll_num='115' else Roll_num end from student; I Want replace Marks column with new values. in this code i am not getting marks column replace values.
I have a table filled with pre-calculated prices for rental objects. This is a simple version of it: CREATE TABLE `pricecache` ( `oid` int(11) NOT NULL DEFAULT '0', `start` date NOT NULL, `end` date NOT NULL, `duration` tinyint(3) UNSIGNED NOT…
The code below displays a message after typing a value into the field Poprawnie zapisano: - but without this value Also does not write anything to the database. Did I make a mistake somewhere? HTML file <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> </head>…
i want to join table, and i have 2 table like Table : Suhu ID_ROOM | SUHU_MIN | SUHU_MAX ---------------------------------- 1 10 15 1 12 20 1 15 25 1 20 22 Table : RH ID_ROOM | RH_MIN | RH_MAX…
I use MySQL on my main Mac (M1 iMac, latest Sonoma, MySQL v8.3.0-arm64), and in its preference pane, I have the "Start MySQL when your computer starts up" option enabled. It NEVER starts automatically anymore, though it did so for…
I have a table 'sometable' with a JSON field named 'jsonval', which contains a JSON object with the property 'programs' that contains an array of objects with the property 'id' I want to search for records that contain jsonval.programs.id =…
I've been investigating an issue with one of our application queries running very slowly and it seems to be related to a particular view we're using. Here is the full query with the selected columns omitted (there are 408 columns…