Forum » Programiranje » [mysql] bug?
[mysql] bug?

korenje3 ::
mysql> show columns in Users;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| ID | varchar(36) | NO | PRI | NULL | |
| Ime | varchar(256) | YES | | NULL | |
| Priimek | varchar(256) | YES | | NULL | |
+---------+--------------+------+-----+---------+-------+
3 rows in set (0.01 sec)
mysql> select * from Users where Ime = `Joze`;
ERROR 1054 (42S22): Unknown column 'Joze' in 'where clause'
Je to stvarna napaka?
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| ID | varchar(36) | NO | PRI | NULL | |
| Ime | varchar(256) | YES | | NULL | |
| Priimek | varchar(256) | YES | | NULL | |
+---------+--------------+------+-----+---------+-------+
3 rows in set (0.01 sec)
mysql> select * from Users where Ime = `Joze`;
ERROR 1054 (42S22): Unknown column 'Joze' in 'where clause'
Je to stvarna napaka?
i9-12900k; 32GB DDR5-6000 CL36; Nvidia RTX 3080 ti;
Gigabyte Aorus z690 master; Be Quiet Dark Power 12 1000W
Gigabyte Aorus z690 master; Be Quiet Dark Power 12 1000W
Vredno ogleda ...
Tema | Ogledi | Zadnje sporočilo | |
---|---|---|---|
Tema | Ogledi | Zadnje sporočilo | |
» | SQL vprasanje (strani: 1 2 )Oddelek: Programiranje | 8531 (5210) | BivšiUser2 |
» | Pomoč pri izdelavi Python skripte (strani: 1 2 )Oddelek: Programiranje | 5970 (4616) | BigWhale |
» | SQL poizvedbaOddelek: Programiranje | 2196 (1706) | borchi |
» | Malce zahtevnejši SQL stavek včasih narobe SELECT-aOddelek: Izdelava spletišč | 2193 (1862) | Brilko |
» | Ocena kode in napotki za izboljsanjeOddelek: Izdelava spletišč | 1022 (920) | Rumko |