Hey,
Thanks. But, I used this Full text search in my table. but, i couldn't search less than 3 characters as my input. so What is the solution for this?
sudhakar
sudhakaranr
Last Activity: Oct 24 '08, 05:48 AM
Joined: Dec 19 '06
Location:
-
How to index a TEXT field to increase search performance?
Hi all....
I am using table, which has 5 million rows. In this, i have a column called "comp_name" . this is defined as TEXT.
If i want to search a particular pattern in the text field, it is taking enormous time.
so, i want my search faster....
What are the possibilities to make it faster?
Your help is highly appreciable.... ..
Thanks -
How to insert "\n" in mysql using php
Hi Guys....
My input is something like this "c1cc(c(cc1 )I)/C=N\n1c(nnc1)S" .
You can see the "\n" in between the input. It is not a newline character as my input has that character. I want to insert the input as it is. But When I try to insert into mysql database, it's stored as two lines like the below..
c1cc(c(cc1)I)/C=N
1c(nnc1)S
I want to insert as it... -
my code works slow. need some other logic
Hi all,
I have given my code here and it's updating the database slowly.
Can you give me some other logic.
comparing talble has 3million rows. i shoud update 1million rows.
it's taking 4 seconds to load one row..it's very slow.
please help me
[PHP]<?php
mysql_connect(" localhost", "root", "sudr");
mysql_select_db ("adsd");... -
Hi thanks for the query...
I already mentioned that i am newly started to program...
I have already started to study PHP-MySQL.
I tried that but I couldn't.
Next time defenitly, i will come with my code...
thanks...Leave a comment:
-
No, we have pid column field already...
what we want to do is.. we should match the pid with the text files and if it is matching ...then we need to upload the the file in the content (longblob)field automatically
I dont want to enter manually...Leave a comment:
-
transfer the columns of one table into another table with condition
hi all,
In table1, i have 6 columns and in table2, i have 10 columns.
i want to transfer 5 columns from table2 to table1 with the condition.
the condition is..
both the tables have primarykey, if the primary key in table1 matches with table2's primarykey, then we should trafer the selected column in to table1 from table2.
I want a query for the above..
Please... -
How to enter the text file in to LongBLOB field.
HI ALL,
I am new bie to mysql...I have 100 files as text files and each text file are having minimum 25 lines.I want to enter all the files in to Mysql DB.
My query is, In mysql table, i have a columns like pid(PRIMARY KEY),content(LO NGBLOB).
In table, Pid has entries like p1,p2,p3.....
Now in a directory, i have text files like p1.txt,p2.txt,p 3.txt.....
I want to upload the text files... -
Ok barton..No problem....Leave a comment:
-
I don't know whether my python-cgi code is correct or not...
you people have to say!!!!!!!!!!
Because i am beginner, just now started to program in cgi..
This is the output, i am getting when i run it in IDLE.
...Code:Connected<br/> sudhakar: srf<br/> 4 rows were returned<br/> anand: scientist<br/> 4 rows were returned<br/> ramesh: jrf<br/>
Leave a comment:
-
Thanks!!!!Leave a comment:
-
Actually,I am using apache 2.2 server. so i will store the programs in apache-cgi-bin. then i will run that program in browser using the cgi-bin path.
In is simple cgi program...
we r not giving any specified browser path.
like that..i am testing to connect the mysql...Code:#!C:\Python25\python.exe print "Content-Type: text/html\n\n" print "hello"
Leave a comment:
-
Hi barton..
the line cursor = conn.cursor() is in right position only.. there is no identation error... i pasted it correctly..but that line moved one tab. I dont know why? But in my code it is in right position only..
I am not getting any thing in the browser page, when i run this program...
It's plain....
...Code:try: cursor = conn.cursor() cursor.execute("SELECTLeave a comment:
-
sorry, now it's in code tag:-
...Code:#!C:\Python25\python.exe print "Content-type: text/html\n\n" import sys import MySQLdb try: conn = MySQLdb.connect(host="localhost",user="root",passwd="sudhakar",db="test"); print "Connected<br/>" except: print "Cannot connect to server.</br>"
Leave a comment:
-
Apologize!!!!!! !!!!!!!!!!!!
Here is my code...
It is not working...but when i connect mysql in standalone python code, it's working...
Please check my code and reply...
thanks..
...Code:#!C:\Python25\python.exe print "Content-type: text/html\n\n" import sys import MySQLdb try: conn = MySQLdb.connect(host="localhost",user="root",passwd="sudhakar",db="test");
Leave a comment:
-
mysql - python cgi connection
Can anyone help me to connect the mysql with python-CGI.
I tried it. but it doesn't work.
please help me. -
Help me to refer the books for Python-CGI and webs
hi all,
I am a beginner in python. I knew the concepts of python and i want to implement the python-cgi programs.
But i dont know where to start?
So anyone help me to refer the books for Python-CGI and webs?
Thanks in advance -
sudhakaranr replied to how to open a directory and i should read the files and need a particular linein PythonThanks bv !!!!!!!!
It's really useful to me...
Thanks alot...Leave a comment:
-
sudhakaranr started a topic how to open a directory and i should read the files and need a particular linein Pythonhow to open a directory and i should read the files and need a particular line
HI,
Need your help please...
First thing, i want to open a directory and with in the directory i have 1000's of files and we need to read the file and i want a particular line which has the word "ID".
for example:
in a directory... i have file like the below.
-) abc1
-) abc2
-) abc3 like this i have 1000 files...
in the file abc1 -> i have... -
how do i run a zope web application in web browser?
HI all,
When i run a page template using page, it's running inside the zope management page...
I want to run a web application in web browser...
Can any one help me to run...
thanks in advance...Leave a comment:
No activity results to display
Leave a comment: