Need some MySQL code help

[Dogz]

Basically I'm crap at SQL code.

Anyone here have any knowledge of writing SQL code?

[DustPox]

Moderate knowledge here mate =)

[Dogz]

Ok I'd apprecriate some help.

If I was to create the following tables, would my code be appropriate?

Hotel(hotelNo, hotelName, city)
Room(roomNo, hotelNo, type, price)

CREATE TABLE Hotel (
hotelNo INTEGER,
hotelName VARCHAR(20),
City CHAR(20),

CREATE TABLE Room (
roomlNo INTEGER,
hotelNo VARCHAR(20),
type CHAR(20),
price CHAR (3)

I haven't much of a clue about SQL code. Intergers etc. See if you can make it better.

[DustPox]

What exactly are you trying to make or trying for it to do? i cant find an error in the code.. but well im confused as to what youre trying to do.

[Dogz]

It's a Uni question.

'List and describe the SQL code to create the following tables. You can assume that the price of a room is always a whole number of pounds'

Hotel(hotelNo, hotelName, city)
Room(roomNo, hotelNo, type, price)

If you were to do that, what would it look like in terms of code?

[SalMAX]

I only know C#, Java and some C and Pascal, but assuming CHAR and INTEGER are universal - why is "price" a CHAR?

[Dogz]

Because I don't know what CHAR and INTEGER mean. I'm clueless.

[SalMAX]

Its pretty straight forward. Integer is for numbers and Char is for characters.

[Dogz]

You sir is a legend. Thanks.

[Tangster]

Originally Posted by SalMAX

I only know C#, Java and some C and Pascal, but assuming CHAR and INTEGER are universal - why is "price" a CHAR?

Only...

@mark, CHAR defines a character, ie letters or symbols, INTEGER is what is sounds like and defines whole numbers.

Damn Sal, you got these first.

[Dogz]

Thanks. Makes more sense now.

[Tangster]

You may want to use FLOAT instead since prices are decimals.

[SalMAX]

Originally Posted by Tangster

You may want to use FLOAT instead since prices are decimals.

'You can assume that the price of a room is always a whole number of pounds'

[Dogz]

For this, the price is a whole number of pounds.

Just out of interest, do I have to specify the number of characters in brackets or can I just leave that

e.g hotelName CHAR

Instead of hotelName CHAR (20)

?

[DustPox]

Originally Posted by Dogz

For this, the price is a whole number of pounds.

Just out of interest, do I have to specify the number of characters in brackets or can I just leave that

e.g hotelName CHAR

Instead of hotelName CHAR (20)

?

Well that depends on what the max size of name is..
If you put 20 there, you max the chars to twenty.. so if u have a hotel name with more than 20 chars.. your fucked..

just leave the (20)