UPDATE tableA, tableB
SET tableA.column2 = tableB.column2
WHERE tableA.rowID = tableB.rowID;
PB
- Original Message -
From: John Mistler
To: [EMAIL PROTECTED]
Sent: Saturday, May 29, 2004 12:16 AM
Subject: "Batch" Update?
Let's say I have a table "A" with 25 columns. I also
Let's say I have a table "A" with 25 columns. I also have an identical
table "B" with 25 columns (column names, indexes, everything the same). I
want to get the entry of column 2 of every row of table "B", and update
column 2 of every row of table "A" WHERE the rowID from table "A" matches
the ro
Hi all,
I have just installed mysql 4.0 on my XP. I inserted data into the db by
java. Then I used
1) command prompt to select from the table
2) MysqlCC
3) JDBC to retrieved the inserted data.
It's ok. However, after a while (like rebooting my notebook, or hibernate my
notebook... but not repe
Jose,
First I would recommend fixing your site.
Warning: main(db/db.php): failed to open stream: No such file or directory
in /home/uc0208ea/public_html/mainfile.php on line 77
Fatal error: main(): Failed opening required 'db/db.php'
(include_path='.:/usr/lib/php:/usr/local/lib/php') in
/home/uc0
OK I have one more scenario I need some help with. Say im using master
and slaves replication and i have N ammount of servers would mysql be
able to have say 10 databases with about 30 tables per db and a
total of say 100 megs of data per/db. would the server be able to manage
that. conside
The length of indexes on varchar and char indexes can be specified at
index creation.
What is the default length of an index if no length is provided?
The High Performance MySQL book hints that the index-length used is
specific for each entry in the indexed column (ie an index on a column
where
I think this is pretty simple, but I'm not thinking
very clearly at the moment, and I want to make sure I
get it right. I want to create a database with
information on the world's nations and smaller
jurisdictions (e.g. states and provinces) AND on
physiographic and bio/ecological regions.
My prim
thanks all for your responses. so basically replication would be one
option. now how many servers do you think i would need to replicate to
have say a set of mysql servers and then on top of that have a set of
say 50 application servers 25 accesing each server would that be
feasable consideri
You wouldn't setup one repository to hold the data. You would actually
probably hit disk and network limitations with a single repository.
MySQL supports master/slave setups which would replicate the data
across machines. One machine would be the "master" handling updates
which would propagate
In the last episode (May 28), Bono, Saroj AA R62 said:
> Non zero indicates an error but the possible values are (from
> errmsg.h) Return Values Zero if the query was successful. Non-zero if
> an error occurred.
>
> Errors
> CR_COMMANDS_OUT_OF_SYNC
> Commands were executed in an improper order.
>From the docs at: http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html
"Databases in MySQL are implemented as directories containing files that
correspond to tables in the database. Because there are no tables in a
database when it is initially created, the CREATE DATABASE statement only
create
> > This makes perfectly sense.
> >
> > So, once again I dare to ask: what's the problem with NULLable
> > Foreign Keys? It works fine :-)
> >
> > (now, who was it that said that FKs should be entered/exist
> > always?)
> >
> > With regards,
>
> Here is the issue...
>
> If you go back to what he w
On Fri, May 28, 2004 at 12:04:53PM -0400, Brian Muha wrote:
> Hello all and I hope this email finds you all well..
>
> My question is I currently have passwords encrypted in SHA1 via LDAP...
>
> What I need to do is get these user names and passwords out of ldap and
> placed in mysql ..
>
> The
Non zero indicates an error but the possible values are (from errmsg.h)
Return Values
Zero if the query was successful. Non-zero if an error occurred.
Errors
CR_COMMANDS_OUT_OF_SYNC
Commands were executed in an improper order.
CR_SERVER_GONE_ERROR
The MySQL server has gone away.
CR_SERVER_LO
Victoria and Robert
Thank you for your help. I think it is solved.
The error was (as Robert said) "ERROR 1005: Can't create table
'./alex/jmf33.frm' (errno: 150)"
I aslo checked "SHOW INNODB STATUS" where I was redirected to
http://www.innodb.com/ibman.html
There I found a link to a document sa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 28 May 2004 11:50 am, Martijn Tonies wrote:
> This makes perfectly sense.
>
> So, once again I dare to ask: what's the problem with NULLable
> Foreign Keys? It works fine :-)
>
> (now, who was it that said that FKs should be entered/exist
> a
On Fri, May 28, 2004 at 12:17:37AM -0500, mos wrote:
> As most people already know, MySQL has FullText indexing built into it, so
> why is mysql.com using MnoGoSearch? (There is an icon "Powered by
> MnoGoSearch" on the search page.)
>
> 1) Is there something wrong with MySQL's FullText search f
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 28 May 2004 11:50 am, Martijn Tonies wrote:
> This makes perfectly sense.
>
> So, once again I dare to ask: what's the problem with NULLable
> Foreign Keys? It works fine :-)
>
> (now, who was it that said that FKs should be entered/exist
> a
Hi,
> > Martijn Tonies wrote:
> >
> >> Hi Jeff,
> >>
> >
> >
> > In this example, inno3.PK_Col references inno2.Child_Col, so the 2nd and
> > 3rd statements are failing because they try to set inno3.PK_Col to
> > values not present in inno2.Child_Col. The NULLs are irrelevant.
Woops, right Mich
Michael Stassen wrote:
Martijn Tonies wrote:
Hi Jeff,
In this example, inno3.PK_Col references inno2.Child_Col, so the 2nd and
3rd statements are failing because they try to set inno3.PK_Col to
values not present in inno2.Child_Col. The NULLs are irrelevant.
Michael
Perhaps this is what you
Martijn Tonies wrote:
Hi Jeff,
CREATE TABLE inno2 (
PK_Col Integer NOT NULL DEFAULT 0,
Child_Col Integer,
PRIMARY KEY (PK_Col)
) TYPE=InnoDB ;
CREATE INDEX I_Inno2_ChildCol
ON inno2(Child_Col);
CREATE TABLE inno3 (
PK_Col Integer NOT NULL DEFAULT 0,
Child_Col Integer,
PRIMARY KEY (PK_Col)
) TYPE=I
Not sure if this will help, but we recently ran into a problem
building MySQL on a Solaris 9 system - the build failed at the
point of trying to make "readline" because of a missing file
Makefile.in. It turned out that automake wasn't available,
and automake is required to do the make. When we in
>On Thu, May 27, 2004 at 03:59:46PM -0400, Bono, Saroj AA R62 wrote:
>> I am going to use mysql_query() and want to find out if a certain
>> database exists. If mysql_real_connect() fails there are many errors
>> that could account for this. The database may exist , and I cant take
>> the error r
I have a program which read rows from one table (new_data) and attempts to find a
matching record in another table, called master_table. Upon determining a that we
have seen a record from this client (in new_data) before, based upon some exact
matching and probability matching logic, we insert
Hello all and I hope this email finds you all well..
My question is I currently have passwords encrypted in SHA1 via LDAP...
What I need to do is get these user names and passwords out of ldap and
placed in mysql ..
The application is qmail/courier..
The question is can i just take the already
Also, suggest you read
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html and in
particular look to see if you're getting error 1005 or 105 returned. That was the
purpose of my original question to you.
Bob
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL
[EMAIL PROTECTED] wrote:
>
> I've been running MySQL 4.0.x on a RH9 machine for some months and everything
> was fine. I could create tables of type InnoDB and define FOREIGN KEY's all
> was well.
>
> A few days ago it does not let me create tables with foreign keys anymore it
> says some
Hi Jeff,
> > ok - I've checked.
> >
> > > > > Why not? What's wrong with this:
> > > > >
> > > > > BORROWER
> > > > > BorrowerID
> > > > >
> > > > > BOOKS
> > > > > BookID
> > > > > BorrowerID (nullable)
> > > > >
> > > > > FK from Books.BorrowerID to Borrower.BorrowerID
> > > > >
> > > > > I have
Why not search on if it's there, if no results are returned, you know
it's not there.
SELECT count(*) as langcount from db where lang=$lang;
If you want to check for multiple items at once:
SELECT count(*) as langcount from db where lang in ('lang1', 'lang2',
...)
Since you don't want to actual
Hello,
I have a Red Hat 9 server which runs a qmail/toaster software package.
It allows webmail to authenticate against a mysql db and stores mail
there too.
K, the issue..
Every once in a while, the web client just SITS at authentication. The
client just sits there forever. The login
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 28 May 2004 02:57 am, Martijn Tonies wrote:
> Hi,
>
> ok - I've checked.
>
> > > > Why not? What's wrong with this:
> > > >
> > > > BORROWER
> > > > BorrowerID
> > > >
> > > > BOOKS
> > > > BookID
> > > > BorrowerID (nullable)
> > > >
> > > >
Bono, Saroj AA R62 wrote:
When I created a database (directly in mysql) from some random dir where
I started mysql, I found that it got created in the /var/lib/mysql dir.
I ran mysql from a dir where my C++ program is. I wanted to create a
database using mysql_query so I did mysql_query( &mysql,
Hello,
I've been running MySQL 4.0.x on a RH9 machine for some months and everything
was fine. I could create tables of type InnoDB and define FOREIGN KEY's all
was well.
A few days ago it does not let me create tables with foreign keys anymore it
says something like "unable to create /da
When I created a database (directly in mysql) from some random dir where
I started mysql, I found that it got created in the /var/lib/mysql dir.
I ran mysql from a dir where my C++ program is. I wanted to create a
database using mysql_query so I did mysql_query( &mysql, "CREATE
DATABASE IF NOT E
It depends on what language you are using to send the query.
If you are using the shell, 'S\'ARENAL' parses to 'S'ARENAL' before it
is sent to the server.
You will need to escape the escape character.
'S\\'Arenal'
or maybe even 'S\\\'Arenal' or 'S'ARENAL'
It depends on how many parsers scan
Josef Karthauser <[EMAIL PROTECTED]> wrote:
> On Fri, May 28, 2004 at 03:05:53PM +0300, Victoria Reznichenko wrote:
> > Josef Karthauser <[EMAIL PROTECTED]> wrote:
> > > In the old days of mysql (version 3.x) the mysqldump command would
> > > produce one text line per database row, but since then i
Carlos Sunden <[EMAIL PROTECTED]> wrote:
>
> The mysql client & mysql-devel packages did it.
> Was able to change the password which I did with a
> very easy one. Now when I want to change the existing
> password & it fails. It does not let me.
You must specify old password when you set a new one
Hi,
sharing a data directory between different servers (probably using nfs) is
not a good idea and it would create a new bottleneck.
A quote from the very fine manual:
"Make it easy for yourself: Forget about sharing a data directory among
servers over NFS. A better solution is to have one compu
Hello,
I have several tables that have a common column. I need to check those
tables for 1 of 4 items. If that item does not exist, I jump to a page
saying it is coming soon...
I am passing a variable ($lang) around using php to select info based on
that column.
what would be a suggested sel
On Fri, May 28, 2004 at 03:05:53PM +0300, Victoria Reznichenko wrote:
> Josef Karthauser <[EMAIL PROTECTED]> wrote:
> > In the old days of mysql (version 3.x) the mysqldump command would
> > produce one text line per database row, but since then it appears to
> > have been replaced with an "extende
Dear all,
I have an auto_increment value in an innodb table. I recently introduced
a new row by mistake and removed it. I beleive I read somewhere in the
manual that an innodb table does not reuse this number by default. I
also remember vaguely that it is possible to reset this next
autoincrement
There are a number of steps after installation that need to happen
before you will be able to connect:
http://dev.mysql.com/doc/mysql/en/Unix_post-installation.html
naresh bhalala wrote:
Respected Sir/Madam,
I have download the MySQL4.0 from www.dev.mysql.com
and file is
:mysql-standard4.0.20-pc-
naresh bhalala <[EMAIL PROTECTED]> wrote:
> Respected Sir/Madam,
> I have download the MySQL4.0 from www.dev.mysql.com
> and file is
> :mysql-standard4.0.20-pc-linux-i686.tar.gz.
>
> I have installed it as bellow:
> #gunzip -9c standard4.0.20-pc-linux-i686.tar.gz | tar
> -xvf -
> and all files
Egor Egorov wrote:
fr0g <[EMAIL PROTECTED]> wrote:
Well I'm in despare.
I have a record in my DB with name=Michalis and surname=Ka*l*ogiannis.
When I try to add name=Michalis and surname=Ka*k*ogiannis I get the
error about duplicates.
It doesn't give an error in the english field, but it does i
Respected Sir/Madam,
I have download the MySQL4.0 from www.dev.mysql.com
and file is
:mysql-standard4.0.20-pc-linux-i686.tar.gz.
I have installed it as bellow:
#gunzip -9c standard4.0.20-pc-linux-i686.tar.gz | tar
-xvf -
and all files r extraced in
folder:standard4.0.20-pc-linux-i686
Now i've
fr0g <[EMAIL PROTECTED]> wrote:
>
> Well I'm in despare.
> I have a record in my DB with name=Michalis and surname=Ka*l*ogiannis.
> When I try to add name=Michalis and surname=Ka*k*ogiannis I get the
> error about duplicates.
> It doesn't give an error in the english field, but it does in greek
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.14, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.0.14 is a bugfix release for the production tree that is
suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0.
Well I'm in despare.
I have a record in my DB with name=Michalis and surname=Ka*l*ogiannis.
When I try to add name=Michalis and surname=Ka*k*ogiannis I get the
error about duplicates.
It doesn't give an error in the english field, but it does in greek
fields (with greek characters) even though K
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jan Goyvaerts (jgoyvaer) wrote:
> Same here. Went back to the 3.0.12 drivers.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 28, 2004 10:24 AM
> To: [EMAIL PROTECTED]
> Subject: Could not getConn
Josef Karthauser <[EMAIL PROTECTED]> wrote:
> In the old days of mysql (version 3.x) the mysqldump command would
> produce one text line per database row, but since then it appears to
> have been replaced with an "extended insert" format which is more
> efficient for getting data back into the data
Yueming Xu wrote:
We downloaded 4.1.1a build, but all the new APIs for transaction and
prepared statements are missing from the libmysql.dll. Is there a build
for 4.1.x that we can use to test these APIs? Thanks.
_
MSN Toolbar pro
Hello,
did anybody make any tests to check the speed of 4.1 version comparing
with 4.0.*? Does the peformance of 4.1 depend in which client libraries
are used - 4.0 or 4.1? As the docs say, the new client/server protocol
with support for prepared statements has to be faster, and it would be
useful
Scott Haneda wrote:
on 05/28/2004 12:31 AM, fr0g at [EMAIL PROTECTED] wrote:
I don't see how this mail helps me.
I still don't know why it sais I have a duplicate record and still don't
know how to correct this.
Those were nice stories, but not really helpfull.
In my table every record has a uin
I have been running into problems with mysqldump. I have not been able to figure out
why mysqldump isnt working as I hope it would. Anyway I thought I'll make the
mysql-list aware of the problem and hopefully it will help someone. Or better yet
someone knows what I am doing wrong and could point
Hi!
In April, the "MySQL Certification Study Guide" was published by MySQL
Press. By now, it has arrived in bookstores across the world.
The main parts of the book are written by Paul DuBois, Stefan Hinz and
yours truly. Paul needs no introduction; Stefan has translated several
MySQL books to Ger
Hi Paul,
assuming that the first three occurances of blanks can be regarded as
field separators you can do:
prompt> cat file.txt | sed \
-e "s/'/'/g" \
-e "s/ */','/" \
-e "s/ */','/" \
-e "s/ */','/" \
-e "s/^/INSERT INTO categories VALUES('/" \
-e "s/$/');/" | mys
In the old days of mysql (version 3.x) the mysqldump command would
produce one text line per database row, but since then it appears to
have been replaced with an "extended insert" format which is more
efficient for getting data back into the database.
The old format was good however for running "
Sergei Golubchik wrote:
Hi!
On May 27, [EMAIL PROTECTED] wrote:
Description: Using the GRANT command causes the password to be
deleted until 'FLUSH PRIVILEGES' is executed. This is a security
problem.
Search the bugdb - http://bugs.mysql.com/
the bug is reported there and is already
Same here. Went back to the 3.0.12 drivers.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, May 28, 2004 10:24 AM
To: [EMAIL PROTECTED]
Subject: Could not getConnection as before with Connector/J v3.0.13
Hi,
I tried to use the latest jdbc driver v
Do u know how many users the MySQL server v4 can't support?
I am talking about the users that are currently online.
I want to know the maximum number for the MyISAM tables and InnoDB
Do u know any links for continue reading?
Thx
-
Do you Yah
> Hi, How can I make a query that looks for a city that has a " ' " in
> the name? For instance, I am looking for the name S'ARENAL, but the
> query below does not work:
>
> SELECT intl_localidades.id, intl_localidades.codigo_pais,
> intl_localidades.localidad_es,intl_zonas.zona,intl_paises.pais_es
Hi, How can I make a query that looks for a city that has a " ' " in the name? For
instance, I am looking for the name S'ARENAL, but the query below does not work:
SELECT intl_localidades.id, intl_localidades.codigo_pais,
intl_localidades.localidad_es,intl_zonas.zona,intl_paises.pais_es FROM
in
Hi!
On May 27, [EMAIL PROTECTED] wrote:
> >Description: Using the GRANT command causes the password to be
> deleted until 'FLUSH PRIVILEGES' is executed. This is a security
> problem.
Search the bugdb - http://bugs.mysql.com/
the bug is reported there and is already fixed.
Regards,
Sergei
--
Hi,
I tried to use the latest jdbc driver v3.0.13. However, the program I
coded no more work. It works well with v3.0.12.
The new driver does not accept the following connect url string:
jdbc:mysql://localhost/trdb?useUnicode=true&characterEncoding=UTF-8
The following exception occurs:
ja
Hi,
I wrote an jdbc application and inserted strings data into the
database. I can correctly selected them back. However, I can not visually
see the data stored in the data through the MySQLCC GUI. Is there a way to
explicitly specify the character set for MySQLCC? Any idea?
Regards,
Micha
on 05/27/2004 06:30 PM, tachu at [EMAIL PROTECTED] wrote:
> WOuld the following scenario be possible
> I currently have about 1.2 Tb of data that i need to transform into
> mysql and be able to server a very high amount of pages from a
> discussion board. would i be able to place the mysql/data di
on 05/28/2004 12:31 AM, fr0g at [EMAIL PROTECTED] wrote:
> I don't see how this mail helps me.
> I still don't know why it sais I have a duplicate record and still don't
> know how to correct this.
> Those were nice stories, but not really helpfull.
> In my table every record has a uinque id which
Hi,
ok - I've checked.
> > > Why not? What's wrong with this:
> > >
> > > BORROWER
> > > BorrowerID
> > >
> > > BOOKS
> > > BookID
> > > BorrowerID (nullable)
> > >
> > > FK from Books.BorrowerID to Borrower.BorrowerID
> > >
> > > I haven't checked, but this _should_ be possible.
> > >
> > > With
I don't see how this mail helps me.
I still don't know why it sais I have a duplicate record and still don't
know how to correct this.
Those were nice stories, but not really helpfull.
In my table every record has a uinque id which ofcourse is the key.
Yet, the only way I can avoid duplicates is t
69 matches
Mail list logo
