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 | 8428 (5107) | BivšiUser2 |
» | Pomoč pri izdelavi Python skripte (strani: 1 2 )Oddelek: Programiranje | 5885 (4531) | BigWhale |
» | SQL poizvedbaOddelek: Programiranje | 2178 (1688) | borchi |
» | Malce zahtevnejši SQL stavek včasih narobe SELECT-aOddelek: Izdelava spletišč | 2162 (1831) | Brilko |
» | Ocena kode in napotki za izboljsanjeOddelek: Izdelava spletišč | 1010 (908) | Rumko |