Character set problem
Hy I have a table datas like that : name Mester József Job György Czibere Lajos If I create : select name from dolgozok where name like '%jó%' ; then all data will be shown. But I wolud like see datas which really contain ó character (only Mester József). Joe - Win a BlackBerry device from O2 with Yahoo!. Enter now.
DATE problem
Hy all I would like to get date in my web page. There are three different fields. YEAR MONTH and DAY I thought in SQL possible create table like this /*from my book*/ create table dates ( input_year DATETIME YEAR TO YEAR, input_month DATETIME MONTH TO MONTH, input_day DATETIME DAY TO DAY); In this example I can store year,month and day values in different fields. Mysql doesn't accept this create statement. Joe - Yahoo! Messenger NEW - crystal clear PC to PC calling worldwide with voicemail
SQL Question
Hy I want to sum quantites but there is some data that value is negative but users didn't write the - sign before. I can decide which datas are negative. I would like something like that select sum(moved_quantities) from db if moving like 'Move-' then sum seem the move is negative else move value is positive Is it possible? Joe - Yahoo! Cars NEW - sell your car and browse thousands of new and used cars online search now -
Re: SQL Question
Hy If you know which values are supposed to be negative, wouldn't it be easier to do updates to your data to change all of those values to negatives? That should only need to be done once. Then use the normal SQL sum() function to add all of the values together. Thank you. Actually my first thing was update but my SQL knowledge is weak and I don't want to mess the database. I started a script which is update bad records on a copy of that database. However I didn't solve the update problem. My script is in (PL/SQL): integer a; integer b; varchar tr; varchar ra; varchar ke; varchar moti; begin select tm.tr,tm.ra,tm.ke,tm.moti,tm.mome into tr,ke,moti,a from ev98nv_tm tm where MOTI like 'Rakt.kozi-' or MOTI like 'Kiadas -' and tm.EV like '2005' if (a 0) then a=b; b = 0- b; update ev98nv_tm set mome=b where tm.tr=tr and tm.ra=ra and tm.ke=ke and tm.moti=moti ; end; But it is not working. The Primary index is tr+ra+ke+moti Rhino ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Php is not working with MySQL
Hy I installed a Debian Sarge. Everything worked but I needed newer verison of mysql (4.1.11) and since I installed newer MySQL (from deb package) the php is not working with mysql. Please help. Joe - Win a Yahoo! Vespa NEW - Yahoo! Cars has 3 Vespa LX125s to be won Enter Now!
Setting charset
For Archivum My destination was: Changing default latin1 charset to latin2 and the default collation to latin2_hungarian_ci. I tried to configure accross my.cnf, but all of my effort failed. I installed mysql-administrator, use startup paramters in. Change mysqldump . Took changes and it works. Joe - Yahoo! Model Search - Could you be the next catwalk superstar? Check out the competition now
default character setting
Hy I tried to set the default character set for mysql-4.1-15 server in my.cnf [client] section with set : character-sets-dir=/usr/local/mysql/share/mysql/charsets and default_character_set=latin2 but when I check the defaults by show variables like '%_server' I get these value is latin1 What is wrong? Please help. Joe - Yahoo! Model Search - Could you be the next catwalk superstar? Check out the competition now