Forum Replies Created
- Posts
please try in this link> https://icedrive.net/0/4bgoZKfAMX
This error ( ERROR:1055) occurs when our SELECT list includes a “nonaggregated column” that is neither named among GROUP BY columns nor functionally dependent on them. Please, run the following query: “”set @@global.sql_mode := replace(@@global.sql_mode, ‘ONLY_FULL_GROUP_BY’, ”);”” Then, restart the Workbench. The issue should be resolved.
>>>SELECT
b.*
FROM
(SELECT
e.emp_no AS employee_ID,
MIN(de.dept_no) AS department_code,
(SELECT
emp_no
FROM
dept_manager
WHERE
emp_no = 110039) AS manager_ID<<>>SELECT
d.*
FROM
(SELECT
e.emp_no AS employee_ID,
MIN(de.dept_no) AS department_code,
(SELECT
emp_no
FROM
dept_manager
WHERE
emp_no = 110022) AS manager_ID
FROM
employees e
JOIN dept_emp de ON e.emp_no = de.emp_no
WHERE
e.emp_no = 110039
GROUP BY e.emp_no) AS d) as u;<<<>>you had received ERROR:1048. which means you’re trying to insert a NULL value into the manager_no column, but this column has a NOT NULL constraint (which prevents NULL values)<< āĻāĻā§ āĻā§āĻˇā§āĻ¤ā§āĻ°ā§ āĻāĻĒāĻ¨āĻŋ where āĻāĻ° āĻĒāĻ° manager_id determine āĻāĻ°āĻ¤ā§ āĻā§āĻ˛ āĻāĻ°ā§āĻā§āĻ¨āĨ¤ e.emp_no = 110022) AS manager_ID āĻ¨āĻž āĻšā§ā§ āĻšāĻŦā§ emp_no = 110022) AS manager_IDāĨ¤ āĻāĻāĻ¨ try āĻāĻ°ā§ āĻĻā§āĻā§āĻ¨āĨ¤ hopefully āĻāĻĒāĻ¨āĻŋ āĻ¸āĻŽāĻžāĻ§āĻžāĻ¨ āĻĒā§ā§ā§āĻā§āĻ¨āĨ¤"" āĻāĻĒāĻ¨āĻžāĻ° previous SS āĻ¯āĻž ā§§ā§Š āĻāĻāĻ¸ā§āĻ post āĻāĻ°ā§āĻāĻŋāĻ˛ā§āĻ¨ āĻ¤āĻž upload āĻšā§āĻ¨āĻŋāĨ¤ kindly check āĻāĻ°ā§ āĻĻā§āĻāĻŦā§āĻ¨āĨ¤set @@global.sql_mode := replace(@@global.sql_mode, ‘ONLY_FULL_GROUP_BY’, ”);
āĻāĻ syntax āĻāĻž execute āĻāĻ°ā§, āĻ¤āĻžāĻ°āĻĒāĻ° āĻāĻĒāĻ¨āĻžāĻ° code āĻāĻŋ type āĻāĻ°ā§ āĻĻā§āĻā§āĻ¨ āĻāĻžāĻ āĻšā§ āĻāĻŋāĻ¨āĻžāĨ¤ āĻāĻāĻāĻž āĻā§āĻĄ āĻŦāĻŋāĻāĻŋāĻ¨ā§āĻ¨ āĻāĻžāĻ°āĻ¨ā§ error āĻĻā§āĻāĻžāĻ¤ā§ āĻĒāĻžāĻ°ā§āĨ¤ kindly, error code āĻ¸āĻš problem share āĻāĻ°āĻŦā§āĻ¨āĨ¤ āĻāĻ° screenshot provide āĻāĻ°āĻ˛ā§ problem āĻā§āĻĨāĻžā§ āĻšāĻā§āĻā§ āĻ¤āĻž āĻŦā§āĻāĻ¤ā§ āĻ¸āĻšāĻ āĻšāĻŦā§āĨ¤ screenshot āĻāĻŋāĻāĻžāĻŦā§ share āĻāĻ°āĻ¤ā§ āĻšāĻŦā§ āĻ¤āĻž āĻāĻžāĻ¨āĻ¤ā§ helpline āĻ āĻ¯ā§āĻāĻžāĻ¯ā§āĻ āĻāĻ°ā§āĻ¨āĨ¤
COMMIT āĻāĻžāĻ˛āĻžāĻ¨ā§āĻ° āĻĒāĻ° ROLLBACK āĻāĻ°āĻ˛ā§ MySQL āĻ āĻĒā§āĻ°ā§āĻŦā§āĻ° āĻ°ā§āĻĒā§ āĻ¯āĻžā§āĻ¨āĻžāĨ¤ āĻŦāĻŋāĻˇā§āĻāĻŋ Lecture āĻ āĻŦāĻ˛āĻž āĻāĻā§, MySQL āĻ COMMIT āĻāĻ°āĻžāĻ° āĻĒā§āĻ°ā§āĻŦ āĻĒāĻ°ā§āĻ¯āĻ¨ā§āĻ¤ ROLLBACK āĻ¸āĻāĻ˛ command execution āĻāĻ° UNDO āĻšāĻŋāĻ¸ā§āĻŦā§ āĻāĻžāĻ āĻāĻ°ā§āĨ¤ āĻāĻŋāĻ¨ā§āĻ¤ā§ COMMIT command execute āĻšā§ā§ āĻā§āĻ˛ā§ āĻ¤āĻāĻ¨ ROLLBACK āĻāĻ°ā§ āĻĒā§āĻ°ā§āĻŦā§āĻ° Statement āĻ āĻāĻ¸āĻž āĻ¯āĻžā§āĻ¨āĻžāĨ¤ āĻāĻ° āĻāĻāĻāĻŋ āĻļā§āĻ§ā§ WORKBANCH āĻāĻ° āĻāĻ¨ā§āĻ¯ āĻ¨ā§, āĻ¸āĻāĻ˛ SQL āĻā§āĻˇā§āĻ¤ā§āĻ°ā§ sameāĨ¤
–āĻāĻĒāĻ¨āĻŋ SCREENSHOT āĻāĻŋāĻāĻžāĻŦā§ attatch āĻāĻ°āĻŦā§āĻ¨ āĻ¤āĻžāĻ° āĻŦā§āĻ¯āĻžāĻĒāĻžāĻ°ā§ āĻĢā§āĻ°āĻžāĻŽ āĻ āĻĨāĻŦāĻž HELPLINE āĻ ASK āĻāĻ°ā§āĻ¨āĨ¤–
āĻāĻĒāĻ¨āĻžāĻ° workbench e execute āĻāĻ°āĻž āĻā§āĻĄā§āĻ° screenshot with errors āĻ¸āĻš āĻĢā§āĻ°āĻžāĻŽ āĻ āĻļā§ā§āĻžāĻ° āĻāĻ°ā§āĻ¨āĨ¤
āĻāĻĒāĻ¨āĻŋ āĻ¯ā§ insert command input āĻĻāĻŋā§ā§āĻā§āĻ¨ āĻ¸ā§āĻāĻŋ āĻāĻŋ semicolon āĻĻāĻŋā§ā§ close āĻāĻ°ā§āĻāĻŋāĻ˛ā§āĻ¨? āĻāĻĒāĻ¨āĻŋ āĻ¯ā§ code share āĻāĻ°ā§āĻā§āĻ¨ āĻ¸ā§āĻāĻžāĻ¨ā§ ‘;’ āĻĻā§āĻāĻāĻŋāĻ¨āĻžāĨ¤
Did you create the relationship between primary key and foreign key properly? Foreign key āĻ āĻā§āĻ¨ data āĻāĻ° āĻŦāĻŋāĻˇā§ā§ āĻāĻžāĻ¨āĻ¤ā§ āĻāĻžāĻā§āĻā§āĻ¨ āĻ¤āĻž āĻāĻāĻāĻž screenshot āĻāĻ° āĻŽāĻžāĻ§ā§āĻ¯āĻŽā§ āĻĻā§āĻāĻžāĻ˛ā§ āĻŦā§āĻāĻ¤ā§ āĻ¸āĻšāĻ āĻšāĻ¤ā§āĨ¤
Throughout the course we focused on mySQL which is RDBMS… you are asking solution for postgresql which is ORDBMS. there are some differences between two database management system…
Foreign key relationships involve a parent table that holds the central data values and a child table with identical values pointing back to its parent. The FOREIGN KEY clause is specified in the child table. It will reject any INSERT or UPDATE operation that attempts to create a foreign key value in a child table if there is no matching candidate key value in the parent table. The Problem is with the FOREIGN KEY Constraint. By Default (SET FOREIGN_KEY_CHECKS = 1). We can set the foreign key check as disabled before running the Query by executing the lines before running your query, then you can run your query successfully.
>>> SET FOREIGN_KEY_CHECKS=0; <<<Is this your first time try? There is an error in your default port which is 3306. that’s why the server connection didn’t establish properly. Anyway, nothing to worry about. what you have to do is to change port 3306 to 3307. Often, this error occurs when XAMPP or MAMP is used for configuring to start MySQL on system startup, and by default MySQL uses port 3306.
âĒ Firstly you have to open the XAMPP Control Panel or you may download it from https://www.apachefriends.org/download.html
âĒJust click the MySql config button -> click the “my.ini” file
âĒIt will open in Notepad, after that you have to find and change the port no from 3306 to 3307 in two places (one is just after the “password” line and another is after the [mysqld] line.
âĒ Save it.
hopefully, this will help you out with this problem.