<div>
Because you have spaces in your variable values. &nbsp;It should be this:<br />
<br />
var1=&quot;CSI6221 Project 1 &nbsp; &nbsp;2015 Semester 1&quot;<br />
var2=&quot;WED&quot;<br />
var3=&quot;12:30 - 13:30&quot;<br />
var4=&quot;ML 03.102 Tutorial Room&quot;
</div>


Because you have spaces in your variable values.  It should be this:

var1="CSI6221 Project 1    2015 Semester 1"
var2="WED"
var3="12:30 - 13:30"
var4="ML 03.102 Tutorial Room"

<div>
Stuck with the silly mistake since couple of days..<br />
thanks very much...
</div>


Stuck with the silly mistake since couple of days..
thanks very much...

<div>
<div class="content wysiwyg-content">
i have three variables holding information<br />
var1=CSI6221 Project 1 &nbsp; &nbsp;2015 Semester 1<br />
var2=WED<br />
var3=12:30 - 13:30<br />
var4=ML 03.102 Tutorial Room<br />
sqlite3 test.db &quot;create table &nbsp;timetable_info (ID INTEGER<br />
&nbsp; &nbsp; &nbsp; &nbsp;PRIMARY KEY,unitinfo TEXT,day TEXT,time TEXT,location TEXT);&quot; ### created a table like this<br />
sqlite3 test.db &nbsp;&quot;insert into timetable_info (unitinfo,day,time,room) values ('$var1', '$var2', '$var3' '$var4');&quot; inserted values this way.<br />
sqlite3 test.db &nbsp;&quot;select * from timetable_info;&quot; &nbsp;### i tried to display data..<br />
i ended up with the message &nbsp;Error:::: near &quot;'ML 03.102 Tutorial Room'&quot;: syntax error<br />
<br />
<br />
can any help what this means?<br />
<br />
<br />
thank you
</div>
</div>


i have three variables holding information
var1=CSI6221 Project 1    2015 Semester 1
var2=WED
var3=12:30 - 13:30
var4=ML 03.102 Tutorial Room
sqlite3 test.db "create table  timetable_info (ID INTEGER
       PRIMARY KEY,unitinfo TEXT,day TEXT,time TEXT,location TEXT);" ### created a table like this
sqlite3 test.db  "insert into timetable_info (unitinfo,day,time,room) values ('$var1', '$var2', '$var3' '$var4');" inserted values this way.
sqlite3 test.db  "select * from timetable_info;"  ### i tried to display data..
i ended up with the message  Error:::: near "'ML 03.102 Tutorial Room'": syntax error


can any help what this means?


thank you

how to insert and display data in sqlite3 using bash?

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.

Shell Scripting

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.