+ 1
Can anyone help me adding a new entry into the table and join it another table
New entry to the table
8 Antworten
+ 2
I remember someone asked about this task before. So I'd like to suggest you to try and search the forum for similar cases, just in case someone had answered it already 👍
+ 2
The following module covers how to insert data into a table, and how to join tables. It's the first part of "JOIN, Table operations" module, so you might want to review it.
https://www.sololearn.com/learn/SQL/1865/
Please edit the thread to add SQL in the tags 👍
+ 2
Please verify my code below
INSERT INTO Animals (name,type,country_id) values ('Slim','Giraffe',1)
select Animals.name, Animals.type,Countries.country from Animals
JOIN Countries
ON Animals. country_id = Countries. id
order by country
+ 1
Please tag a relevant language, the word "table" can mean HTML or SQL table, it's contextual.
P.S. It seems you had accidentally posted this twice. Kindly remove either one to help reduce duplicate questions 👍
+ 1
It's giving an error not sure where am I going wrong.
I was taking a test in sololearn and it's my last challenge.
+ 1
Got the answer I missed semi colon in the insert into statement
0
It's a SQL table
0
Does it work, have you tested yet?
Was there an error message or is it giving you wrong output?