Re: [GENERAL] Inserting boolean types as an alias?

2013-12-03 Thread Michal Politowski
On Mon, 2 Dec 2013 15:46:17 -0800, Nick wrote: [...] This is what I have currently for the line that I am specifically talking about: INSERT INTO club_Games(memberID, gameID, hardwareID, count, status) VALUES ((SELECT memberID FROM members WHERE name = 'Fred Flinstone'), (SELECT

[GENERAL] Inserting boolean types as an alias?

2013-12-02 Thread Nick
Hello I am new to this site and also a student. I am working on an assignment and was wondering if there is a way to make an alias for a boolean? For example when I am making a table called club_games and it must contain the memberID, gameID, count, and status as column fields. When I enter the

Re: [GENERAL] Inserting boolean types as an alias?

2013-12-02 Thread Adrian Klaver
On 12/02/2013 03:46 PM, Nick wrote: Hello I am new to this site and also a student. I am working on an assignment and was wondering if there is a way to make an alias for a boolean? For example when I am making a table called club_games and it must contain the memberID, gameID, count, and status

Re: [GENERAL] Inserting boolean types as an alias?

2013-12-02 Thread John R Pierce
On 12/2/2013 3:46 PM, Nick wrote: Hello I am new to this site and also a student. I am working on an assignment and was wondering if there is a way to make an alias for a boolean? For example when I am making a table called club_games and it must contain the memberID, gameID, count, and status

Re: [GENERAL] Inserting boolean types as an alias?

2013-12-02 Thread David Johnston
John R Pierce wrote On 12/2/2013 3:46 PM, Nick wrote: Hello I am new to this site and also a student. I am working on an assignment and was wondering if there is a way to make an alias for a boolean? For example when I am making a table called club_games and it must contain the memberID,

Re: [GENERAL] Inserting boolean types as an alias?

2013-12-02 Thread John R Pierce
On 12/2/2013 5:18 PM, David Johnston wrote: Not sure an enum would work since the source table has the status column defined as boolean... well, you'd need to alter the table to use an enum, of course. -- john r pierce 37N 122W somewhere on the middle of