Null and Blank values in MySQL
Null is absence of value. The blank is value that is empty string. Let's say if we need to create customer table with different columns. There is possibility that sometime we don't have any last name. So we will leave the column without inserting any value, As we are not inserting any value in last name then it will have null ( Absence of value).
There could be scenarios when you will insert the value but blank. Let's create our table and then insert leave few column value as Null and insert some blank values.
CREATE TABLE `customer` (
`firstname` varchar(50) NULL,
`lastname` varchar(30) NULL,
`age` int(11) DEFAULT NULL,
`phonenumber` char(11) DEFAULT NULL,
`dob` date DEFAULT NULL,
`gender` char(1) NOT NULL
) ;
Let's insert some values in customer table.
`firstname` varchar(50) NULL,
`lastname` varchar(30) NULL,
`age` int(11) DEFAULT NULL,
`phonenumber` char(11) DEFAULT NULL,
`dob` date DEFAULT NULL,
`gender` char(1) NOT NULL
) ;
Let's insert some values in customer table.
insert into customer(idcustomer,firstname,lastname,age,phonenumber,dob,gender)
values
(1,'Aamir','Ali',39,'505-4141969','1980-01-01','M'),
(2,'Aamir','Naz',39,'505-4141969','1980-01-01','M'),
(3,'Bob',Null,59,'505-4141969','1980-01-01','M'),
(4,'Robert','',59,'505-4141969','1980-01-01','M'),
(5,'Lisa',' ',59,'505-4141969','1980-01-01','M');
values
(1,'Aamir','Ali',39,'505-4141969','1980-01-01','M'),
(2,'Aamir','Naz',39,'505-4141969','1980-01-01','M'),
(3,'Bob',Null,59,'505-4141969','1980-01-01','M'),
(4,'Robert','',59,'505-4141969','1980-01-01','M'),
(5,'Lisa',' ',59,'505-4141969','1980-01-01','M');
Now if you want to get the records from customer table which don't have value (absent of value) in lastname column. you can use below query.
If we need to find all the rows which has blank value in lastname column, and you can see in our insert statement we have blank values which is equal to '' or ' ' or more blank spaces.
We can use ltrim and rtrim to trim to single blank space to compare and get all the records.
They're produced by the very best degree developers who will be distinguished for your polo dress creating. You'll find polo Ron Lauren inside exclusive array which include particular classes for men, women.
ReplyDeleteartificial intelligence course in india
There are such a large number of kinds of articles accessible. I extremely get a kick out of the chance to read the one which you have partaken in this post. Each article has novel and particular characteristics to its write. We can see some same characters in all articles. Writers motivate opportunity to share imperative and convincing data by inquiring about and framing writing thought and altering work to the readers. You have completed an incredible work. I truly making the most of your posts. Refer best essay writing service to get any help in writing.
ReplyDeleteThanks for your unique post and Keep doing...
ReplyDeleteOracle Training in Chennai
best oracle training institute in chennai
Corporate Training in Chennai
Embedded System Course Chennai
Unix Training in Chennai
Job Openings in Chennai
Pega Training in Chennai
Spark Training in Chennai
Excel Training in Chennai
Soft Skills Training in Chennai
JMeter Training in Chennai
Oracle Training in Anna Nagar
BA Exam Result - BA 1st Year, 2nd Year and 3rd Year Result
ReplyDeleteBsc Exam Result - Bsc 1st Year, 2nd Year and 3rd Year Result
This comment has been removed by the author.
ReplyDeleteI like your post very much. It is very much useful for my research. I hope you to share more info about this. Keep posting SQL server DBA certification
ReplyDelete
ReplyDeleteالرائد افضل شركات تنظيف خزانات المياه يسعدنا ان نقدم لكم افضل خدمات
شركة غسيل خزانات بالمدينة المنورة تنظيف خزانات بالمدينة المنورة
افضل شركة تنظيف منازل بالمدينة المنورة شركة تنظيف بيوت بالمدينة المنورة
I am looking for SQL commands and this will be very helpful for me to learn more about table insertion.
ReplyDeleteDigital marketing
Nice blog. I like the article shared by you.
ReplyDeleteautocad training center in Delhi
autocad training center in Noida
Nice blog. I like the article shared by you.
ReplyDeleteautocad training center in Delhi
autocad training center in Noida
This comment has been removed by the author.
ReplyDeleteGood Article !!!
ReplyDeleteSQL Azure Online Training
Azure SQL Training
SQL Azure Training
ReplyDeleteThanks for sharing the information
autocad training institute in delhi
autocad training institute in Noida
Very useful and informative blog. Thank you so much for these kinds of informative blogs.
ReplyDeleteArabic Mehndi Design | Bridal Mehndi Design | Leg Mehndi Design | Full Hand Mehndi Design | Easy Mehndi Design | Party Mehndi Design
Nice post
ReplyDeleteautocad training institute in Noida
autocad training institute in Delhi
Interesting post.This post gives required information to the visitor
ReplyDeleteautocad training institute in Noida
autocad training institute in Delhi
Thanks for this wonderful blog. keep update more information about this
ReplyDeleteEthical Hacking Course in Chennai
Hacking Course in Chennai
Ethical hacking course in bangalore
Ethical hacking course in coimbatore
Ethical Hacking Training in Chennai
Certified Ethical Hacking Course in Chennai
Ethical Hacking Training Institute in Chennai
Ethical hacking Training institute in bangalore
Software Testing Training in Chennai
ielts coaching centre in coimbatore
Thanks for sharing valuable information
ReplyDeleteautocad training institute in Noida
autocad training institute in Delhi
ReplyDeleteInteresting post.Thanks for sharing
autocad training institute in Noida
autocad training institute in Delhi
I am very happy to read this blog.. keep sharing this blog...
ReplyDeletePHP Training in Chennai
PHP Training in bangalore
PHP Training in Coimbatore
PHP Course in Madurai
Spoken English Classes in Bangalore
Data Science Course in Chennai
Best PHP Training in Chennai
Best PHP Training Institute in Bangalore
Best PHP Training in Coimbatore
AWS Training in Chennai
Such an interesting post shared by you
ReplyDeleteAutoCad training institute in Noida
AutoCad training institute in Delhi
Interesting post post by you
ReplyDeleteAutoCad training institute in Noida
AutoCad training institute in Delhi
Nice! thank you so much! Thank you for sharing. Your blog posts are more interesting and informative. I think there are many people like and visit it regularly, including me. Digital Marketing Institute in Delhi | Digital Marketing Training in Delhi | Digital Marketing Training Institute in Delhi | Best Digital Marketing Institute in Delhi | Best Digital Marketing Course in Delhi
ReplyDeleteThank you so much for this wonderful Post. This is an awesome post thank you for sharing this interesting post... Best Physics Tuition in Rohini | Best Physics Classes in Rohini | Best Physics Institute in Rohini | Best Physics Tuition Center in Rohini | Best Physics Tutor in Rohini
ReplyDeleteExtremely decent blog and articles. I am really extremely glad to visit your blog. Presently I am discovered which I really need. We are extremely thankful for your blog entry.
ReplyDeleteSinging Classes in Delhi | Fashion Designing Course in Delhi | Makeup Course in Delhi | Event Management Course in Delhi | Interior Design Course in Delhi
I am thankful to this blog for assisting me. I added some specified clues which are really important for me to use them in my writing skill. Really helpful stuff made by this blog. Voip service
ReplyDeleteThanks for sharing information.We also offer packers and movers in miyapur, Hyderabad and across all towns and cities in India.
ReplyDeleteYou're the best for taking the time and composing this post. This post truly helped me to find out about this subject. Great post. On the off chance that you need you can visit my site to find out about style fit for lords (and, obviously, the sovereigns) and other such huge numbers of tips for better, cool, the kitschy item under the rainbow. thanks for sharing this comment.
ReplyDeletetechnology news pakistan
Today, Emblix as one of the best and top most service-oriented Digital Marketing Agency in Hyderabad and India , Which provides high-quality result-oriented Digital Services ranging from SEO to Web Design, Social Media Marketing and more, to a broad spectrum of clients from diverse industry segments. Through a well-oiled combination of Quality Solutions, Transparent Pricing, helping brands connect with customers, Flexible Delivery & Contract Model with a firm commitment to deliver on time and to budget, Emblix has successfully built a strong relationship with clients based on mutual trust and respect. Further, Emblix’s extensive market experience and expertise in Digital Marketing helps clients in successfully managing data as a strategic asset.
ReplyDeleteWebsite: https://www.emblixsolutions.com
Thank you so much for this wonderful Post. This is an awesome post thank you for sharing this interesting post.
ReplyDelete7 tips to start a career in digital marketing
“Digital marketing is the marketing of product or service using digital technologies, mainly on the Internet, but also including mobile phones, display advertising, and any other digital medium”. This is the definition that you would get when you search for the term “Digital marketing” in google. Let’s give out a simpler explanation by saying, “the form of marketing, using the internet and technologies like phones, computer etc”.
we have offered to the advanced syllabus course digital marketing for available join now
more details click the link now
https://www.webdschool.com/digital-marketing-course-in-chennai.html
Thank for this blog are more informative step by step and useful contents. I here by attached my site would you see this blog.
ReplyDeleteWeb designing trends in 2020
When we look into the trends, everything which is ruling today’s world was once a start up and slowly begun getting into. But Now they have literally transformed our lives on a tremendous note. To name a few, Facebook, Whats App, Twitter can be a promising proof for such a transformation and have a true impact on the digital world.
we have offered to the advanced syllabus course web design and development for available join now
more details click the link
https://www.webdschool.com/web-development-course-in-chennai.html
Really awesome blog!!! I finally found a great post here.I really enjoyed reading this article. Thanks for sharing valuable information.
ReplyDeleteData Science Course
Thank you so much for this wonderful Post...
ReplyDeleteDigital Marketing in Bangalore
Great Post...Thanks for Sharing the Information...
ReplyDeleteBest Training Institution for IT and Non-IT Courses in Bangalore
Nice post!! Thanks for sharing...
ReplyDeleteUnani Treatment in Bangalore
If you are stuck with your Law assignment then in this case you can opt for our Law Assignment Help. we provide the bestLaw homework writing service UK.We also provideBusiness Law Homework Help for students across the globe. for more information contact us +16692714848.
ReplyDeleteThis Blog is really informative!! keep update more about this...
ReplyDeleteAviation Academy in Chennai
Air Hostess Training in Chennai
Airport Management Courses in Chennai
Best Aviation Academy in Chennai
Ground Staff Training in Chennai
Air Hostess Academy in Chennai
Airport Management Training in Chennai
Airport Ground Staff Training Courses in Chennai
ReplyDeleteThanks for posting such informative and valuable blog post so keep posting and update us.
New Business Ideas and Tips
Effective SEO Strategies 2020
10 Digital Marketing Trends
Content Marketing
Great article with lots of useful information on CCNA Training in Chennai wonderful explanation on CCNA module.
ReplyDeleteCCNA Training Center in Chennai | Best CCNA Training in Chennai | CCNA Training Institute in Chennai
It's very useful blog post with inforamtive and insightful content and i had good experience with this information. We, at the CRS info solutions ,help candidates in acquiring certificates, master interview questions, and prepare brilliant resumes.Find top Salesforce admin interview questions in 2020.
ReplyDeleteThese Salesforce developer interview questions are highly helpful in 2020. You can read these Salesforce lightning interview questions and Salesforce integration interview questions which are prepared by industry experts.
I am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here. Avenue South Residence
ReplyDeleteReally I enjoy your site with effective and useful information. It is included very nice post with a lot of our resources.thanks for share. i enjoy this post. Avenue South Residence
ReplyDeleteI am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here. The Avenir
ReplyDeleteReally I enjoy your site with effective and useful information. It is included very nice post with a lot of our resources.thanks for share. i enjoy this post. The Avenir
ReplyDeleteI am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here. midtown modern condo
ReplyDeleteReally I enjoy your site with effective and useful information. It is included very nice post with a lot of our resources.thanks for share. i enjoy this post. midtown modern condo
ReplyDelete
ReplyDeleteThrough this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training
Msbi online training Hyderabad
Msbi online training India
Msbi online course
I am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here. myra condo
ReplyDeleteReally I enjoy your site with effective and useful information. It is included very nice post with a lot of our resources.thanks for share. i enjoy this post. myra condo
ReplyDeleteI am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here. One Pearl Bank
ReplyDeleteReally I enjoy your site with effective and useful information. It is included very nice post with a lot of our resources.thanks for share. i enjoy this post. One Pearl Bank
ReplyDeleteI am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here. Hyll On Holland
ReplyDeleteReally I enjoy your site with effective and useful information. It is included very nice post with a lot of our resources.thanks for share. i enjoy this post. Hyll On Holland
ReplyDeletedr kamuran zeynep sevim Turkey – Book Online Appointment, Reviews, Contact Number, Address
ReplyDeleteDr. Cenk Şen Turkey – Book Online Appointment, Reviews, Contact Number, Address
ReplyDeleteDr. Koray Coskunfırat Turkey – Book Online Appointment, Reviews, Contact Number, Address
Dr atilla eyupogolu Turkey – Book Online Appointment, Reviews, Contact Number, Address
dr kamuran zeynep sevim Turkey – Book Online Appointment, Reviews, Contact Number, Address
ReplyDelete
ReplyDeleteThrough this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training
Msbi online training Hyderabad
Msbi online training India
Msbi online course
Msbi course
Msbi training
Msbi certification training
Outstanding I like this!!!!!!!!!! Hello guys, I want to tell you that this is an awesome blog and which you have written in this blog, each and every word is also great. Nice dear!! Thanks to sharing with us! Thanks a lot, dear!!!!!!!!!
ReplyDeleteIndia VPS Hosing
Wonderful article post!!!
ReplyDeleteDubai VPS Server
That's wonderful information!!!
ReplyDeleteUK VPS Server Hosting
I finally found great post here.I will get back here. I just added your blog to my bookmark sites. thanks.Quality posts is the crucial to invite the visitors to visit the web page, that's what this web page is providing.
ReplyDeleteartificial intelligence course in bangalore
These mysql queries really helped us in our project. Thanks for this nice blog.
ReplyDeleteThanks
Mereint Infotech
https://merientinfotech.com/
The blog is quite resourceful, however a touch of the professionals can diversity it even further. Visit idealassignmenthelp.com and watch how the experts promise a fine quality my assignment help. The best experts in the business are here to take care of your academic needs.
ReplyDeleteThanks for posting, the blog is very informative. If you want assignment help from top assignment writers, then idealassignmenthelp.com is for you. Choose your best assignment help writing service for instant assignment help.
ReplyDeleteThis blog seems very informative and really a good post you writes! Now Get Assignment Help Australia from our great assignment writers. IdealAssignmentHelp.Com offers assignment help and assignment writing services for foreign students.
ReplyDeleteI feel SSIS is a very important component which actually helps in solving of many complex IT problems and facts.
ReplyDeleteSSIS Upsert
I am feeling great to read this.you gave a nice info for us.
ReplyDeleteplease update more.
Android Training Institute in Coimbatore Best Android Training Institutes in Coimbatore | Android Training Course in Coimbatore | Mobile App Training Institute in Coimbatore | Android Training Institutes in Saravanampatti | Online Android Training Institutes in Coimbatore | Mobile Development Training Institute in Coimbatore
The author of the blog certainly has extremely impressive writing skills. You can strengthen the blog even further by adding a few grammatical detailing that promises to take your written piece to another level. Explore the academic services offered by livewebtutors.com and seek assignment help. Read More Here….My Assignment Help | Assignment Help Australia
ReplyDeleteSearch for the best offers and collect discounts from the top stores all over the UK. Exclusive Discount Voucher Codes
ReplyDeleteVouchers Codes
Call Tutors is a one stop destination for all students who are looking for expert help in their Homework & Assignments, Programming, research papers, Business Plan & Presentations & more.
ReplyDeletedo my accounting homework
C Programming Assignment Help
C++ Programming Help
html homework help
Computer Science Assignment Help
DBMS Assignment Help
database assignment help
Economics Homework Help
English Homework Help
Excel Assignment Help
ReplyDeleteStatanalytica.com is a platform where we provide Statistics assignment help to the students around the world. Get Instant help from the statistics experts.
help with python programming
Statistics Assignment Help
college statistics homework help
elementary statistics homework help
business statistics homework help
statistics math homework help
probability and statistics homework help
ap statistics homework help
That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.
ReplyDeleteWeb Development Company Australia
I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. freelance sites like fiverr
ReplyDeleteNewly informative post. All about this post is something new info. mattress for kids
ReplyDeleteWe provide the best computer science assignment in the world with sophisticated strategies.
ReplyDeletecomputer science assignment help online
programming homework help at cheap price.
ReplyDeleteprogramming assignment at low cost.
ReplyDeleteUsually I never comment on blogs but your article is so convincing that I never stop myself to say something about it. You’re doing a great job Man learn Oracle SOA Online Training
ReplyDeleteVery interesting article to read it. I would like to thank you for the efforts you had made for writing this wonderful article. This article inspired me to read more. Keep sharing on updated posts…
ReplyDeleteLearn Digital Marketing Course in Bangalore with Live Project Work & Case Studies taught by Ranjan Jena (10Yrs Trainer). 100% Guarantee to Clear Job Interview.
SEO Course
PPC Google Adwords Course
Social Media Course
Google Analytics Course
Adobe Analytics Course
Graphic Designing Course
Thank you for sharing. If you are interested in purchasing Madden 21 Coins, you are welcome to visit GameMS.
ReplyDeleteThat's a beautiful post regarding "Null and Blank values in MySQL". I can't wait to utilize the resources you've shared with us. Do share more such informative posts. For more information regarding SEO and Digital Marketing Services Visit Digital Shout We provide marketing services to start-up's and small businesses looking for a partner for their digital media. We work with you, not for you. We are on a mission to build, grow, and maintain loyal communities.
ReplyDeleteThanks for sharing this information Freyr Energy was founded on the principles of making solar energy affordable and accessible for everyone. In order to make adoption of solar energy a reality at the grass-root level, we have identified that consumer awareness, affordability and accessibility play an integral role. With our innovative platform, SunPro+, our extensive channel-partner network and our efficient service we ensure that these three factors are addressed to make sure your venture into solar energy is hassle-free. Best solar company in Hyderabad-freyr
ReplyDeleteBest Digital Marketing agency in Dubai We are in an ‘ always on ‘ world. Connecting, sharing, collaborating. We, at ISD Global, help brands digitell the digital while distinguishing the distinguished and distilling the brand essence. ISD Global can evaluate the strength of your brand through a brand audit. The –––audit can be initiated before embarking on a Brand Engineering exercise or at any time that you want to establish your brand’s power/equity in the marketplace. The brand identity reflects stakeholder vision, the brand positioning and resonates with the brand’s core values.
ReplyDeleteThey screen and track the business drifts, contender's systems, check for the focused on watchwords - all which are expected to improve the natural query output postings of your customer's site. SEO Antwerpen
ReplyDeletei impressed blog nice article..
ReplyDeleteOur Informatica Developer Training will provide you to learn the performance of ETL tasks with live classes. ITGuru Informatica Online Training also include projects
ReplyDeleteonline informatica training| informatica course online