SQL language | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

SQL language

In SQL when we want to modify the space of cell by adding their numbers , which code do we use?

31st May 2020, 8:09 PM
YONKEU KWEYA STEVE JUNIOR
YONKEU KWEYA STEVE JUNIOR - avatar
6 Answers
+ 1
YONKEU KWEYA STEVE JUNIOR Ok write update query like Update table_name set column_name = 1233 where column_name = ' ' https://www.sololearn.com/learn/SQL/1869/
31st May 2020, 9:07 PM
A͢J
A͢J - avatar
+ 1
YONKEU KWEYA STEVE JUNIOR I am not here to do your work. I can just help you by some hint. Complete SQL course and try to do self.
31st May 2020, 9:38 PM
A͢J
A͢J - avatar
0
YONKEU KWEYA STEVE JUNIOR What do you mean by adding numbers? Do you want to update empty cell value by new number?
31st May 2020, 8:39 PM
A͢J
A͢J - avatar
0
?????????????? Yes exactly
31st May 2020, 9:02 PM
YONKEU KWEYA STEVE JUNIOR
YONKEU KWEYA STEVE JUNIOR - avatar
0
------------------------------------- ---------------------------------------------------------- --------------- PATIENT (NoPatient, NoAssSociale, Name, First name) DOCTOR (NoMedicine, Name, First name) DIAGNOSIS (NoDiagnostic, description) TREATMENT (NoProcessing, description) ENTREE_DOSSIER (NoDossier, DateVisite , #NoPatient, #NoDoctor, #NoTraitement, #NoDiagnostic) ------------------------------------- ---------------------------------------------------------- --------------- 1) Give the SQL code to create the database 2) You realize that the size of the "description" attribute of the DIAGNOSTIC table is not adequate. Give the SQL code to modify it for a variable length string of 255 characters maximum. 3) Give the SQL code to add the attributes "NoTelephone" and "DateNaissance" in the PATIENT table. 4) Give the SQL code to enter the following data in the database Table PATIENT DOCTOR table Table DIAGNOSTIC TREATMENT table INPUT_FILE table 5) You entered the abuse in f
31st May 2020, 9:11 PM
YONKEU KWEYA STEVE JUNIOR
YONKEU KWEYA STEVE JUNIOR - avatar
0
????????? Please for help
31st May 2020, 9:12 PM
YONKEU KWEYA STEVE JUNIOR
YONKEU KWEYA STEVE JUNIOR - avatar