learning the code will probably take you a year max but you should also learn about database concepts and principles (eg. normalization, database integrity, design etc)
the problem though is that it...

did you get an exception that mentioned something about indentation because in python you have to have the executable code under the if statement. you don't need the brackets as well
try this:

if...

i don't see a problem but bear in mind that those are two completely different languages and bear little similarities but it should be a problem seeing that is intro classes.

you can build a anonymous block or procedure to do this as well

i suggest building the sql query or non-query so that when it fails you can print the query and check whats happening, its usually a problem with the way the query is built.

try this:
call GetOffice(@countryId:=1,@countryName:='India');

Unneeded; because you require j_num from the journals tables you are already linking the table with researchers table. That join should suffice to return the information you required. If you wanted...

dude just combine everything snippsat posted he basically wrote you the programme it's right there, just think about it
create a loop from 1 to 100
generate random number and store in a variable...

i think you might want to have a look at cursors, can't think of anything else at the moment though, sorry.

For instances like this i always suggest using anonymous blocks or stored procedures and you are probably most likely going to need an if statement

try to convert it as a date in the insert statement by using this function:
str_to_date('30 Jun 2009','%d %b %Y')

ouch you use chen model i'll have a look at it and try and make out heads or tails from that doc

well the first apparent error i see is the many to many relationship between the book and customer as one book can be loaned by many customer and a customer can loan many books, it is also not...

migrating from one rdbms to another is not as simple as dumping the sql scripts in the new rmdbs, unless you convert the entire script by hand a simpler solution is use a migrator tool to migrate and...

for your first question

start = int(raw_input("Start at: "))
end = int(raw_input("End at: "))
count = int(raw_input("Count by: "))

while start <= end:
print start
start =...

so first you will have a user table that links to a favourite_table that has the user id and a product category id that links to a product_category table in this table you a product category id and...

i don't think MySql has built in email functions like Oracle's PL/SQL so instead you will have to do it from the front-end system which i assume is php.

the f and m are synonyms for those tables the join is at the AND statement

or you can reverse the slash like such
C:/HourlyATC/ etc

try this i think it's just a little less complex than the inner join syntax

SELECT m . *
FROM members m, friends f
WHERE f.friend1 =1
and m.member_id = f.friend2

because the if statement will never equate to true person is a list and pname is a string.

just a point of interest have a look at the time() module it has very nifty function called strftime, then you could have something like this:

date = time.strftime('%m/%d/%Y',time.localtime())

you have to convert the num variable to a string
like such:
even_file.write('%s\n'%num)

this is a bad example, instead you should have a look at composite entities then.
in short hand notation a better design for you above example would be:
main(id,fname,uid,cid)...

i have no idea if this can be done in php but try using an anonymous block and then test the input variables if not create a stored procedure in the database that accepts whatever you are trying to...

that's horribly inefficient using an inner select on the same table

SELECT *
FROM $tbl1_name
WHERE age BETWEEN '$from' AND '$to'
AND sex='$show_all'

in oracle i know the magic tables are the insert and delete when using and update so i guess it's those or maybe it's dual...hope i passed the interview

no worries i found the error, i referenced foreign keys to tables that didn't exist yet

can someone help me identify the syntax error with this code

CREATE TABLE IF NOT EXISTS Persons
( id_number VARCHAR(13) NOT NULL
, name VARCHAR(45) NOT NULL
, name_2 VARCHAR(45)...

you can use a dictionary but it won't be wise to use the surname as the key instead use the position number. for the itemvalues you can use a list and you can append new values later if needed so...

the reason it's coming up as match is that they are equal so i suggest declaring ind1, ind2 and making one 0 and the other 1

users = ('user1','user2','user3')
passw = ('pass1','pass2','pass3')...

have a read through this
http://groups.google.com/group/python-excel/browse_thread/thread/eb3475b5438c3e50
the guy convert xlsx to xls and from there you can convert the xls into csv using xlrd

send to me my email is bobepoundmax@yahoo.com please don't spam my mailbox and include comments please

try this:

infoToWrite = "Harry Potter: Teenage boy who has an owl"
myFile = open("characterlist.txt",'r+')
myFile.write(infoToWrite)
myFile.flush()


you can put a raw_input() line beneath...

it works but not what kiddo asked for, the application that he/she wants, wants to check for keyboard inactivity and if 3 seconds passed it prints the question 'Are you ready yet' again.

regarding that link i posted on the last poster suggests flushing the stream.

strange because it works in my compiler i used komodo 5.0 with python 2.6
have a look at this you might find something
http://bugs.python.org/issue3207#msg68773
maybe you should close the the file...

thanks for picking that up but you can also swap the split() & strip(). so you split to get the intended result and then strip whatever whitespaces is still left

if i understand your problem correctly i think is what you want,

for line in open('myfile.txt','rb'):
numbers = line.strip().split('=')[1]
print numbers