Member Avatar for Sinnocence

( old )
sql = """CREATE TABLE (DATABASE1) (
TEXT_BODY CHAR(20) NOT NULL)"""


I would like the above to work like the below.

sql = """CREATE TABLE ('%s') ( 
	 TEXT_BODY CHAR(20) NOT NULL)""" % header

( this produces an error )


Does anyone know how I can make the name of my database user generated by using %s.

  • 2 Contributors
  • 1 Reply
  • 61 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by StephNicolaou
Member Avatar for StephNicolaou

Have you tried:

CREATE TABLE % (tableName)

?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.