1. Forum
  2. USENET
  3. comp.databases.mysql

  • Query OK, 0 rows affected, 1 warning (0.063 sec)

    From ^Bart@gabriele1NOSPAM@hotmail.com to comp.databases.mysql on Sat Dec 7 17:49:34 2019
    From Newsgroup: comp.databases.mysql

    I don't understand which is this warning :\

    CREATE TABLE subfoodgroups
    (
    subfoodgroup_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    name VARCHAR(30) NOT NULL,
    language_id SMALLINT(5) UNSIGNED NOT NULL,
    foodgroup_id INT(10) UNSIGNED NOT NULL,
    rawmaterial ENUM ("Yes","No"),
    PRIMARY KEY (subfoodgroup_id),
    INDEX (language_id),
    FOREIGN KEY (language_id) REFERENCES languages (language_id),
    INDEX (language_id),
    FOREIGN KEY (foodgroup_id) REFERENCES foodgroups (foodgroup_id)
    )
    ENGINE=INNODB;

    ^Bart
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Jerry Stuckle@jstucklex@attglobal.net to comp.databases.mysql on Sat Dec 7 12:13:51 2019
    From Newsgroup: comp.databases.mysql

    On 12/7/2019 11:49 AM, ^Bart wrote:
    I don't understand which is this warning :\

    CREATE TABLE subfoodgroups
    (
    subfoodgroup_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    name VARCHAR(30) NOT NULL,
    language_id SMALLINT(5) UNSIGNED NOT NULL,
    foodgroup_id INT(10) UNSIGNED NOT NULL,
    rawmaterial ENUM ("Yes","No"),
    PRIMARY KEY (subfoodgroup_id),
    INDEX (language_id),
    FOREIGN KEY (language_id) REFERENCES languages (language_id),
    INDEX (language_id),
    FOREIGN KEY (foodgroup_id) REFERENCES foodgroups (foodgroup_id)
    )
    ENGINE=INNODB;

    ^Bart

    What was the warning?
    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    jstucklex@attglobal.net
    ==================
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Lew Pitcher@lew.pitcher@digitalfreehold.ca to comp.databases.mysql on Sat Dec 7 12:36:39 2019
    From Newsgroup: comp.databases.mysql

    Jerry Stuckle wrote:

    On 12/7/2019 11:49 AM, ^Bart wrote:
    I don't understand which is this warning :\

    CREATE TABLE subfoodgroups
    (
    subfoodgroup_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    name VARCHAR(30) NOT NULL,
    language_id SMALLINT(5) UNSIGNED NOT NULL,
    foodgroup_id INT(10) UNSIGNED NOT NULL,
    rawmaterial ENUM ("Yes","No"),
    PRIMARY KEY (subfoodgroup_id),
    INDEX (language_id),
    FOREIGN KEY (language_id) REFERENCES languages (language_id),
    INDEX (language_id),
    FOREIGN KEY (foodgroup_id) REFERENCES foodgroups (foodgroup_id)
    )
    ENGINE=INNODB;

    ^Bart

    What was the warning?

    Agreed.

    FWIW, ERROR_CANNOT_REPRODUCE

    mysql> create table languages
    -> (
    -> language_id smallint(5) unsigned not null auto_increment primary key
    -> ) engine=innodb;
    Query OK, 0 rows affected (0.00 sec)

    mysql> create table foodgroups
    -> (
    -> foodgroup_id int(10) unsigned not null auto_increment primary key
    -> ) engine=innodb;
    Query OK, 0 rows affected (0.01 sec)

    mysql> CREATE TABLE subfoodgroups
    -> (
    -> subfoodgroup_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    -> name VARCHAR(30) NOT NULL,
    -> language_id SMALLINT(5) UNSIGNED NOT NULL,
    -> foodgroup_id INT(10) UNSIGNED NOT NULL,
    -> rawmaterial ENUM ("Yes","No"),
    -> PRIMARY KEY (subfoodgroup_id),
    -> INDEX (language_id),
    -> FOREIGN KEY (language_id) REFERENCES languages (language_id),
    -> INDEX (language_id),
    -> FOREIGN KEY (foodgroup_id) REFERENCES foodgroups (foodgroup_id)
    -> )
    -> ENGINE=INNODB;
    Query OK, 0 rows affected (0.02 sec)

    mysql> explain subfoodgroups; +-----------------+----------------------+------+-----+---------+----------------+
    | Field | Type | Null | Key | Default | Extra |
    +-----------------+----------------------+------+-----+---------+----------------+
    | subfoodgroup_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
    | name | varchar(30) | NO | | NULL | |
    | language_id | smallint(5) unsigned | NO | MUL | NULL | |
    | foodgroup_id | int(10) unsigned | NO | MUL | NULL | |
    | rawmaterial | enum('Yes','No') | YES | | NULL | |
    +-----------------+----------------------+------+-----+---------+----------------+
    5 rows in set (0.00 sec)

    mysql>
    --
    Lew Pitcher
    "In Skills, We Trust"
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From J.O. Aho@user@example.net to comp.databases.mysql on Sat Dec 7 21:33:57 2019
    From Newsgroup: comp.databases.mysql

    On 07/12/2019 17.49, ^Bart wrote:
    I don't understand which is this warning :\

    CREATE TABLE subfoodgroups
    (
    subfoodgroup_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    name VARCHAR(30) NOT NULL,
    language_id SMALLINT(5) UNSIGNED NOT NULL,
    foodgroup_id INT(10) UNSIGNED NOT NULL,
    rawmaterial ENUM ("Yes","No"),
    PRIMARY KEY (subfoodgroup_id),
    INDEX (language_id),
    FOREIGN KEY (language_id) REFERENCES languages (language_id),
    INDEX (language_id),
    FOREIGN KEY (foodgroup_id) REFERENCES foodgroups (foodgroup_id)
    )
    ENGINE=INNODB;

    ^Bart

    You get a warning when your string is longer than 30 characters long,
    don't forget that UTF characters may take 2 or more in your table.
    --

    //Aho
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Luuk@luuk@invalid.lan to comp.databases.mysql on Sun Dec 8 18:07:16 2019
    From Newsgroup: comp.databases.mysql

    On 7-12-2019 17:49, ^Bart wrote:
    I don't understand which is this warning :\

    CREATE TABLE subfoodgroups
    (
    subfoodgroup_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    name VARCHAR(30) NOT NULL,
    language_id SMALLINT(5) UNSIGNED NOT NULL,
    foodgroup_id INT(10) UNSIGNED NOT NULL,
    rawmaterial ENUM ("Yes","No"),
    PRIMARY KEY (subfoodgroup_id),
    INDEX (language_id),
    FOREIGN KEY (language_id) REFERENCES languages (language_id),
    INDEX (language_id),
    FOREIGN KEY (foodgroup_id) REFERENCES foodgroups (foodgroup_id)
    )
    ENGINE=INNODB;

    ^Bart



    Dit geeft info over de waarschuwingen:

    SHOW WARNINGS;
    --
    Luuk
    --- Synchronet 3.21d-Linux NewsLink 1.2