Python Forum
error 1102 (42000) incorrect database name 's'
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
error 1102 (42000) incorrect database name 's'
#1
I create a table using pyMysql in python from a terminal using Ubuntu I receive an error

Error:
error 1102 (42000) incorrect database name 's'
Here the screenshot has been shared for both create table and the table that I want to create in Mysql how to solve and what changes need

https://ibb.co/4FLMpD6

https://ibb.co/VSP5gPY
Reply
#2
Is S.NO.ID a valid column name? What happens if you change it or wrap it in quotes?
Reply
#3
Yes S.NO.ID is a serial number ID number and if change it quota then ('S.NO.ID'.......)); it run without error but the table hasn't create
Reply
#4
Error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"S.NO-ID' char(7), primary key, PatientName varachar(1000),Gender varchar(1000),' at line 1
Reply
#5
i have solve the problem by using int char and varchar for given table thanks you
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Code is returning the incorrect values. syntax error 007sonic 6 1,241 Jun-19-2023, 03:35 AM
Last Post: 007sonic
  Error 1064 (42000) when executing UPDATE SQL gratiszzzz 7 1,487 May-22-2023, 02:38 PM
Last Post: buran
  mySQL Database error not resolving. cybertooth 2 3,232 Aug-30-2021, 05:45 PM
Last Post: ibreeden
  Error creating database with python and form? shams 3 2,384 Aug-02-2021, 02:00 PM
Last Post: deanhystad
  openpyxl incorrect delete rows VladislavM 6 4,133 Jul-19-2021, 08:54 AM
Last Post: VladislavM
  Incorrect Type Error milkycow 4 2,915 Jun-25-2021, 06:04 AM
Last Post: milkycow
  Why is 0.1 * 0.2 arithmetically incorrect? Pedroski55 2 2,235 Nov-25-2020, 12:01 AM
Last Post: snippsat
  user input producing incorrect boolean al_Czervik 4 3,085 Mar-05-2020, 09:50 PM
Last Post: al_Czervik
  Incorrect time format KoSik 5 3,058 Aug-15-2019, 05:10 PM
Last Post: KoSik
  Error in Database connectivity with python3.7 srm 8 4,528 May-13-2019, 07:28 AM
Last Post: srm

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020