This semester I just learned about the database. the Statement for creating a view for mysql is createviewsupply (sno, pno, qty) asselectspj. sno, spj. pno, spj. qtyfromspj, jwherej. jnospj. jnoandj. jname & #39; Sanjian & #39; in this way, the view is successfully created, but select * fromsupply; the query result is empty. If you change the view name from supply to another view name, such as san_jian, the query result is mysql view data database.
I just learned about the database this semester and asked about how to create a view for mysql.
Statement for creating a view:
Create view supply (sno, pno, qty) as select spj. sno, spj. pno, spj. qty from spj, j where j. jno = spj. jno and j. jname = 'sanj ';
In this way, the view is successfully created, but the query result is empty when select * from supply.
If you change the view name from supply to another view name such as san_jian, the query result is correct. Ask for advice. why?