2009/2/21 Chris Rehm
> I want to write some programs to work with data from eveonline.com but my
> installed database is MySQL and the data format they provide is a backup of
> MSSQL. They recommend installing SQL Server 2005 Express and I've downloaded
> that and am willing to install it, I just
Hello,
Can anyone point me to a section of manual or link how to reduce digits
after
a decimal sign?
I have a table
mysql> desc part;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+
Hi all,
First I would like to thank you for the invaluable pieces of advice.
I've made a good progress thanks to you.
Now I'm trying to display the output of people who have shareholders at more
than one place
select COUNT (*),IME,LAND,CNT,ID, (select round(bulstat,0)) from part GROUP
BY IME,LAND
2007/2/10, Dimitar Vasilev <[EMAIL PROTECTED]>:
Hi all,
First I would like to thank you for the invaluable pieces of advice.
I've made a good progress thanks to you.
Now I'm trying to display the output of people who have shareholders at
more than one place
select COUNT (*)
Hi all,
I have a table shares that consists of
company id, shareholder id, shareholder name.
Company id and shareholder id are decimal digits; shareholder name is text.
Due to some missings of my initial data, I'd like to create a unique id for
the shareholder ids
which are blank/null in the import
2007/9/22, Shawn Green <[EMAIL PROTECTED]>:
>
> Hello Dimitar,
>
> Dimitar Vasilev wrote:
> > Hi all,
> > I have a table shares that consists of
> > company id, shareholder id, shareholder name.
> > Company id and shareholder id are decimal digits; s
