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
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
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
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
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
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
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? (
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,
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
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
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
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
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
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:
| 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.
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
>
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,
(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` (
`
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
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
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
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
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
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
24 matches
Mail list logo