find a particular record.

2007-06-28 Thread Ananda Kumar
Hi All, I am doing this to move data from one table to other and getting below error. How can check this particular record at this row number 921888 in dats_tem table. insert into reports1.dats1 select * from dats_tem; ERROR 1292 (22007): Incorrect datetime value: '-00-00 00:00:00' for colu

Re: Document archiving

2007-06-28 Thread John Meyer
David T. Ashley wrote: > > Also, I have to say this to be complete ... > > You were aware, of course, that nearly every modern copyright for books > prohibits digitizing the book and using it in any kind of document > retrieval > system? In fact, I believe a violation has occured even if it is sca

Re: Document archiving

2007-06-28 Thread John Meyer
Eddy D. Sanchez wrote: > Hello Everyone. > > I want to scan a large quantity of books and documents and store these > like images inside or outside a database, I want use mysql, anyone > have any experience with this kind of systems, can you suggest me an > opensource solution ?? First question I

Re: Document archiving

2007-06-28 Thread John Meyer
Eddy D. Sanchez wrote: > Thanks for your answer. > > I'm searching an opensource project (based on mysql obviously) that I > can hack for my needs, but if I can't find anything, I must make one, > my intention for technology is: > -Java for application server and framework Might I ask why you need

Re: LOAD DATA INFILE

2007-06-28 Thread mos
At 01:08 PM 6/27/2007, you wrote: Hi, I have a question on LOAD DATA INFILE command. I have a table with 10 columns. Is it possible to update only few columns of this table using LOAD DATA INFILE? No. As you found out Load Data loads the specified columns and sets the other columns to NUL

about the username and hostname

2007-06-28 Thread Weiqi Wang
Dear everyone: I start mySQL by a shotcut in windowsXP so that I don't have to input my username, just password is required. That brings in a problem: I don't know my user name(I suppose it to be "root") and the server host, etc. Is there anyway I can find it out? (I suppose the server host is

Re: about the username and hostname

2007-06-28 Thread John Meyer
Weiqi Wang wrote: > Dear everyone: > > I start mySQL by a shotcut in windowsXP so that I don't have to input my > username, just password is required. That brings in a problem: I don't know > my user name(I suppose it to be "root") and the server host, etc. Is there > anyway I can find it out? (

Re: permissions on mysql db

2007-06-28 Thread Ananda Kumar
you mean at os On 6/28/07, Rolando Edwards (DBA) <[EMAIL PROTECTED]> wrote: check your Linux/Unix user privileges *Ananda Kumar <[EMAIL PROTECTED]>* wrote: Hi All, I have created a user and grant all previlages on all db and the user can connect from any machine with in the same doiman. Now,

Re: LOAD DATA INFILE

2007-06-28 Thread Ananda Kumar
Or, Load the data into a temp , and create necessary index on the required columns, Write a stored proc to update columns in the original table with values from the temp table based on key columns joins between both tables regards anandkl On 6/28/07, mos <[EMAIL PROTECTED]> wrote: At 01:08 P

How to order a string as integer

2007-06-28 Thread Magnus Borg
Hello list Got strings in the format "integer+(char)^0..1", ex 3456, 2323, 2324A, 2324B, ... I want to order them as they where integers, like: order by cast(STING as unsigned) desc But when using that query resulting in error 1292. And the result are not correct. How can I remove the

Re: How to order a string as integer

2007-06-28 Thread David T. Ashley
On 6/28/07, Magnus Borg <[EMAIL PROTECTED]> wrote: Got strings in the format "integer+(char)^0..1", ex 3456, 2323, 2324A, 2324B, ... I want to order them as they where integers, like: order by cast(STING as unsigned) desc But when using that query resulting in error 1292. And the resul

FULLTEXT + InnoDB = grounded?

2007-06-28 Thread Sven Schwyn
Hello I've seen the posts of Nov 9 last year concerning the slow but steady development of FULLTEXT indexes for InnoDB. Has this feature been dropped or is it still being worked on? My background: I'm working on a Rails project which needs fulltext index search on the db layer. For now I

Revised optimization question

2007-06-28 Thread Dave G
I asked a question yesterday that was quite onerous, so I have been working out some of the details today, and would like to re-post my question under a different light. I have a table called data__ProcessedDataFrames that can grow to be gigantic, and I need to speed up the query for pulling the d

Re: How to optimize this long query

2007-06-28 Thread Andrew Hutchings
Kwang Chin Lee wrote: > Hello, > > I have several tables storing item information, keyword (mainly for > searching), category and subcategory (also for searching). The query I am > using now is: > > SELECT i.*, it.*, ic.*, c.*, cs.*, s.*, st.* FROM item i > LEFT JOIN iteminfo it ON i.id = it

How do I change the Collation Variables?

2007-06-28 Thread Albert E. Whale
How do I change: | collation_connection| latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server| latin1_swedish_ci to latin1_bin? Is this in my.cnf? or is this another way to do this? -- Albert E. Whale, CHS CISA CISSP Sr.

Re: about the username and hostname

2007-06-28 Thread Eugene Mah
Check the properties of your shortcut to see what user name is specified in the command options Eugene Weiqi Wang wrote: > Dear everyone: > > I start mySQL by a shotcut in windowsXP so that I don't have to input my > username, just password is required. That brings in a problem: I don't know >

Group wise maximum

2007-06-28 Thread Dave G
I just posted a question with a subject of "Revised optimization question" and did some more searching and found the my problem should be titled "group-wise maximum". I need the group-wise maximum of this query based on payload_time: CREATE PROCEDURE `getElement`(IN id INT UNSIGNED,

RE: select statement with variable for table_reference?

2007-06-28 Thread Price, Randall
(Sorry for such a long post... I thought others may benefit as well as ED) Ed, Here is an example using a CURSOR and a TEMPORARY TABLE to do something similar to what you want (I think!): == CREATE TABLES == mysql> show create table mydatabases; CREATE TABLE `mydatabases` ( `

RE: about the username and hostname

2007-06-28 Thread Jerry Schwartz
If you are starting the MySQL command line client from a shortcut, then all you have to do is right-click on the shortcut and examine its properties. The entire command line will be there. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 0

Geographic math problem

2007-06-28 Thread M5
Not being very strong at math, I have a little problem that I'm not sure how to solve. Maybe someone can help me. Basically, given a point (latitude, longitude) and a radius (100 meters) (think circle), I need to compute an equivalent square: That is, two points that would correspond to two

Re: Geographic math problem

2007-06-28 Thread Philip Hallstrom
Not being very strong at math, I have a little problem that I'm not sure how to solve. Maybe someone can help me. Basically, given a point (latitude, longitude) and a radius (100 meters) (think circle), I need to compute an equivalent square: That is, two points that would correspond to two co

Re: Geographic math problem

2007-06-28 Thread mos
At 03:11 PM 6/28/2007, M5 wrote: Not being very strong at math, I have a little problem that I'm not sure how to solve. Maybe someone can help me. Basically, given a point (latitude, longitude) and a radius (100 meters) (think circle), I need to compute an equivalent square: That is, two points

Re: Geographic math problem

2007-06-28 Thread David T. Ashley
On 6/28/07, M5 <[EMAIL PROTECTED]> wrote: Not being very strong at math, I have a little problem that I'm not sure how to solve. Maybe someone can help me. Basically, given a point (latitude, longitude) and a radius (100 meters) (think circle), I need to compute an equivalent square: That is, t

dynamic sql in proc

2007-06-28 Thread Bryan Cantwell
I have the following proc... when I run it I get a response that says "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1". I just want a programatic way to upgrade db engine to innodb where I don't