0
SQL language
In SQL when we want to modify the space of cell by adding their numbers , which code do we use?
6 Réponses
+ 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/
+ 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.
0
YONKEU KWEYA STEVE JUNIOR What do you mean by adding numbers? Do you want to update empty cell value by new number?
0
?????????????? Yes exactly
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
0
????????? Please for help