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
Subscribe to:
Post Comments (Atom)
-
SOME INTRESTING FACT'S
-
Did Y OU Know? The Eiffel Tower was built by GUSTAVE EIFFEL for the 1889 exposition universelle to celebrate the centennial anniversary of...
-
How do search engines work? Search engines work by taking a list of known URLs, which then go to the scheduler . The scheduler decides wh...
No comments:
Post a Comment