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
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
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
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
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
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
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