sarah posted

Django - mysqlclient 1.3.13 or newer is required; you have 1.3.10.


sudo apt-get install python3-mysqldb libmysqlclient-dev python-dev

it shows following messages :


Selecting previously unselected package zlib1g-dev:amd64.
(Reading database ... 279447 files and directories currently installed.)
Preparing to unpack .../zlib1g-dev_1%3a1.2.11.dfsg-0ubuntu2_amd64.deb ...
Unpacking zlib1g-dev:amd64 (1:1.2.11.dfsg-0ubuntu2) ...
Selecting previously unselected package libmysqlclient-dev.
Preparing to unpack .../libmysqlclient-dev_5.7.27-0ubuntu0.18.04.1_amd64.deb ...
Unpacking libmysqlclient-dev (5.7.27-0ubuntu0.18.04.1) ...
Selecting previously unselected package python3-mysqldb.
Preparing to unpack .../python3-mysqldb_1.3.10-1build1_amd64.deb ...
Unpacking python3-mysqldb (1.3.10-1build1) ...
Setting up python3-mysqldb (1.3.10-1build1) ...
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...
Setting up zlib1g-dev:amd64 (1:1.2.11.dfsg-0ubuntu2) ...
Setting up libmysqlclient-dev (5.7.27-0ubuntu0.18.04.1) ...

but still


python3 manage.py runserver

shows following error


django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 1.3.10.

Edit Question

python
answered Apr 25 '23 00:00

In MySQL, a derived table is a table that is created from a subquery in a larger SQL statement. When creating a derived table, it's mandatory to provide an alias for the table, which is used to reference it in the rest of the SQL statement.

The error "Every derived table must have its own alias" occurs when a derived table in a SQL statement doesn't have an alias specified.

To fix this error, you need to add an alias for the derived table. Consider the following example:


SELECT *
FROM (
  SELECT column1, column2
  FROM table1
  WHERE column3 = 'value'
) AS dt

In this example, the subquery creates a derived table that is given the alias "dt". The outer query then selects all columns from this derived table using the specified alias.

By providing an alias for the derived table, you can avoid the "Every derived table must have its own alias" error and ensure that your SQL statement executes correctly.

Edit Answer

sarah posted

Django - mysqlclient 1.3.13 or newer is required; you have 1.3.10.

python answered Apr 25 '23 00:00

Latest Questions

Insert link

Insert image

python
answered Apr 25 '23 00:00