Saturday, February 27, 2021

HOW TO INSERT VALUES IN MS ACESS TABLE .

Full names Date of Birth gender Physical address Postal address Contact number Email Address Leonard Hofstadter Male Woodcrest 0845738767 Sheldon Cooper Male Woodcrest 0976736763 Rajesh Koothrappali Male Fairview 0938867763 Leslie Winkle 14/02/1984 Male 0987636553 Howard Wolowitz 24/08/1981 Male South Park P.O. Box 4563 0987786553 lwolowitz@email.me Let's INSERT data one by one. We will start with Leonard Hofstadter. We will treat the contact number as a numeric data type and not enclose the number in single quotes. INSERT INTO `members` (`full_names`,`gender`,`physical_address`,`contact_number`) VALUES ('Leonard Hofstadter','Male','Woodcrest',0845738767); https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=video&cd=&cad=rja&uact=8&ved=2ahUKEwi49qikhozvAhXFVisKHRQRC6gQuAIwAnoECAUQCQ&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D_pE7S-lzpa4&usg=AOvVaw1Hcr6ngFBmzHE0HkUiA1s7

No comments:

Post a Comment

SOME INTRESTING FACTS