Well, I've never used rpm, only apt.
In apt, to get the list of mysql installed packages I do
# dpkg -l | grep -i mysql
you should find the equivalent command on rpm; maybe rpm -l but I'm not
sure.
Then, when I have the list, I can remove each package with
#apt-get remove --purge -u
Andrew Braithwaite wrote:
Are you using MySQL?
yes of course :)
OK, if you are then first simplify your query:
group by 1
thanks, I didn't know it.
Then add the AVG column which will work ok with the group by :
select date_format(dt_imp,'%Y/%m') as date,
SUM(imp),
Hello people.
I have a table structured like this
+--+---+
| Field| Type |
+--+---+
| dt_imp | date |
| imp | decimal(5,2) |
+--+---+
If I want to get the total
Good evening people.
I'm trying to create a simple table via MySQl Navigator.
The table il structured in this way
dt_amt DateNot NullPrimary Key
operINT Not NullPrimary Key
amount Decimal(3,3)Null---
but when I choose fire it shows me
Mayuran wrote:
Ive never used MySQL navigator, but I think you should assign the
primary keys
in the same line, like so:
dt_amtDateNot Null
operINTNot Null
amountDecimal(3,3)Null
primary key (dt_amt, oper)
thats, ok. It's a sql navigator bug! I had created the