Update in select

Im attempting to update a table. We perform a select on the table to determine what row to update. update test a set visit_date = now() where a.id in (select b.id from test b where code ='Z') Running this generates an error. "You cant specify target table 'test' for update in FROM clause." I

Re: Problem with priv_db

Elian Kool <[EMAIL PROTECTED]> wrote: > I just upgraded to 4.0.12. > > I ran the mysql_fix_privilege_tables script to add the new privileges. > > Unfortunately, "SHOW DATABASES" still shows every users all databases. > > mysql> show grants for [EMAIL PROTECTED]; > GRANT REFERENCES, INDEX, ALTER,

Re: mysqldump suddenly returns error 1064

David Precious <[EMAIL PROTECTED]> wrote: > > I hope this isn't an obvious question, but I'm having a hard time figuring > this one out. > > I have a cron job set up to run mysqldump regularly to dump my databases out > to a flat file, which is then compressed and passed to our backup server by

Nested query issue in MySQL 4.1

Hello all I have a problem to report. There is a SELECT query that selects data from three tables according to certain criteria. It goes like this: SELECT bglavna.T001, bpolja.ID AS ID2, bpotpolja.TEKST FROM (bglavna INNER JOIN bpolja ON bglavna.ID=bpolja.FK) INNER JOIN bpotpolja ON bpolja.ID=bpo

RE: [My Solution] Re: Mailing Labels from MySQL database on web

Hi One more suggestion that does work reasonably well. Generate a basic HTML page with a table laid out to suit the labels, in php, with addresses in place Write the page to your webspace as labels.htm (you will need to set permissions to allow this) You then need a program that will open and pr

Re: How to handle Date related types in Java?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Venkata Srinivasa Rao, Yerra wrote: > Dear All, > > Any body know how to handle DATE related types in Java. It seems > JDBC driver fails to construct java.sql.TimeStamp object or > java.sql.Date object. > > Thanks in Advance. > > Best Regards, > S

Creating a Table (wot no GUI?)

Excuse my naivety but how do I create a Table in MySQL? I can’t find any Text/Windows based programme that allows be to create and edit the table, fields, data types, size etc? I’m not looking for anything complex. Many thanks, Ed Edward Hasted Contact Information: E-mail : [EMAIL PROTECTED] T

[My Solution] Re: Mailing Labels from MySQL database on web

Thanks for all the ideas. Here is a list of the basic paths suggested along with the comments given for each method. Nobody claimed any of these was really good and hoped someone would suggest a better approach. 1. Use MS Word's mail merge and MS Query with MyODBC as the data source. - On

mysqld process hanging

I saw in my log file and I get an error as below Number of processes running now: 1 mysqld process hanging, pid 9444 - killed 030528 20:21:21 mysqld restarted /usr/libexec/mysqld: ready for connections and there is a lot of error message like that. what happen and how to solve that.? thanks in a

Re: Select name, email where birthday = ??

Hello, I have a date field in my database Format is -MM-DD Once a day at 12:01AM a script is going to run that will Select name, email from users where birthday = ?? And the ?? Is where I am stuck, I don¹t care about the year at all, I just need to match on the month and day, how would I do t

Re: InnoDB backup - the best way.

Dnia Wed, 28 May 2003 12:57:59 +0200 Jarek Jarzebowski <[EMAIL PROTECTED]> zeznał/a co następuje: > Hi, > > I have MySQL 4.0.12 working on Debian Linux box. DB server uses MYISAM > and InnoDB tables. MySQL docs shows what is the best way to backup > InnoDB tables but I don't want to shutdown db

InnoDB backup - the best way.

Hi, I have MySQL 4.0.12 working on Debian Linux box. DB server uses MYISAM and InnoDB tables. MySQL docs shows what is the best way to backup InnoDB tables but I don't want to shutdown db server every backup time. I suppose it is not a good idea to just copy database files and innodb log files

How to handle Date related types in Java?

Dear All, Any body know how to handle DATE related types in Java. It seems JDBC driver fails to construct java.sql.TimeStamp object or java.sql.Date object. Thanks in Advance. Best Regards, Srinivas. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.griso

Re: connect to mysql

"Robert Morgan" <[EMAIL PROTECTED]> wrote: > > Hi I have installed mysql on a linux box connected to my win2000 PC and have > installed mysqlyog on win2000 pc when I try and connect through mysqlyog I get the > error "error no.2013 lost connection to server during query" > any help appreciated.

Re: load infile problem

"jsmurthy" <[EMAIL PROTECTED]> wrote: > Hi All, > > Iam facing the problem in MySql "Load infile" > MySql - Version 4.0.12 > > The following is the query iam using and the fields in the flat file are > separated by character ^G. > > LOAD DATA INFILE "/home/dbmigration/migration130_160/ttt.dat" >

Re: multiple unique updates

"Andrew Hazen" <[EMAIL PROTECTED]> wrote: > > Does anyone know a way to do multiple unique updates in one query, the > way you can in an insert query? > > > > I have a table with several thousand records. Periodically every record > in this table needs one field to be updated. Slows down the

