• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Question about shell script

 
preethi kumar
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


i wanted to insert a row of data into the database using the above shell script. but was unable to do so. please let me know how can i correct the above shell script?
 
chris webster
Bartender
Posts: 2407
32
Linux Oracle Postgres Database Python Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moved to JDBC forum where you might find some database advice on MySQL.
 
Jan Cumps
Bartender
Posts: 2588
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
There is quotes mismatch in the string 'insert into Persons values(1,'nisha','shetty','ibm','bangalore');'



Don't you have to use duoble quotes around the sql statement, as shown here?
 
preethi kumar
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Jan :-)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic