My table is:
type price
car1000
bike 100
I want the result:
car bike
1000100
I don't know how to get that result.
-
DO YOU YAHOO!?
雅虎邮箱超强增值服务－2G超大空间、pop3收信、无限量邮件提醒
Hello everyone:
Why can't I revoke usage from user?
mysql> show grants for ''@'172.20.16.110';
+--+
| Grants for @172.20.16.110|
+--+
| GRANT USAGE ON *.* TO ''@'172.20.16.110' |
+--
Does anyone have any experience using multiple my.cnf files on a single box?
If so, how is the my.cnf specified during startup and shutdown? I need
multiple my.cnf files to test ibbackup software because it does not
currently support using mysqld_multi.
CL
--
MySQL General Mailing List
For lis
Misa wrote:
How can I receive a TRUE or FALSE result?
Example:
SELECT `name`, `description` FROM `table1`;
I don't want to show the description cause they're big. I only want to
show the name and a result of TRUE or FALSE. TRUE if description is
not empty or not null, FALSE if empty or null
How can I receive a TRUE or FALSE result?
Example:
SELECT `name`, `description` FROM `table1`;
I don't want to show the description cause they're big. I only want
to show the name and a result of TRUE or FALSE. TRUE if description
is not empty or not null, FALSE if empty or null.
I'm using
Yes theres all this talk about timestamp returning different results
in 4.1 vs. 4.0
but i took the MYI and MYD and frm files from a winnt running 4.0.14
and transferred to a 4.1.11-Debian_4-log
and all the timestamp fields are NULL
it seems all the other data is fine. Any ideas? i suppose
http://www.briandunning.com/helios.shtml
Sorry this is WAY OFF TOPIC, but it's a pretty darn scary picture.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Im not sure if my experience will be of any help but
here it is:
I used a database with utf8 as default charset (you
can easily set this with mysql administrator) and the
columns that I needed to store Macedonian cyrilic
characters were varchar. Some letters were stored as
?. When I changed the col
Karima Velasquez wrote:
do you know about any sample code on
using BLOB columns using c++ to create querys???
C++, eh? I happen to be the MySQL++ maintainer. Two of its example
programs, cgi_image and load_file, deal with BLOBs.
http://tangentsoft.net/mysql++/
Notice the automatic
Hello.
I am trying to obtain a list of products and related information from
three tables using JOINs and GROUP BY.
my tables look like this:
products:
id: int
name varchar
ratings:
user_id int
product_id int
rating int
wishlists:
user_id int
product_id int
stars int
And I want th
thanks for answering...
i already know about these datatype, actually i'm using longblob as
datatype; which is why i don't really understand what's going on!!!
regarding on your previous message, do you know about any sample code on
using BLOB columns using c++ to create querys???
best regards
>
> >>Does MySQL 5 provide native XML support? ie, can I have a stored
> >>procedure return an XML string instead of a recordset? Can I pass in
> >>an XML string/doc and have the DB update relational tables based on
> >>it?
> >
> >
> > "native xml support", now, that's probably the funniest thing
Karima Velasquez wrote:
i know about the null terminating character, but i don't think this is the
problem.
It might not be your immediate problem, but you will run into it eventually.
rigth data: <82>
wrong data:
rigth data: ^
wrong data:
That should only happen if your column is set
Sebastian wrote:
> i have this query:
>
> SELECT COUNT(*) AS score FROM downloads WHERE date_add(dateline,
> interval 1 hour) >= now() GROUP BY filename ORDER BY score DESC
>
> unfortunately for other reasons i had to change `dateline` to unix
> timestamp so this query is no longer able to run as
Keith Ivey <[EMAIL PROTECTED]> writes:
> Scott Gifford wrote:
>
>> SELECT COUNT(*) AS score FROM downloads WHERE dateline +
>> 3600 >= UNIX_TIMESTAMP() GROUP BY filename ORDER BY score DESC
>
> It would be better with
>
> WHERE dateline >= UNIX_TIMESTAMP() - 3600
>
> so that it c
Scott Gifford wrote:
SELECT COUNT(*) AS score FROM downloads
WHERE dateline + 3600 >= UNIX_TIMESTAMP()
GROUP BY filename ORDER BY score DESC
It would be better with
WHERE dateline >= UNIX_TIMESTAMP() - 3600
so that it can use an index on dateline.
--
Keith Ivey <[EMAIL PRO
Sebastian <[EMAIL PROTECTED]> writes:
> i have this query:
>
> SELECT COUNT(*) AS score FROM downloads WHERE date_add(dateline,
> interval 1 hour) >= now() GROUP BY filename ORDER BY score DESC
>
> unfortunately for other reasons i had to change `dateline` to unix
> timestamp so this query is no l
Scott Klarenbach <[EMAIL PROTECTED]> writes:
> Does MySQL 5 provide native XML support? ie, can I have a stored
> procedure return an XML string instead of a recordset? Can I pass in
> an XML string/doc and have the DB update relational tables based on
> it?
MyXML is supposed to help with this
Martijn Tonies wrote:
>
>>Does MySQL 5 provide native XML support? ie, can I have a stored
>>procedure return an XML string instead of a recordset? Can I pass in
>>an XML string/doc and have the DB update relational tables based on
>>it?
>
>
> "native xml support", now, that's probably the fun
Well, you could use the FROM_UNIXTIME() function to convert it into a
datetime MySQL understands.
SELECT
COUNT(*) AS score
FROM downloads
WHERE
date_add(FROM_UNIXTIME(dateline), interval 1 hour) >= now()
GROUP BY filename
ORDER BY score DESC
But, considering what you're doing, it would pr
Sebastian <[EMAIL PROTECTED]> wrote on 08/15/2005 03:51:05 PM:
> i have this query:
>
> SELECT COUNT(*) AS score FROM downloads WHERE date_add(dateline,
> interval 1 hour) >= now() GROUP BY filename ORDER BY score DESC
>
> unfortunately for other reasons i had to change `dateline` to unix
> tim
* Gleb Paharenko <[EMAIL PROTECTED]> [050815 10:59]:
> Hello.
>
>
> > I'm getting the following problems:
> > Login Problem:
>
> See:
> http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
That's going to be really helpful. Thanks.
>
> > Problems unencrypting password:
>
> OL
i have this query:
SELECT COUNT(*) AS score FROM downloads WHERE date_add(dateline,
interval 1 hour) >= now() GROUP BY filename ORDER BY score DESC
unfortunately for other reasons i had to change `dateline` to unix timestamp so this query is no longer able to run as intended. can anyone help wit
> Does MySQL 5 provide native XML support? ie, can I have a stored
> procedure return an XML string instead of a recordset? Can I pass in
> an XML string/doc and have the DB update relational tables based on
> it?
"native xml support", now, that's probably the funniest thing
I've heard all day
i know about the null terminating character, but i don't think this is the
problem. comparing with the wav file, i notice that there are some
characters changed, e.g.
rigth data: <82>
wrong data:
rigth data: ^
wrong data:
so, i don't think that this is the main issue that i'm facing here..
Karima Velasquez wrote:
i'm capturing raw audio/video data and want to store it into mysql. in my
c++ program i create the query to do this, i use sprintf to create this
query using %s format for the printing.
Um, you are aware that C strings (which sprintf uses) are
null-terminated, and th
Does MySQL 5 provide native XML support? ie, can I have a stored
procedure return an XML string instead of a recordset? Can I pass in
an XML string/doc and have the DB update relational tables based on
it?
Thanks.
Scott
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
hello...
i'm having some troubles storing data in mysql and thought you can help,
here is my problem:
i'm capturing raw audio/video data and want to store it into mysql. in my
c++ program i create the query to do this, i use sprintf to create this
query using %s format for the printing.
using
Hello.
I have used a shell on a Solaris box, and successfully ran MySQL Server
under my non-root account. I didn't have any problems installing
it, except that I was unable to start it automatically on boot (I didn't
have permission to write to system startup files). Specify your
configurati
Hello.
May be set FOREIGN_KEY_CHECKS=0, alter the definitions of your tables,
and set FOREIGN_KEY_CHECKS=1. See:
http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html
"Nguyen, Phong" <[EMAIL PROTECTED]> wrote:
>
> All,
>
> How do we change column name in the tabl
Hello.
> I'm getting the following problems:
> Login Problem:
See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
> Problems unencrypting password:
OLD_PASSWORD() is available as of MySQL 4.1. 4.0.20 is a very old
version. I strongly recommend you to upgrade t
Hello.
What version of MySQL do you use? On my 5.0.11 I have a correct result:
mysql> show create table dateTest\G;
*** 1. row ***
View: dateTest
Create View: CREATE ALGORITHM=UNDEFINED VIEW
`test`.`dateTest`
Hello.
You've already got a good answer:
http://lists.mysql.com/mysql/187794
Subscribe to mysql list or use web interface. Why are you mixing latin1
with utf8 in the same column? You can check if something is wrong with your
connection variables using the following statement:
show
The older version is 4.xx.xx im not sure how to tell.
New version is 4.1.12
Thank you,
James
- Original Message -
From: "Bruce Dembecki" <[EMAIL PROTECTED]>
To: "James Sherwood" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, August 15, 2005 2:50 PM
Subject: Re: French Characters, Still no answ
Still no answer, perhaps, but ther'es still no question.
Per my earlier response... What version of MySQL is the old version
you refer to, what version is the new version you refer to? With that
information someone here is more likely to be able to tell you
something useful... without that
All,
How do we change column name in the tables where there are constraint as PK,
FK,...?
V/R
Nguyen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am still having trouble with french characters if anyone has ANY ideas,
please help.
We have installed the newest version of MySql and cannot get it to play nice
with French characters. Our older version worked fine. The problem may (or
may not) be that when we put the dump into the new datab
"Andras Kende" <[EMAIL PROTECTED]> wrote on 08/13/2005 10:32:07 PM:
> Hello,
>
> I have a html page with 70+ form fields some like 40 fields are only
used
> for entering quantity numbers…
>
> Don’t want to do Mysql table with 70 fields…
>
> Is it a good idea to put this 50 fields of the form f
Hello,
I tried to google and search on mysql.com but couldn't find anything
on installing as a non root and in /xyz directory on Solaris.
Perhaps I miss it?
I have downloaded
mysql-standard-4.1.13-sun-solaris2.8-sparc-64bit.tar.gz. The
instruction there is simply for a root user and in a sta
Hi Gary,
If you are running unix (or variants thereof), you can go to the data directory
and remove it at the operating system level if the mysql client can't do it.
Not sure about windows though but I would think the same thing would apply.
If you do that and then do a show databases, it shoul
I have a table with date values:
++
| theDate|
++
| 2005-08-15 |
| 2005-08-16 |
| 2005-08-14 |
++
I can execute this select statement on it:
select * from tDay where theDate > date_sub( now(), interval 1 day);
And I can create a view from it:
create
Manoj wrote:
Dear All,
I am trying to join two tables say a & b. Both tables have a set
of dates. I want to join the tables in such a fashion that I retrieve
all dates from table A. If table b has corresponding data (for that
date) then it will display it or else will display null. I am prett
> I need to drop a database named ÃáãÃáà using the mysql client. I'm
> getting "you have an error in your sql syntax" for the command
>
> DROP database ÃáãÃáÃ;
>
> I'm sure this is a character set issue. How can I drop this database?
What about using backticks around it:
drop database
Try
DROP database `ÃáãÃáÃ`;
Gary Huntress wrote:
I need to drop a database named ÃáãÃáà using the mysql client. I'm
getting "you have an error in your sql syntax" for the command
DROP database ÃáãÃáÃ;
I'm sure this is a character set issue. How can I drop this database?
Regards
44 matches
Mail list logo