Re: hostname-bin.xxx file what is this

"Knight Raider" <[EMAIL PROTECTED]> wrote: > I installed MySQL that comes with RedHat 8, after run it I noticed that lot > of file created in my data directory, file name is something like > 'myhostname-bin.xxx' where xxx is the number, and it take lot of disk space. > > What the file is use for

Re: Copy Database?

John Wards <[EMAIL PROTECTED]> wrote: > > I have a a database lest say called "test" which is about a gig in size. I > want to take a copy of that database and call it "test2" and have it running > on the same server. > > I could just do a dump and then insert the dump back in but this seems a

(2014) Commands out of sync; You can't run this command now

MySql, Hope you can help. I'm suddenly, after updgrading to MySQL 4.0.13-max-log Linux, getting the error: (2014) Commands out of sync; You can't run this command now On the second command I send to MySQL. First, no problem. I'm using MyC libruary, which has worked before. Various pages on

Re: database permissions

* [EMAIL PROTECTED] > What the permissions/ownership be on my database directory? > > I think is the cause of my problem of only being able to startup > mysqld as 'root'. On my system the mysqld deamon runs as mysql and files are owned by mysql. -- Jon Haugsand, [EMAIL PROTECTED] http://www.

Re: database permissions

oops, oh yeah. I fixed it. TR On Wednesday, May 28, 2003, at 05:56 AM, [EMAIL PROTECTED] wrote: What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. Thanks. Ted -- MySQL General Mailing List For list

problem with phpMyAdmin authentication

Hi All, I have a problem with phpMyAdmin authentication feature. I've setup the cookie authentication feature for phpMyAdmin as explained in the manual. It works perfectly on my PC with easyphp. But when I've done the same thing on my Cobalt RaQ4 server, I get a pop-up asking for the login/password

Re: Replication with non permanent connection

> I'm going to setup a mySQL database that has to be accessed from Asia > and Europe. Due to the huge distance I plan to duplicate the database > and store one copy both in Europe and Asia. To achive data consistency > both databases has to synchronize each other. Because of the long > distance a

database permissions

What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. Thanks. Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Copy Database?

> I have a a database lest say called "test" which is about a gig in size. I > want to take a copy of that database and call it "test2" and have it running > on the same server. > I could just do a dump and then insert the dump back in but this seems a > rather long way of doing it. I had a searc

Replication with non permanent connection

Hi all I'm going to setup a mySQL database that has to be accessed from Asia and Europe. Due to the huge distance I plan to duplicate the database and store one copy both in Europe and Asia. To achive data consistency both databases has to synchronize each other. Because of the long distance a dis

Copy Database?

Hi mysql list, I have a a database lest say called "test" which is about a gig in size. I want to take a copy of that database and call it "test2" and have it running on the same server. I could just do a dump and then insert the dump back in but this seems a rather long way of doing it. I had

hostname-bin.xxx file what is this

I installed MySQL that comes with RedHat 8, after run it I noticed that lot of file created in my data directory, file name is something like 'myhostname-bin.xxx' where xxx is the number, and it take lot of disk space. What the file is use for and how to avoid it? Thanks in advance. __

mysqldump suddenly returns error 1064

Hi all, I hope this isn't an obvious question, but I'm having a hard time figuring this one out. I have a cron job set up to run mysqldump regularly to dump my databases out to a flat file, which is then compressed and passed to our backup server by another script. The cron job runs the comm

Re: User Variables doesn't work?

Thanks for your info, I d/l SQLyog and it seems really cool. > MySQLFront 2.5 had so many bugs that I had to leave > it. I prefer SQLyog now. Its FREE !!! and has all the > features ( plus some realy cool extra features ). > > You can try SQLyog at http://www.webyog.com/sqlyog > > Karam > --- Pe

Re: Just a doubt.....

Hi, I made a table with a primary key,and all the columns i declared char got converted into varchar. plz someone throw a light on it as i had seen somewhere that using primary key increase search speed and using varchars decrease so im in confusion. :( http://www.mysql.com/doc/en/Silent_column_cha

mysql crashe-binary logs

Hello, I use mysql 3.23.49 on Solaris and I have started binary logging.. I had no problem for quite a long time but the last days I see this message in the error log file mysqld restarted /usr/local/mysql/libexec/mysqld: ready for connections Any idea why this is happening? -- MySQL General M

Just a doubt.....

Hi, I made a table with a primary key,and all the columns i declared char got converted into varchar. plz someone throw a light on it as i had seen somewhere that using primary key increase search speed and using varchars decrease so im in confusion. :( --

Re: help with load from file

We, ok. Thank you all. This worked quite nicely and I learned something to boot! TR On Tuesday, May 27, 2003, at 11:00 PM, Steve Gums wrote: The numbers should be without the quotes and the end of line character can stay as is. Once you have this you should be able to do something like this