> First of all, is there any way of limiting the number of rows in a
> table, referencing to the same element of another table? For example,
> force a manager not to have more than 10 employees under his control.
> In a way this can be seen as checking the multiplicity of the
>
Hi David.
Logan, David (SST - Adelaide) wrote:
Hi Luke,
Yep, there is a procedure in the manual
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html here.
This has all the steps you will need to get root back.
Hope it all ends up ok!
That went well (resetting the root passw
Brian
>I'm in the midst of the age-old problem of finding the right SQL to
>make a Dealer Locator by ZIP code. Like Steffan's posts from a
>couple weeks ago, I have the ZIP code data in one table with
>latitudes and longitudes, and the table of Dealers with ZIP codes
>in a separate table.
Fo
Hi Luke,
Yep, there is a procedure in the manual
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html here.
This has all the steps you will need to get root back.
Hope it all ends up ok!
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Hi David.
Thanks for your help.
Logan, David (SST - Adelaide) wrote:
Hi Luke,
Have you tried doing another GRANT statement to ensure the name and
password are indeed correct? That would be my next step. That way at
least you are sure that the name/password combination are correct.
I can't
I'm in the midst of the age-old problem of finding the right SQL to
make a Dealer Locator by ZIP code. Like Steffan's posts from a couple
weeks ago, I have the ZIP code data in one table with latitudes and
longitudes, and the table of Dealers with ZIP codes in a separate table.
While resear
Hi Luke,
Have you tried doing another GRANT statement to ensure the name and
password are indeed correct? That would be my next step. That way at
least you are sure that the name/password combination are correct.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Ad
Hi David.
Logan, David (SST - Adelaide) wrote:
Hi Luke,
According to the log
051019 19:46:20 mysqld started
051019 19:46:20 InnoDB: Started
/myProgs/mysql/libexec/mysqld: ready for connections.
Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306
mysqld is sitting there fat, dumb a
Hi Luke,
According to the log
051019 19:46:20 mysqld started
051019 19:46:20 InnoDB: Started
/myProgs/mysql/libexec/mysqld: ready for connections.
Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306
mysqld is sitting there fat, dumb and happy waiting for somebody to talk
to it at eith
Hi.
Logan, David (SST - Adelaide) wrote:
Do you have any sample of error output? This would be useful.
I think the problem started where I have inserted the lines.
Thanks.
/
=
050914 04:44:49 mysqld r
Do you have any sample of error output? This would be useful.
Thanks
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Luke Vanderfluit [mailto:
Do you have any log messages associated with it?
(not sure for win / os x for linux look in /var/lib/mysql/.err)
Hi.
For clarity, I'm running mysql 4.0.20
And I did start the mysql daemon.
Luke Vanderfluit wrote:
Hi.
I have a database that is used with wordpress blogging software.
Yesterda
I"m a little confused by the query you posted.. it looks like it would
work, although with many redundant subqueries to get there. From your
requirement, I don't understand why you needs to wrap it in a self-
referencing subquery..
Why does this not give you the same logical value?
selec
Hi.
For clarity, I'm running mysql 4.0.20
And I did start the mysql daemon.
Luke Vanderfluit wrote:
Hi.
I have a database that is used with wordpress blogging software.
Yesterday the server that it's running on reset itself.
Since then I can't access the database.
What could be going on here
Hi.
I have a database that is used with wordpress blogging software.
Yesterday the server that it's running on reset itself.
Since then I can't access the database.
What could be going on here?
Any ideas?
Thanks.
Kind regards.
--
Luke
--
MySQL General Mailing List
For list archives: http://li
[posted only]
On Oct 19, 2005, at 3:48 PM, sheeri kritzer wrote:
One particular bit of SQL you may find helpful is this:
concat(ifnull(a_id,""),ifnull(a_text,""))
concat with anything and a null value will produce a null value. That
snippet of sql code will help you get one answer from the 2
[posted only]
On Oct 19, 2005, at 4:07 PM, Jon Frisby wrote:
Create an Excel spreadsheet. Import the raw data, structured as-is,
into a worksheet. Select all the relevant columns. Go to Data ->
"Pivot Table and Pivot Chart Report". Click "Finish". From the
"PivotTable Field List", drag the
Unfortunately, I cannot create indexes for these tables. These are on
production and I cannot modify the tables in anyway.
Also, none of the columns are unique in nature - they just serve as a
reporting store.
Is there anyway that I can tune the select query itself and hope some
performance enhanc
On Wed, 2005-10-19 at 17:39 -0400, Anoop kumar V wrote:
> I have 2 tables used for reporting and there are no primary keys or
> indexes for either. I am trying to run a select query to identify some
> rows that need to be removed. But for around 100,000 rows the query is
> taking too long. Can some
hi All,
I have 2 tables used for reporting and there are no primary keys or
indexes for either. I am trying to run a select query to identify some
rows that need to be removed. But for around 100,000 rows the query is
taking too long. Can somebody please help me in tuning this query?
The 2 tables
Jeff Smelser wrote:
I would highly suspect this is a bug.. I would submit one.. unless someone
else knows better..
Not real sure why you really need delayed, archive is suppose to be much
faster on inserts then even myisam.
Jeff
Thanks Jeff!
It's the way our code is written, and I just
On 19 Oct 2005, at 20:30, Jochem van Dieten wrote:
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
First of all, is there any way of limiting the number of rows in a
table, referencing to the same element of another table? For
example,
force a manager not to have more than 10 empl
Create an Excel spreadsheet. Import the raw data, structured as-is,
into a worksheet. Select all the relevant columns. Go to Data ->
"Pivot Table and Pivot Chart Report". Click "Finish". From the
"PivotTable Field List", drag the respondant ID into the box labeled
"Drop Row Fields Here", then
You want a Pivot Table. Excel will do this nicely (assuming you have
65536 rows or less), but SQL does not provide a mechanism to do this.
If you want a web based interface you can look at Jtable. (I *think*
that's what it's called -- it's a Java web app that provides an HTML
pivot table interfac
I agree with Brent.
One particular bit of SQL you may find helpful is this:
concat(ifnull(a_id,""),ifnull(a_text,""))
concat with anything and a null value will produce a null value. That
snippet of sql code will help you get one answer from the 2 the
original database had. Unless there's ever
Jeff Smelser wrote:
On Wednesday 19 October 2005 01:18 pm, Mihail Manolov wrote:
Apparently ARCHIVE tables do not support INSERT DELAYED. Why?
In documentation
(http://dev.mysql.com/doc/refman/4.1/en/archive-storage-engine.html) it
says that it should be possible.
Example of the error that I
Hello.
> what do you really mean? I cannot have different symbols (hebrew,thai,
> cyrillic) in same table!? I wouldn't say so. This project started when
We have a lots of changes in MySQL 4.1. These are include the different
character set support. In MySQL 4.1 during the work data might hav
Hello.
> If a value doesn't fit (in the "domain" of "tinyint"), an exception
> should be raised. Plain and simple.
MySQL 5.0 has this ability. Check STRICT_ALL_TABLES and
STRICT_TRANS_TABLES SQL modes at:
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
>>
[mailed and posted]
On Oct 19, 2005, at 3:34 PM, Brent Baisley wrote:
The person you inherited from formatted the data correctly in my
opinion.
I agree.
What you are trying to do is store the data as you see it, which is
rarely a normalized data model. Your presentation layer should
han
The person you inherited from formatted the data correctly in my
opinion. With the existing format, you can index all the data with a
minimum number of indexes and quickly compile results. It can scale
to any number of questions without having to modify the underlying
data structure. It can
On Wednesday 19 October 2005 01:15 pm, Olaf Faaland wrote:
> The queries in question are:
>
> This query uses the index:
> mysql> explain
> -> select itran_log_date, itran_log_actionid from itran_log where
> -> itran_log_actionid = "170807";
>
> This query performs a table scan:
> mysql> ex
I don't think you have a clear enough mental picture of what your
different pricing structures are. You describe:
a) fundamental unit price
b) price breaks due to volume discounts
c) price breaks due to coupons
d) price increases based on options. Options include: embroidered logo,
screened logo
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>
First of all, is there any way of limiting the number of rows in a
table, referencing to the same element of another table? For example,
force a manager not to have more than 10 employees under his control.
In a way this c
afan,
> But, Peter's 2nd part is actually "touching" the change in the
project:
>product can have more then 2 prices. E.g. if you select shirt with your
>logo embroidered - it's one price. If your logo will be screened on the
>shirt - other price. And then if the shirt is on sale - 2 more price
I suspect that this is the wrong list for this kind of question, but
if someone could point me to appropriate sources, I would very much
appreciate it.
I am new to SQL but inherited project designed by someone who doesn't
seem answer his email anymore.
Essentially date were collected on t
> >> First of all, is there any way of limiting the number of rows in a
> >> table, referencing to the same element of another table? For example,
> >> force a manager not to have more than 10 employees under his control.
> >> In a way this can be seen as checking the multiplicity of the
> >> rela
No. It doesn't work. First, I found one error: there are two columns for
same thing in ac_products ac_products_product_id and product_id.
Second, ac_extended_prices table doesn't fit with multiple solutions
:(
[EMAIL PROTECTED] wrote:
Thanks guys for really detailed answers.
After your em
Hi,
I am currently using mysql 4.0.18 as distributed with red hat Linux. I find
when I perform a select on a varchar(30) field, the index is used only if I
have quoted the value in the where clause. Otherwise, mysql performs a
table scan.
The queries in question are:
This query uses the index:
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>>
>> First of all, is there any way of limiting the number of rows in a
>> table, referencing to the same element of another table? For example,
>> force a manager not to have more than 10 employees under his control.
>> In a way this can be s
Apparently ARCHIVE tables do not support INSERT DELAYED. Why?
In documentation
(http://dev.mysql.com/doc/refman/4.1/en/archive-storage-engine.html) it
says that it should be possible.
Example of the error that I am getting:
INSERT DELAYED INTO audit_log VALUES
('db','user','549220','address
Thanks guys for really detailed answers.
After your emails I talked to project supervisor and found that there is
"some changes" in the project:
(i) do you know in advance all the kinds of price extensions that can
come up?
- I hope I know them now :(
(ii) do you want the price rules to be (a
On 19 Oct 2005, at 15:58, Martijn Tonies wrote:
Second, is there any way of getting more details out of an error
message? So for example, when doing a bulk upload to the database,
rather than just getting "Cannot add or update a child row: a foreign
key constraint fails" I would like to know
Hi list,
I've got a query coming out of sugarCRM that is generating this error:
MySQL error 1267: Illegal mix of collations
(latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for
operation 'UNION'
I recently converted the entire database to utf8 - made sure all the
connections are utf8
How you redefined your project definitely makes your goal much easier to
reach.
As I see it, most of what you need to do is related to figuring out how
to create disk-cached VIEWs and how to invalidate the cache whenever any
of the VIEW's underlying data has changed. This does not necessarily
Thanks for the clarification and comments. I should reiterate that
for our project, we do *not* need to actually implement materialized
views, but only suggest refactoring and/or new components required to
implement them. I think implementing it would too time consuming for
a group of three stude
Hi Shaun,
I don't have a 3.23 installation to test it on just now. If Brent's
suggestion fails, try changing the join pattern to
tb INNER JOIN p INNER JOIN pt (if you can't beat it, join it :-) ).
PB
-
Shaun wrote:
Hi Peter,
I am using version 3.23.54, unfortunately I have no contr
> As part of my 4th Year Group Design Project, I am required to build a
> database system that will validate and then store the data. As such I
> am currently investigating different DB, to choose the most suitable
> one. I like many features of MySQL but there are a couple of things I
> am not
As part of my 4th Year Group Design Project, I am required to build a
database system that will validate and then store the data. As such I
am currently investigating different DB, to choose the most suitable
one. I like many features of MySQL but there are a couple of things I
am not very
It looks like MySQL is interpreting your "short form" join syntax a
different way than you expect. Try using the "long form" by
specifying which tables and fields you want to join.
SELECT ...
FROM Properties P
INNER JOIN Tax_Bands ON P.Tax_Band_ID=Tax_Bands.Tax_Band_ID
INNER JOIN Property_Typ
Hi Peter,
I am using version 3.23.54, unfortunately I have no control over this :(
"Peter Brawley" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Shaun,
>I am having problems with the following query: I am
>trying to join Tax_Bands and Property_Types to Properties
>but the query s
Shaun,
>I am having problems with the following query: I am
>trying to join Tax_Bands and Property_Types to Properties
>but the query seems to be joning Tax_Bands to Properties.
That query generates no error in 5.0.13. There have been several
cascading join bugs, some fixed, some not. What
Just like Jigal, I also had to lookup the term "materialized view". For
the sake of others on the list trying to follow along: a materialized view
is basically a self-updating snapshot of a table (or tables) usually
containing some sort of intermediate statistical computations involving
GROUP B
> > As a sidenote - shouldn't MySQL raise an error when data gets
>truncated?
>
> MySQL raises a warning after such ALTER operation. See:
>
> mysql> create table dt(a decimal(4,1));
> Query OK, 0 rows affected (0.01 sec)
>
> mysql> insert into dt set a=999.1;
> Query OK, 1 row affected (0.00 sec)
Hi,
I am having problems with the following query: I am trying to join Tax_Bands
and Property_Types to Properties but the query seems to be joning Tax_Bands
to Properties.
SELECT P.*,
Tax_Band,
Property_Type
FROM Properties P
INNER JOIN Tax_Bands USING(Tax_Band_ID)
INNER JOIN Property_Types USI
Martijn Tonies wrote:
| Warning | 1264 | Out of range value adjusted for column 'a' at row 1
Could be me ... but isn't this a little too late?
eg: AFTER you have lost your data?
IMO, it should raise an error UNLESS you force it to truncate the data.
This would contradict the "MySQL design phil
> mysql> insert into dt set a=999.1;
> >> Query OK, 1 row affected (0.00 sec)
> >>
> mysql> alter table dt change a a decimal(2,1);
> >> Query OK, 1 row affected, 1 warning (0.02 sec)
> >> Records: 1 Duplicates: 0 Warnings: 1
> >>
> mysql> show warnings;
> >>
+-+--+--
Gleb Paharenko wrote:
Hello.
Are you sure that you have the same problem (the same character set
settings, same broken cyrillic characters and so on)? If not, please,
provide as much info as you can. Delyan was using cyrillic symbols with
latin1 encoding, which is not designed for this purpos
In article <[EMAIL PROTECTED]>,
"Martijn Tonies" <[EMAIL PROTECTED]> writes:
mysql> insert into dt set a=999.1;
>> Query OK, 1 row affected (0.00 sec)
>>
mysql> alter table dt change a a decimal(2,1);
>> Query OK, 1 row affected, 1 warning (0.02 sec)
>> Records: 1 Duplicates: 0 Warnings: 1
>>
Andrew Roth wrote:
Hi all,
We are a group of three students in Professor Ric. Holt's Software
Architecture class at the University of Waterloo. As our project, we
would like to examine the MySQL source to determine the best way to
implement materlialized views.
It would be wise to hang around
Dear sir
Thank you for your answer. You help me much.
I replace msjet40.dll with an oldest from ServicePackFiles/ and works fine
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 18, 2005 7:12 PM
To: mysql@lists.mysql.com
Subject: Fw: Access 2002
zhou bin wrote:
hi,
mysql is a very goode software,so i made mysql_3.23_58 and mysql_4.1
in two of my server, and i changed the root password, but why i can't
connect to the mysql server from a client pc(use mysqlcc or any other
tools)?
the error message is:
[206] ERROR 1130: Host '218.4.**.***
61 matches
Mail list logo
