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.
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 deny
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
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
|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
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:
About
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
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
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
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 engine
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
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
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 General
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,
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
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.
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
- 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 ENTER} */
[EMAIL
[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 |
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
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
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,
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]: ***
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.
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
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
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 !!!
Hi
pFlies in pot = ?=flies();? /p
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
[snip]
pFlies in pot = ?=flies();? /p
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
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
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/mysqld_safe
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
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_actions
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
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 has
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 that
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]
[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
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
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
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 date,
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.com
From:
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 ?
thinking
count() is said to
[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,
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
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
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
relationship on
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 procedure debugger --
Hi
code snippet
select max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as nf4 from
table
/code
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
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:
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 is
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
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
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 with up
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
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
56 matches
Mail list logo
