hi guys,
we have a mysql replication setup in our production.
Master: mysql-5.0.77
slave: mysql-5.1.46
Recently, slave show many these kind of issues and SQL thread was stopped:
Last_SQL_Error: Error 'No data - zero rows fetched, selected, or
processed' on quer
e/part_3.html
-Original Message-
From: phark...@gmail.com [mailto:phark...@gmail.com] On Behalf Of Perrin Harkins
Sent: Friday, January 15, 2010 6:08 AM
To: Johan Machielse
Cc: Baron Schwartz; mysql@lists.mysql.com
Subject: Re: When using "FOR UPDATE" whole the table seems to lo
On Fri, Jan 15, 2010 at 2:54 AM, Johan Machielse
wrote:
> The problem is that multiple users can read and update the same field
> simultaneously (worse case) which could lead to unpredictable problems.
There are other ways to do handle most cases. For example:
UPDATE table SET value = value + 1
such a problem?
Thank you in advance.
Regards,
Johan Machielse
- Original Message -
From: "Baron Schwartz"
To: "Johan Machielse"
Cc:
Sent: Friday, January 15, 2010 3:14 AM
Subject: Re: When using "FOR UPDATE" whole the table seems to lock instead
of s
According to the MySql documention only the rows that are
> selected using the FOR UPDATE should be locked for other sessions, but
> somehow whole the table is locked. This post gives some general information
> and then shows 3 scenarios. The first 2 scenarios work as expected, but the
> last
Hi,
I have created a query to read and update a stock item by using the FOR UPDATE
statement. According to the MySql documention only the rows that are selected
using the FOR UPDATE should be locked for other sessions, but somehow whole the
table is locked. This post gives some general
I would like to prevent users from changing their passwords unless they have
grant permission. Is this possible?
We have an set of stored procedures for managing users/databases for a single
signon project that we are working on. The problem is if a user connects
directly to the database usin
e city or country names like "Chicago", "Barbados",
"Argentina/Rio_Gallegos", "New_York", and such.
I know little about how timezones are handled in MySQL, but that's why
I personally would stick to using the provided examples.
Still curious though why
On Mon, Mar 10, 2008 at 11:36 AM, Tim McDaniel <[EMAIL PROTECTED]> wrote:
> On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> wrote:
> >mysql -D mysql -u xxx -p < mysql_tzinfo_to_sql
> /usr/share/zoneinfo/America/
> >
> >The -D flag selects the database `mysql`, which is where the t
> Its example line is
> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
> There's a trailing "mysql", which specifies the "mysql" database.
> It also specifies all zoneinfo, not "America/".
Thanks, Tim. I totally missed the trailing mysql. Duh!
--David.
> On Mon, Mar 10, 2008 at 11:07 AM, <[EMAIL PROTECTED]> wrote:
>> I'm getting an error trying to run this command:
>>
>> root> mysql_tzinfo_to_sql /usr/share/zoneinfo/America/ | mysql -u xxx
-p
>> xxx
>>
>> ERROR 1046 (3D000) at line 1:
On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> wrote:
mysql -D mysql -u xxx -p < mysql_tzinfo_to_sql /usr/share/zoneinfo/America/
The -D flag selects the database `mysql`, which is where the time
zone information belongs. The < redirect reads from the "file"
(which, in this case, i
On Mon, 10 Mar 2008, [EMAIL PROTECTED] wrote:
I'm getting an error trying to run this command:
root> mysql_tzinfo_to_sql /usr/share/zoneinfo/America/ | mysql -u xxx -p
xxx
ERROR 1046 (3D000) at line 1: No database selected
The MySQL 5.0 manual explains mysql_tzinfo_to_sql
On Mon, Mar 10, 2008 at 11:07 AM, <[EMAIL PROTECTED]> wrote:
> I'm getting an error trying to run this command:
>
> root> mysql_tzinfo_to_sql /usr/share/zoneinfo/America/ | mysql -u xxx -p
> xxx
>
> ERROR 1046 (3D000) at line 1: No database select
I'm getting an error trying to run this command:
root> mysql_tzinfo_to_sql /usr/share/zoneinfo/America/ | mysql -u xxx -p
xxx
ERROR 1046 (3D000) at line 1: No database selected
Funny thing is I know I've run this on 2 other servers with identical
software without issue, howev
You said:
It is not locking the entire table. It's locking the rows you're
selecting. If you don't want the second session to hang and wait,
then you need to tell it to lock different rows.
Well if you read my message, I dont want another script to select the
rows that are sele
gt;>>
> >>>> Ok, let's assume I 've a table and want to select the first 10 rows from
> >>>> that table but I want to be sure that no other scripts will select the
> >>>> same rows I've previously got by the first script.
>
>> How can I do that?
> >>
> >> my table contains one primary key. Let's say id is the column name.
> >> So my first script is running and select the ids: 1, 2, 3 10
> >>
> >> Then that script will play with the returned ids.
&
script will play with the returned ids.
In the same time, I'm running a second script and do the same select.
But I don't want him to get the first 10 ids.
The only thing I can think about is to lock WRITE my table. I taught
innodb was able to automatically lock the selected rows and
ng and select the ids: 1, 2, 3 10
>
> Then that script will play with the returned ids.
> In the same time, I'm running a second script and do the same select.
> But I don't want him to get the first 10 ids.
>
> The only thing I can think about is to lock WRITE my
o the same select.
But I don't want him to get the first 10 ids.
The only thing I can think about is to lock WRITE my table. I taught
innodb was able to automatically lock the selected rows and not allowed any
other script to get the same rows until it's commited...
Tks
--
329 (02000): No data - zero rows fetched, selected, or
processed
Ferindo
On 6/26/06, Dan Buettner <[EMAIL PROTECTED]> wrote:
Ferindo -
I believe there is a 64K limit on the length of a record in a MyISAM
table (text and binary columns excluded), but I haven't ever seen a
number o
hat
comes to
mind... It's failing because of some kind of constraint or threshold of the
db so instead of giving a meaningful messgae, it just says: ERROR 1329
(02000): No data - zero rows fetched, selected, or processed
Ferindo
On 6/23/06, Ferindo Middleton <[EMAIL PROTECTED]> wrote
threshold of the
db so instead of giving a meaningful messgae, it just says: ERROR 1329
(02000): No data - zero rows fetched, selected, or processed
Ferindo
On 6/23/06, Ferindo Middleton <[EMAIL PROTECTED]> wrote:
I guess my general reason for posting this was to ask: "Are there any
ses_id`
FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`),
CONSTRAINT
`fk_registration_title_id_must_always_match_title_salutations_id` FOREIGN
KEY (`title_salutation_id`) REFERENCES `title_salutations` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Do you know why this this one data record wo
Ferindo Middleton wrote:
I'm trying to load data into a table from a file but I get an error
message:
ERROR 1329 (02000): No data - zero rows fetched, selected, or processed
This error message isn't very specific as to what is going wrong and I have
no idea what it is about the data
I'm trying to load data into a table from a file but I get an error message:
ERROR 1329 (02000): No data - zero rows fetched, selected, or processed
This error message isn't very specific as to what is going wrong and I have
no idea what it is about the data file that is wrong. Of
This is quite odd. I have five .asp pages all using
the exact same connection code. For some reason, one
of the pages is getting a "No Database Selected"
error, yet the other four are not, which leads me to
believe my DSN config works fine. Below are the
details.
Getting the follo
Mathias wrote:
sorry if i wasn't clear. i mean not select puchase_date, but max(purchase_date),
i.e. use having clause.
The join field is certainly customerId, or There is not sufficient info on
tables.
Hope that helps
:o)
Mathias
How would you do that with HAVING?
I believe the subque
Selon Michael Stassen <[EMAIL PROTECTED]>:
> Mathias wrote:
>
> > Selon Russell Horn <[EMAIL PROTECTED]>:
> >
> >>This must have come up before, but I've not found it using a google
> >>search.
> >>
> >>I have two tables customer and purchases
> >>
> >>customer:
> >> customerID
> >> customerName
Mathias wrote:
Selon Russell Horn <[EMAIL PROTECTED]>:
This must have come up before, but I've not found it using a google
search.
I have two tables customer and purchases
customer:
customerID
customerName
purchases:
purchaseID
customerID
purchaseDate
purchaseValue
Is it possible in
Selon Russell Horn <[EMAIL PROTECTED]>:
> This must have come up before, but I've not found it using a google
> search.
>
> I have two tables customer and purchases
>
> customer:
> customerID
> customerName
>
> purchases:
> purchaseID
> customerID
> purchaseDate
> purchaseValue
>
> Is
This must have come up before, but I've not found it using a google
search.
I have two tables customer and purchases
customer:
customerID
customerName
purchases:
purchaseID
customerID
purchaseDate
purchaseValue
Is it possible in MySQL to join the tables so I only get the value of
t
How do I limit subqueries to 3 selects for each query selected, for
example, an operator put in 5 orders in each batch, and there are 2
different reports which is accuracy for all orders and 3 out of each 5
orders processed.
QA table holds batch information and Batch table holds all order
on 4/28/05 1:41 AM, Johan Höök at [EMAIL PROTECTED] wrote:
> Hi Scott,
> you can do:
> SELECT a, b, c, from table where zip IN (94949, 94945, 94947)
> ORDER BY FIELD(zip,94949, 94945, 94947)
That is too handy, thanks for the tip.
--
-
S
Hi Scott,
you can do:
SELECT a, b, c, from table where zip IN (94949, 94945, 94947)
ORDER BY FIELD(zip,94949, 94945, 94947)
/Johan
Scott Haneda wrote:
mysql 4.0.18-standard
I am running this select:
SELECT a, b, c, from table where zip IN (94949, 94945, 94947)
How can I get back a result set in the
mysql 4.0.18-standard
I am running this select:
SELECT a, b, c, from table where zip IN (94949, 94945, 94947)
How can I get back a result set in the order of the `IN` part of the
statement?
--
-
Scott Haneda
I was wondering what's the shortcut for executing only
selected text in the query window (SQL Query Area) in
MySQL Query Browser.
Using Ctr-E or Ctrl-Enter executes everything in the
window, not just the selected text, as MS Query
Analyzer does.
It's a great hassle to have to comme
You probably want to pick up a good SQL book. MySQL by Paul DuBois is
a really good one.
http://www.amazon.com/exec/obidos/tg/detail/-/0735712123/qid=1090786499/sr=8-2/ref=pd_ka_2/102-0741496-3072118?v=glance&s=books&n=507846
You want to use the WHERE clause of the select statement.
SELECT tabl
I have a recordset that retrieves the full content of the table - all
fields, all records. Depending upon the content of different fields in
different tables, I need to display certain fields of certain records
within the full recordset. What's the syntax for selecting a particular
record for displ
TECTED]>13/11/2003 11:35 AM
To: "Mysql List" <[EMAIL PROTECTED]>
cc: (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: RE: GRANT TO SELECTED COLUMNS
You can't login as testuser and try to give yourself privileges, it just
doesn't work.
Paul DuBois <[EMAIL PROTECTED]>13/11/2003 11:14 AM
To: BORNAY Richard/Engr/STATS/ST [EMAIL PROTECTED] Domain, [EMAIL PROTECTED]
cc:
Subject: RE: GRANT TO SELECTED COLUMNS
At 10:55 AM +0800 11/13/03, [EMAIL PROTECTED] wrote:
>Hi Chris/Lists,
>In fact, I was able to
the Select privilege FROM
mysql.tables_priv.Table_priv WHERE User='testuser' AND Host='%'
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 6:56 PM
To: [EMAIL PROTECTED]
Subject: RE: GRANT TO SELECTED COLUMNS
nly those two columns.
In that case, SELECT * should work. But my impression is that your
table has more than just the two columns.
"Chris" <[EMAIL PROTECTED]>13/11/2003 10:34 AM
To: "Mysql List" <[EMAIL PROTECTED]>
cc: (bcc: BORNAY Richard/Engr/S
the error Access denied for user
'testuser'
Thanks, Richard
"Chris" <[EMAIL PROTECTED]>13/11/2003 10:34 AM
To: "Mysql List" <[EMAIL PROTECTED]>
cc: (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: RE: GRANT TO SELECTED COLUMNS
That second query, byt itself, should have done it, were you logged in as
testuser when you tried to run it?
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 5:26 PM
To: [EMAIL PROTECTED]
Subject: GRANT TO SELECTED COLUMNS
Hello List,
I have a table named CHECK_SBIN with fields id,jobid,filename,sbin,count,
then I would like to create an account lets say testuser with SELECT
privileges only to a specific columns. In this case I would like to open
only id and jobid to 'testuser'.
I have already created an account t
utton and i want to
> be
> able to delete the ones selected. Is there a simple mysql command that
> could perform this? I can do all the html/form/php list things, but the
> mysql is out of my grasp. :-P
> If i was too confusing, maybe this helps: How can i delete the
records
>
be able to delete the ones selected. Is there a simple
mysql command that could perform this? I can do all the html/form/php
list things, but the mysql is out of my grasp. :-P
If i was too confusing, maybe this helps: How can i delete the
records whose "num" field is 4,78,34 and
Hi!
Pag wrote:
If i was too confusing, maybe this helps: How can i delete the
records whose "num" field is 4,78,34 and 23, all in one command?
Something along "delete * in 'table' where num=1 and num=13 and num=34"
etc.
"DELETE FROM table WHERE num=1 OR num=13 OR num=34"
or better:
http:/
Hi,
I am kinda new to this mysql thing, so please forgive the basic question.
What i need to do is, list my records on a table with a checkbox for each.
After we choose several of the records, we click a button and i want to be
able to delete the ones selected. Is there a simple mysql
Absolutely brilliant Roger this has sorted the problem out :)
Andrew
>-Original Message-
>From: Roger Baklund [mailto:[EMAIL PROTECTED]
>Sent: 04 March 2003 15:48
>To: MySQL-Lista
>Cc: [EMAIL PROTECTED]
>Subject: Re: Query selected
>
>
>* Andrew
>> Can an
* Andrew
> Can anyone tell me why this mysql query and 'selected' isn't
> working? It does keep a fixed id selected but not the one
> that was selected and aslo doesn't return any results?
Try to keep the html part of the problem separate from the mysql part
Can anyone tell me why this mysql query and 'selected' isn't working? It does
keep a fixed id selected but not the one that was selected and aslo doesn't
return any results?
echo "";
$result=mysql_query("SELECT City, CityID FROM city ORDER BY City");
Greetings
When I try to execute a query in SQLYOG( last query I have executed 2 Hours
before ), it is giving no database selected, evenif in databases combo box
the database is already selected. I am not understanding ? Does MySQL lose
the current DB status after a long time of idleness ?
Insane
: [EMAIL PROTECTED]
> Objet : selected records retrieve
>
>
> Hi to all.
> I'm new in the list and in mysql as well, so excuse me for anything that
> sounds novice or in wrong place.I'm facing the following situation:
>
> For some reason, i had to use a backup of the d
contains tables, and these tables may be SELECTED from. You
can also INSERT information into a table based on what you have SELECTed
from another table:
http://www.mysql.com/doc/I/N/INSERT_SELECT.html >
So, what you need is probably something like this:
INSERT INTO newdatabase.table1 S
Hi to all.
I'm new in the list and in mysql as well, so excuse me for anything that
sounds novice or in wrong place.I'm facing the following situation:
For some reason, i had to use a backup of the database.Because of the
difference in time between my backup and the instance i had to use it,i
-- Forwarded message --
Date: Tue, 2 Jul 2002 17:40:24 +0300 (EEST)
From: Nixarlidis Aris <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: selected records retrieve
Hi to all.
I'm new in the list and in mysql as well, so excuse me for anything that
sounds novice
Hi to all.
I'm new in the list and in mysql as well, so excuse me for anything that
sounds novice or in wrong place.I'm facing the following situation:
For some reason, i had to use a backup of the database.Because of the
difference in time between my backup and the instance i had to use it,i
w
; Currently I have about 4 records in a table that use to consume 800mb of space.
>(about 23kb per row). Now I'm compressing the column that stores the text as a blob
>with gzip compression. Now that table only uses 64mb of space. (about 1600 bytes per
>row)
>
> I'
Use the INSERT/SELECT combo like this:
INSERT INTO dba (field1,field2,...) SELECT fielda,fieldb,... FROM dba WHERE
...
> Hi there,
>
> I have some data in one table which I have to move to another. No I thought
> of a mysqldump with a where clause. The problem though is, that it also
> tryes t
Hi there,
I have some data in one table which I have to move to another. No I thought
of a mysqldump with a where clause. The problem though is, that it also
tryes to insert the ID which is a autoinc. primary key and already in use by
another record. How can I produce a insert statement withouth
Hi!
Id would like to have 4 tables
files (
id int(8),
type set("directory", "file", "link"),
)
files_directory (
id int(8),
is_files int(8),
name varchar(20)
...
)
files_file (
id int(8),
is_files int(8),
name varchar(20)
...
)
files_link (
id int(8),
is_files int(8),
name varchar(20)
...
)
Hi List,
I need to select a set of stuff from the database and then delete
exactly the same stuff. I've formed two query statements and I'm
tacking modifications to their ends to be consistent, but I'm not sure
if with a limit clause the database will delete the same set of co
Hi,
I got the solution for the replication of the selected db.
I typed only the database name in the replicate-do-db column.
And this line is followed by the data dir line.
Hope it is taking the path starting from the data dir column itself.
Thanks a lot for your response for this mail
Hi,
>
> Check the error, not in mysqld.log ..its in hostname.err
>
> Jai
>
> -Original Message-
> From: Charitha [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 29, 2002 9:52 AM
> To: Girish Nath
> Cc: [EMAIL PROTECTED]
> Subject: Replication of s
Hi,
Check the error, not in mysqld.log ..its in hostname.err
Jai
-Original Message-
From: Charitha [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 9:52 AM
To: Girish Nath
Cc: [EMAIL PROTECTED]
Subject: Replication of selected DB
Hi,
I have to replicate the selected
Hi,
I have to replicate the selected Database.
I have followed all the steps given in the manual page.
But i am not getting the result as i need.
There is no error message in the mysqld.log.
The message in the log file is "replication is started".
But the replication is not happenin
Errno: 1046
Error: No Database Selected
I get this on only one of my sites, on the first query during a
connection only, and actually it is an impossible error.
All sites are driven by db_mysql.inc from PHPLIB. Therefore,
everything is totally automatic, no chance to omit the database
name
Hello All,
is there any kind of row number pseudo-column that identifies a
particular row's position in the query's result set? Something like
RowNum in oracle.
Thanks!
-- john
--
===
John Cartwright
Professional Rese
Hello all,
I wonder if someone could send me a java code showing how to access a mysql
databse. I will appreciate very much, actually my job is counting on that.
Thanks in advance
Siomara
_
Get Your Private, Free E-mail f
On Fri, 20 Apr 2001, Siomara Pantarotto wrote:
> Date: Fri, 20 Apr 2001 19:35:52 -0300
> From: Siomara Pantarotto <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: ERROR 1046: No Database Selected
>
> Hi all,
>
> I am
Siomara Pantarotto ([EMAIL PROTECTED]) writes:
> Hi all,
>
> I am getting this error
>
> mysql> create table Product (
> -> productID numeric(10),
> -> name varchar(30),
> -> primary key(productID)
> -> );
> ERROR
Hi all,
I am getting this error
mysql> create table Product (
-> productID numeric(10),
-> name varchar(30),
-> primary key(productID)
-> );
ERROR 1046: No Database Selected
mysql>
How do I fix that
On Fri, Feb 16, 2001 at 10:56:57PM +0100, Benjamin Pflugmann wrote:
>
> > When you set up your database server so that it has enough RAM to
> > keep the whole database in main memory (buffer cache), random reads
> > don't need to wait for physical disk seeks and can be very fast.
> [...]
> > So m
Hi.
On Fri, Feb 16, 2001 at 09:42:02AM +0100, [EMAIL PROTECTED] wrote:
> Benjamin Pflugmann wrote :
[...]
> > "Second" is never the best way. MySQL uses "First" up to some
> > percentage of the amount of records (30% I believe), then uses
> > "Third", because reading the data in file order (unsor
Benjamin Pflugmann wrote :
>
> Hi.
> []
>
> If MySQL uses the index, it has one of two possibilities.
>
> First:
> 1. Read the whole isbn index, and for each row
> 2. seek the record in the data file and get author from it.
> This is quite slow because of the random file seeks needed.
>
>
Hi.
On Thu, Feb 15, 2001 at 03:53:39PM -0500, [EMAIL PROTECTED] wrote:
> 15/02/01 15:14, Quentin Bennett, [EMAIL PROTECTED]:
[...]
> > Adding the author to the query means that the query now has to go to the
> > data file to get the information, and since there is no restriction on isbn,
> > the
15/02/01 15:14, Quentin Bennett, [EMAIL PROTECTED]:
> Hi,
>
> I think you are mis-understanding the information provided. What the "using
> index" note means is that the isbn column is part of the index, and since
> that is all that is selected, the index file is used t
Hi,
I think you are mis-understanding the information provided. What the "using
index" note means is that the isbn column is part of the index, and since
that is all that is selected, the index file is used to provide the data,
the data file is not touched. Since there is (usually) le
Hi,
I'm having a hard time figuring why mySQL does not use the index when
sorting a table without any where clause when I include more than 1 field in
the select part. To resume the case, I created a temp table with 3 single
fields, added an index (see bottom for more details), ran 2 queries with
82 matches
Mail list logo