Jason Chan wrote:
Jason Chan wrote:
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
StudentID INT NOT NULL,
Subject VARCHAR(30) NOT NULL,
Grade CHAR(1)
)
let's say have following record in
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,
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
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
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
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
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
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 fields into
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
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]
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
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: mysql@lists.mysql.com
Sent: Monday, August 15, 2005 2:50 PM
Subject: Re: French Characters,
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:
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.
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 to
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 tables
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
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.
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:
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
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...
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 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
* 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:
OLD_PASSWORD() is
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
timestamp so
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
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 funniest thing
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 sort
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 longer
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
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 can use an index
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
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
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
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
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
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
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
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]
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
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
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
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
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' |
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收信、无限量邮件提醒
45 matches
Mail list logo