Hello.
Chris, the collation is subordinated to the character set. You should
work with the character sets, and only after with collations. The data
which you store in your table is silently converted to ascii character
set. Are you sure that the characters which you want to store are
present in
Hello.
set @s:=0;
select Division, Units, Year from (select v1.Division, [EMAIL PROTECTED] as
Units, v1.Year, @s:=v1.Units from veer v1) as v2;
Veerabhadrarao Narra wrote:
i have to write one query
DivisionUnitsYear
ameerpet 200 2004
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/program-options.html
I agree, some times it takes some time find the configuration file.
show variables like '%dir%' should help you.
[EMAIL PROTECTED] wrote:
Dear Friends,
I need to start mysql with --old-passwords but i did not know how
Hi Gleb Paharenko,
ThanQ for assistance
--
veerabhadrarao narra,
+91-988-556-5556
I-ONE TECH LABS Pvt Ltd.
HYDERABAD, INDIA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Gleb Paharenko ,
Thanks for replying to the email.
Actually i have done locate my.cnf and cannot find he file.
I am sure this file do not exist on mine VPS.
I wanted to know that is it OK to add an entry into /etc/rc.d/rc.local as
/usr/local/mysql/bin/mysqld_safe .
Also now i cannot write
Hi Gleb,
i finally found out a method to be entirely independent from any
character-set as well as collation-sequence problem, when forming a
UNION, where you occasionnally have to insert place-holders in one of
the SELECT statements:
as (text, varchar, char) placeholders use NULL instead of
i have to write one query
DivisionUnitsYear
a 200 2004
a 300 2005
b 500 2004
b 800 2005
b 900 2006
c
i have to write one query
DivisionUnitsYear
a 200 2004
a 300 2005
b 500 2004
b 800 2005
b 900 2006
c
Hello,
I upgraded MySQL from 4.1 to 5.0 on my machine (MDK 2006). Since I can't
connect, I always get:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
(or using password:YES)
I followed the reset password procedure. If the server is started with
Thank you Gleb,
I'm afraid I'm in over my head on this subject as I am restricted to make db
changes via sql or phpmyadmin.It seem from your references the database
character_set needs to be set to latin? I'm speculating to change
character_sets and collations I need access to other utilites,
I think this is what you want to do:
SELECT t1.Division,t1.year, t1.units this_year_units, t2.units
last_year_units, case when t2.units is null then t1.units else
(t1.units-t2.units) end as Difference_Units
FROM `narra_table` t1 left join narra_table t2
on (t1.Division=t2.Division) and
Is it normal for MySQL to not update fields that are already identical?
I am talking about an INNER JOIN UPDATE, when copying from table A over
table B.
My count did not match at the first run and when I did the second run, I
go a zero rows updated...
--
MySQL General Mailing List
For list
Hello.
If you set a column to the value it currently has, MySQL notices this
and does not update it. Perhaps it is the answer on your question. See:
http://dev.mysql.com/doc/refman/5.0/en/update.html
Nicolas Verhaeghe wrote:
Is it normal for MySQL to not update fields that are already
Hello.
I wanted to know that is it OK to add an entry into /etc/rc.d/rc.local
as /usr/local/mysql/bin/mysqld_safe .
I've seen the systems where mysqld is started in a similar way. However,
I usually prefer to work with properly configured mysql.server script
(due its ability to do restart of
Hello.
Are you able to connect to MySQL Server if you blank the root password?
Use mysql command line client from 5.0 distribution. Have you run
mysql_fix_privilege_tables script? Please, provide the CREATE statement
for mysql.user table.See:
Hi all.
I am having some troubles with what should be contained within my
my.cnf file. Would a few of you be willing to show me what yours
consists of?
Thanks,
~Philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I have two tables, registration schedules, that look like this:
CREATE TABLE registration (
idSERIAL NOT NULL UNIQUE,
firstnameVARCHAR(256) NOT NULL,
middlenameTEXT,
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables, registration schedules, that look like this:
CREATE TABLE registration (
idSERIAL NOT NULL UNIQUE,
firstnameVARCHAR(256) NOT NULL,
Paul DuBois wrote:
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables, registration schedules, that look like this:
CREATE TABLE registration (
idSERIAL NOT NULL UNIQUE,
firstnameVARCHAR(256) NOT
I'm doing load data a few times a day via cron and using this:
LOAD DATA
LOCAL
INFILE '/file.txt'
INTO TABLE input
[...]
(@partnumb, description, price)
SET product_id=(SELECT product_id FROM products WHERE [EMAIL PROTECTED])
[...]
Now if the partnumber does NOT exists in the products table the
At 23:42 + 1/28/06, Jessica Svensson wrote:
I'm doing load data a few times a day via cron and using this:
LOAD DATA
LOCAL
INFILE '/file.txt'
INTO TABLE input
[...]
(@partnumb, description, price)
SET product_id=(SELECT product_id FROM products WHERE [EMAIL PROTECTED])
[...]
Now if the
From: Paul DuBois [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED],mysql@lists.mysql.com
Subject: Re: LOAD DATA, Ignore in SET?
Date: Sat, 28 Jan 2006 17:59:23 -0600
At 23:42 + 1/28/06, Jessica Svensson wrote:
I'm doing load data a few times a day via cron and using this:
LOAD
At 0:07 + 1/29/06, Jessica Svensson wrote:
From: Paul DuBois [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED],mysql@lists.mysql.com
Subject: Re: LOAD DATA, Ignore in SET?
Date: Sat, 28 Jan 2006 17:59:23 -0600
At 23:42 + 1/28/06, Jessica Svensson wrote:
I'm doing load data a few
Ferindo Middleton Jr wrote:
Paul DuBois wrote:
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables, registration schedules, that look like this:
CREATE TABLE registration (
idSERIAL NOT NULL UNIQUE,
24 matches
Mail list logo