by Yogesh | Oct 11, 2017 | Python Tutorial
Source Code import sqlite3 db = sqlite3.connect('ganesha.db') cursor = db.cursor() id1=2 name1 = 'AAA' # cursor.execute('update info3 set name = ? where id = ?',(name1,id1)) cursor.execute('delete from info3 where id = ?',(id1,)) db.commit()...
by Yogesh | Oct 11, 2017 | Python Tutorial
Source Code import sqlite3 db = sqlite3.connect('ganesha.db') cursor = db.cursor() id1 = 2 cursor.execute('select *from info3 where id=?',(id1,)) multiplerecord = cursor.fetchall() # print(singlerecord[1]) for row in multiplerecord: # print(row)...
by Yogesh | Oct 8, 2017 | Python Tutorial
How to insert data in Table using Python 1.? Placeholder 2.Using python tuple and keyname placeholder import sqlite3 db = sqlite3.connect('ganesha.db') id1 = 1 name1= 'yogesh' id2 = 2 name = 'vikas' cursor = db.cursor() # ? Placeholder # cursor.execute('insert into...
by Yogesh | Sep 10, 2017 | PIG tutorial
PIG Introduction Big is an Apache open source project pig works on MapReduce and hdfs and the script that we will read write to perform data analysis is called pig Latin. PIG is capable to read data from local file system and hdfs and able to write output data on hdfs...
by Yogesh | Sep 5, 2017 | Hive tutorial
Hive functions Command : SHOW FUNCTIONS (to see all in-built functions) To show Complete details of in-built function. Descibe function concat Calling Functions: Select concat(fname,lname) as fullname from emp Functions Types 1. Standard Functions : round(),...
