Re: Standard of Column Names

2004-04-27 Thread Ruslan U. Zakirov
Ronan Lucio wrote: Hello, I´m doing the planing for an application that will use MySQL as database. So, I´d like to know your opinions about the standard for the column names. Supposing that I should create a table named car. Is it better to have either the column names (cod, name, description)

Re: NOT NULL column behaves strangely

2004-04-14 Thread Ruslan U. Zakirov
Keith C. Ivey wrote: On 14 Apr 2004 at 17:27, B. Fongo wrote: I expected a warning because of the Token column shouldn't be NULL! It's not NULL. It's the empty string, which is the default value, since you didn't give it a specific default value. See the CREATE TABLE documentation:

Re: Implement one statement w/o subqueries.

2004-01-14 Thread Ruslan U. Zakirov
Mike Johnson wrote: From: Ruslan U. Zakirov [mailto:[EMAIL PROTECTED] Hello. Table 1: Items id, Name Table 2: Properties id, Item, Name, Value I want select Items _and_ all thier props only if Item have specified property. Example: Table Item: 1, Mouse 2, Monitor 3, Keyboard

Implement one statement w/o subqueries.

2004-01-13 Thread Ruslan U. Zakirov
Hello. Table 1: Items id, Name Table 2: Properties id, Item, Name, Value I want select Items _and_ all thier props only if Item have specified property. Example: Table Item: 1, Mouse 2, Monitor 3, Keyboard Table Properties: 1, 1, Color, Red 2, 2, Color, Gray 3, 1, Interface,

Re: Reinstall error

2003-12-29 Thread Ruslan U. Zakirov
Rob Snow wrote: I reinstalled my entire system and then reinstalled mysql again. Making sure I went through the correct set-up this time. I have set a root password and now when I go to /usr/local/mysql and type in mysql -u root -p it says that mysql is not a found command. Your shell can't find