MySQL | Forum profile

Or you can use Navicat to directly import from Excel.

Hi, If I understand your question right, this should do the trick. Help with Code Tags MySQL Syntax ( Toggle Plain Text ) SELECT * FROM customers c, cust_packages cp WHERE c.cust_custnr = cp.cpack_usernr GROUP BY cpack_usernr HAVING count ( * ) = 1 AND cpack_canceldate != '0000-00-00' select * from customers c, cust_packages cp where c.cust_custnr = cp.cpack_usernr group by cpack_usernr having count( * ) =1 and...

• • • • Originally Posted by cwarn23 Did you know that with todays cpu speeds the average computer can calculate the reverse lookup of any hash that contains up to two digits. So if there are >=2 digits being stored in a hash then the computer can calculate the original two digit string within less than a second. Just a thing I learnt when creating a dehasher in Java. Oops... Wrong thread for this...

• • • • Originally Posted by cwarn23 So is the char field type faster than text field type? Because that's what I really need to know although it's a bugga it will consume more space for faster performance. Not really, no. The field itself isn't faster. What makes it faster is that it will always have the same size for every row. If you create a CHAR(50) column and only put 20 characters into...

• • • • Originally Posted by urtrivedi Following query should work I m assuming that both table contains year column Help with Code Tags MySQL Syntax ( Toggle Plain Text ) SELECT sum ( elec.votes ) /sum ( stat.rating ) as percentage FROM elec INNER JOIN on elec. YEAR =stat. YEAR WHERE stat. YEAR = 2009 select sum(elec.votes)/sum(stat.rating) as percentage from elec inner join...

Hi guys Thanks for all the input. My suspicions lie with the hosting company. We've had numerous issues before and the problem was always something that they hadn't setup correctly. I'm going to test this on another database.

Help with Code Tags MySQL Syntax ( Toggle Plain Text ) SELECT elec.sum ( votes ) as votes, stat.sum ( rating ) as rating, votes/rating as percentage FROM elec, stat WHERE YEAR = 2009 SELECT elec.sum(votes) as votes, stat.sum(rating) as rating, votes/rating as percentage FROM elec, stat WHERE YEAR=2009 Only thing I'm not sure about is the YEAR = 2009 in the where.

Got it! Cool thanks mate..

oh, thx dude. it's solved then!

Looks like COUNTRYCODE is a VARCHAR(3) (that is a maximum of 3 character string) so I don't think you can store the Bahamas code in that field. However if you want all country codes that start with a 1, the following may help: Help with Code Tags sql Syntax ( Toggle Plain Text ) SELECT TARIFF FROM RATES WHERE COUNTRYCODE LIKE '1%' SELECT TARIFF from RATES where COUNTRYCODE like '1%'