Yes you are right it works... but if the documentation is wrong I will be
wrong in the following also...
Majority of SET statements are documented without quotes:
AUTOCOMMIT = {0 | 1}
BIG_TABLES = {0 | 1}
FOREIGN_KEY_CHECKS = {0 | 1}
IDENTITY = value
INSERT_ID = value
LAST_INSERT_ID = value
SQL_AU
patrick wrote:
I'm wondering if there's any way to force updates on InnoDB tables to
require an explicit COMMIT when running queries from the mysql
command-line client (similar to Oracle's command line client)?
set autocommit = 0
See
http://dev.mysql.com/doc/refman/5.0/en/innodb-and-autocommit
eth1 <[EMAIL PROTECTED]> wrote on 03/28/2006 03:04:13 PM:
>
> Hi All,
>
> I'm migrating to a contact relationship management system (CRM) for
one of
> my clients from a proprietary Access database. The CRM system can
import
> our donor's contact history, but only in a non-normalized format
Hello:
If I use Multiple-Master Replication with two mysql server, when one of them
goes down(disk crashed) must I shutdown the good one to recover the
Multiple-Master Replication ?
regards,
gu lei
hi Dhandapani,
The 3306 port is not listening. But there are some connection whose state is
FIN_WAIT_2 as you can see in my first letter.
After about 10 minutes I shutdowned mysql, I restarted mysql as root using:
/usr/local/mysql/bin/mysqld_safe &. It worked.
Before it, I did this as mysql and
Hi,
I am using mysqlcc 0.9.4-beta to browse my DB.
Server side am using 5.0.18-nt.
However, when I try to double click on a table to see the data, it will
always
return the error.
"[localhost] ERROR 1146: Table 'test.1' doesn't exist"
The SQL query for this is
"SELECT * FROM `test`"
The query i
I'm wondering if there's any way to force updates on InnoDB tables to
require an explicit COMMIT when running queries from the mysql
command-line client (similar to Oracle's command line client)?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
Hi
select max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as nf4 from
table
How can I extract a max value from the 4 columns of the result ?
ex: greatest(nf1,nf2,nf3,nf4)
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
On Tuesday, 28 March 2006 at 8:29:08 +0200, Martijn Tonies wrote:
> Hello Nick,
>
>>> Upscene Productions is proud to announce the next
>>> version of the popular database development tool:
>>>
>>> Database Workbench 2.8.5 has been released today!
>>
>>
>> I'd like to hear more about the stored pr
On Tuesday, 28 March 2006 at 10:09:16 +0200, Martijn Tonies wrote:
> Hello Taco,
>
>> I previously tried this same question on the GUI tool list, but not much
>> traffic there, so I thought I'd give it a go here.
>> I've been reading some articles that suggest I should be able to create a
>> relati
Sheeri,
- Original Message -
From: ""sheeri kritzer"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 28, 2006 9:29 PM
Subject: problems/feature request ideas
2 weeks ago we had a server crashing, and while I was checking it out
(before, during and after
Marten,
I replied today to your earlier email with the message pasted below.
Regards,
Heikki
Marten,
can you email the complete .err log from the server to
[EMAIL PROTECTED]
I am interested in what caused the very first crash in the server. Now your
database seems to be seriously c
[snip]
I think that the fastest method and the cheapest one is using "select
count(*) from table" and using mysql_num_rows(), isn't it ? but there
realy
is no other way of retrieving the count() directly, without passing by
the
php function ?
[/snip]
Actually, SELECT COUNT only returns one row,
Hi Jay
I just tried your code but I used $foo=mysql_fetch_object($result) and
returned $foo->flyCount. It works the same as your code. (I actually have
738 flies in my pot, it's a crowd, and a lot of proteins !!! ;-) ). What
method is heavier on the MySQL engine ?
count() is said to be the f
On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
> To: mysql@lists.mysql.com
> From: Jorrit Kronjee <[EMAIL PROTECTED]>
> Subject: Re: Random 'select permission denied' since upgrade to 5.0.18
>
> [EMAIL PROTECTED] wrote:
> > On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
> >
> > > To: mysql@lists.mysql.c
fbsd_user said:
> create table members (
> logon_idvarchar(15) NOT NULL,
> email_addr varchar(30) NOT NULL,
> member_type char(1),
> email_verified char(1),
> logon_pwvarchar(15),
> date_added dat
create table members (
logon_idvarchar(15) NOT NULL,
email_addr varchar(30) NOT NULL,
member_type char(1),
email_verified char(1),
logon_pwvarchar(15),
date_added date,
last_login
is your access control by hostname or IPnumber? if hostname you could
be having transient DNS issues - where the IPnumber on the client
connect can't be resolved into the permitted hostname (fast enough).
try using IPnumber in the access control and see if the problem goes
away - if it does you'
[EMAIL PROTECTED] wrote:
On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
To: mysql@lists.mysql.com
From: Jorrit Kronjee <[EMAIL PROTECTED]>
Subject: Re: Random 'select permission denied' since upgrade to 5.0.18
snip
Could this message appear when, for instance, a maximum amount of threads
has been
thanks
Because $result is a resource in PHP, not the actual result of the
query;
$foo = mysql_num_rows($result);
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Brian,
>Let's say a member completes action 'abc'. We want to query the
>member_actions table for all members that have also completed action 'abc'.
>We then want to determine what the top 3 other actions are that were
>completed by members who have completed action 'abc', while making sure tha
On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
> To: mysql@lists.mysql.com
> From: Jorrit Kronjee <[EMAIL PROTECTED]>
> Subject: Re: Random 'select permission denied' since upgrade to 5.0.18
snip
> Could this message appear when, for instance, a maximum amount of threads
> has been spawned or MySQL h
Sandy,
>$result = mysql_query($sql,$lnk);
>...
>Why this leads to 'ressource id #10' instead of the flies count ?
>The query gives the actual count if I use it in a line command !!
You've been fooled by your variable name. For SELECT, SHOW, DESCRIBE or
EXPLAIN, mysql_query() returns a resource
On Tue, 28 Mar 2006, Brian Erickson wrote:
> To: mysql@lists.mysql.com
> From: Brian Erickson <[EMAIL PROTECTED]>
> Subject: Customer Recommendation Query
snip
> We are using MySQL version 3.23. There are approximately
> 500 unique rows in the 'actions' table and 2,000,000 rows
> in the member_
Keith,
Thanks for answering me.
Yes I did. Nothing in the MySQL log either. Keep in mind that these
errors only sometimes show up and usually in the middle of a few queries
in a row (while permissions are set for the whole table). Because the
script runs fine most of the time, I don't think p
On Tue, 28 Mar 2006, Áquila Chaves wrote:
> To: mysql@lists.mysql.com
> From: Áquila Chaves <[EMAIL PROTECTED]>
> Subject: error: 'Can't connect to local MySQL server through socket
> '/tmp/mysql.sock'
>
> - When I execute the command "mysqld_safe":
>[EMAIL PROTECTED] mysql]# bin/mysql
Hi All,
I'm migrating to a contact relationship management system (CRM) for one of
my clients from a proprietary Access database. The CRM system can import
our donor's contact history, but only in a non-normalized format with up to
10 donations per contact record in a single row of an Excel sp
[snip]
Flies in pot =
function flies(){
$sql = 'select count(*) from flies';
$lnk = mysql_connect('localhost','root','123456');
$db = mysql_select_db('moar',$lnk);
$result = mysql_query($sql,$lnk);
mysql_free_result($result);
mysql_close($lnk);
return $result;
}
Why this leads to 'resource id #
Hi
Flies in pot =
function flies(){
$sql = 'select count(*) from flies';
$lnk = mysql_connect('localhost','root','123456');
$db = mysql_select_db('moar',$lnk);
$result = mysql_query($sql,$lnk);
mysql_free_result($result);
mysql_close($lnk);
return $result;
}
Why this leads to 'ressource id
On 2006-03-20, at 16:12, Gabriel PREDA wrote:
One must issue immediately after connection:
SET NAMES 'utf8'
Also look at:
SHOW VARIABLES LIKE 'collation_%';
SHOW VARIABLES LIKE 'character_set_%';
Server must know what you are assking for... and they ALL have to
"talk the
same language" !!
2 weeks ago we had a server crashing, and while I was checking it out
(before, during and after crashes) I noticed that after a crash, the
server was slow. Threads would run for 200 seconds or more, and yet
when they finished, nothing was written to the slow query log.
Why would that be? Slow qu
We are looking for some help with queries that will accomplish a similar
feature to what Amazon does. When you purchase a product, Amazon looks at
all other people who have purchased that product, and then looks at all of
the OTHER products those people have purchased, and uses that data to
suggest
On 2006-03-20, at 12:11, Pooly wrote:
2006/3/19, Adam i Agnieszka Gąsiorowski FNORD <[EMAIL PROTECTED]>:
On 2006-03-18, at 00:59, Yani Copas wrote:
Is there a quick and dirty way to update such that I can only
affect the portion
of a string (varchar column) that matches a regexp?
(e.g. rep
On Tue, Mar 28, 2006 at 10:12:58AM +0200, Sander Smeenk wrote:
> Hello!
>
> I have a dual Opteron 250 system with 4GB memory running Debian with
> MySQL version 5.0.18 and unfortunately it keeps crashing at (somewhat)
> random intervals with messages like:
>
> | Mar 14 00:32:59 zwart mysqld[29820
Hello,
I'm getting this in my errorlog:
060328 18:43:45 mysqld ended
060328 18:43:46 mysqld started
060328 18:43:46 InnoDB: Operating system error number 2 in a file
operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember
Does anyone know how to get FULLTEXT indexing not to treat hyphens as
word breaks?
Basically I am searching part numbers and descriptions and need
something like Z-5500 to be returned.
I want to keep using FT for the scoring. I lowered the min word length
to 2. I am thinking I could lower it
Good day!
Can you be more concrete? I believe nobody in this list can read your
thoughts.
What tells mysql? What do you see in logs?
prathima rao wrote:
i have a hp server . i have installed mysql 4 in that when ever i shut down
the system and start again the mysql server does not start it sa
[EMAIL PROTECTED] schrieb:
after changing my system timezone from UTC to MSD i have the following
problem: after restarting mysql server its timezone has not changet at
all:
mysql> show variables like '%zone%';
+--++
| Variable_name| Value |
+--+--
- When I execute the command "mysqld_safe":
[EMAIL PROTECTED] mysql]# bin/mysqld_safe --user=mysql &
[1] 7298
[EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from
/var/lib/mysql
/* {processing... the cursor is blinking but I don't have any answer... So,
I press } */
[EMAIL PROTEC
Hello list,
Recently we upgraded from 3.23.3 to 5.0.18 and started noticing some
weird behaviour. We have update scripts running on a regular interval
and some of these scripts randomily exited with MySQL error:
SELECT command denied to user 'user'@'host' for table 'example'
However, this error
At 9:38 -0500 3/28/06, Dave Juntgen wrote:
Hello All,
Indiana will move to EDT on April 2nd. I am concerned with MySQL
DATETIME stamps that I have stored in my systems and whether or not
I need to restart each MySQL daemon to ensure that it reads the
correct system time and zone info.
DATE
after changing my system timezone from UTC to MSD i have the following
problem: after restarting mysql server its timezone has not changet at
all:
mysql> show variables like '%zone%';
+--++
| Variable_name| Value |
+--++
| system_time_zone | UTC
Hello All,
Indiana will move to EDT on April 2nd. I am concerned with MySQL DATETIME
stamps that I have stored in my systems and whether or not I need to restart
each MySQL daemon to ensure that it reads the correct system time and zone info.
Your help is greatly appreciated.
Regards,
--Dave
On 3/28/06, Peter Brawley <[EMAIL PROTECTED]> wrote:
> >I require something along the lines of this:
>
> >CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE
>
> CREATE TABLE tblname ENGINE=archive SELECT * FROM request_log;
>
> PB
Excellent. Exactly what I need. Thanks :-)
--
MySQL Gene
Thank you Dilipkumar... boy did I learn my lesson. The one good thing about
this is that the database was at the end of the testing stage, so I didn't
lose critical customer data. I could have gotten a backup copy of the data
files from our server backups, but at this point that would have been m
Terry
I require something along the lines of this:
CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE
CREATE TABLE tblname ENGINE=archive SELECT * FROM request_log;
PB
-
Terry Burton wrote:
Hi,
I'm using MySQL 4.11. Is it possible to use the CREATE TABLE x AS
syntax along
On 3/28/06, Pure Web Solution <[EMAIL PROTECTED]> wrote:
> I dont think that it is possible to specify the engine when creating a table
> this way, you could however create the table using the:
>
> CREATE TABLE old AS SELECT * FROM request_log
>
> and then issue an alter table command setting the e
I dont think that it is possible to specify the engine when creating a table
this way, you could however create the table using the:
CREATE TABLE old AS SELECT * FROM request_log
and then issue an alter table command setting the engine to whatever you like.
Pure Web Solution
http://www.purewebso
Hi,
I'm using MySQL 4.11. Is it possible to use the CREATE TABLE x AS
syntax alongside the ENGINE = x pragma, since this would make
archiving of tables very simple.
I require something along the lines of this:
CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE
If this cannot be done t
i have a hp server . i have installed mysql 4 in that when ever i shut down
the system and start again the mysql server does not start it says its an
error when i try to reconfigure it service started will be disabled can
anyone help me out
- Original Message -
From: "leo huang" <[EMAIL
try something like this
select customer,max(time),name
from customers join projects on projects.parent_id=customer.id
group by customer;
regards
Pure Web Solution
http://www.purewebsolution.co.uk
PHP, MYSQL, Web Design & Web Services
Barry <[EMAIL PROTECTED]> wrote:
> Gabriel PREDA wrote:
> >
|06|03 |My small Project|2005-02-10|
|07|03 |My big Project! |2005-06-11|
Small mistake. The project with ID 06 should have a date above ID 07.
Sorry for that!
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For li
Hello!
I have a dual Opteron 250 system with 4GB memory running Debian with
MySQL version 5.0.18 and unfortunately it keeps crashing at (somewhat)
random intervals with messages like:
| Mar 14 00:32:59 zwart mysqld[29820]: *** glibc detected *** double
| free or corruption (!prev)
Gabriel PREDA wrote:
About the first problem I think you need to give us more data !
Okay i thought yesterday how i can make up some real problem and have this:
Guess you have a database with customers and a database with projects.
Those prijects have timestamps so you know what time he added
Hello Taco,
> I previously tried this same question on the GUI tool list, but not much
> traffic there, so I thought I'd give it a go here.
> I've been reading some articles that suggest I should be able to create a
> relationship on a MyISAM table, it would be great if someone could confirm
> or
HI,
I previously tried this same question on the GUI tool list, but not much
traffic there, so I thought I'd give it a go here.
I've been reading some articles that suggest I should be able to create a
relationship on a MyISAM table, it would be great if someone could confirm
or deny this.
--
56 matches
Mail list logo