▁plan ▁is ▁compiled ▁and ▁stored ▁for ▁each ▁different ▁length . ▁In ▁general , ▁the ▁maximum ▁number ▁of ▁" dup licate " ▁plans ▁is ▁the ▁product ▁of ▁the ▁lengths ▁of ▁the ▁variable ▁length ▁columns ▁as ▁specified ▁in ▁the ▁database . ▁For ▁this ▁reason , ▁it ▁is ▁important ▁to ▁use ▁the ▁standard ▁Add ▁method ▁for ▁variable ▁length ▁columns : ▁ ▁, ▁where ▁Param Length ▁is ▁the ▁length ▁as ▁specified ▁in ▁the ▁database . ▁ ▁Since ▁the ▁standard ▁Add ▁method ▁needs ▁to ▁be ▁used ▁for ▁variable ▁length ▁data ▁types , ▁it ▁is ▁a ▁good ▁habit ▁to ▁use ▁it ▁for ▁all ▁parameter ▁types . ▁ ▁Python ▁DB - API ▁ ▁This ▁example ▁uses ▁Python ▁and ▁DB - API : ▁ ▁import ▁mysql . conne ctor ▁ ▁conn ▁= ▁None ▁cursor ▁= ▁None ▁ ▁try : ▁▁▁▁ ▁conn ▁= ▁mysql . conne ctor . connect ( database =" mysql ", ▁user =" root ") ▁▁▁▁ ▁cursor ▁= ▁conn . cursor ( prep ared = True ) ▁▁▁▁ ▁cursor . execute (" CREATE ▁TABLE ▁IF ▁NOT ▁EXISTS ▁products ▁( name ▁VARCHAR ( 4 0 ), ▁price ▁INT )") ▁▁▁▁ ▁params ▁= ▁[ (" bi ke ", ▁ 1 0 9 0 0 ), ▁▁▁▁▁▁▁▁▁▁▁▁▁▁ ▁(" sh o es ", ▁ 7 4 0 0 ), ▁▁▁▁▁▁▁▁▁▁▁▁▁▁ ▁(" phone ", ▁ 2 9 5 0 0 )] ▁▁▁▁ ▁cursor . exec ut em any (" INSERT ▁INTO ▁products ▁VALUES ▁( % s , ▁% s )", ▁params ) ▁▁▁▁ ▁params ▁= ▁(" sh o es ", ) ▁▁▁▁ ▁cursor .