Gleb,
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,
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.**.***' is not allowed
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
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
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
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
mysql show
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
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;
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
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
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)
mysql
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
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
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 seems
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_Types
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
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
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
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
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
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
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
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)
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
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 seen as
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
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
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
relation between
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
afan,
snip 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 prices
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 seen as
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
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 explain
-
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
[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
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
CREATE
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 have
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
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 an
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
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 drag
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
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
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
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
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
[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
[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
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:
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
Im 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?
Do you have any log messages associated with it?
(not sure for win / os x for linux look in /var/lib/mysql/hostname.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.
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
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
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
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
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,
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
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
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
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.
For
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
62 matches
Mail list logo