2009/2/21 Chris Rehm ch...@javadisciple.com
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
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; shareholder name is
text.
Due to some missings of my initial
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
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 (*),IME,LAND,CNT,ID
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
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 |