Member Avatar for prem2

Hi to all,

Example:
CREATE TABLE test(name varchar(20) NOT NULL DEFAULT '');

In the above query varchar is described as NOT NULL.Then why we are inserting DEFAULT value as '' (null).

Thanks in advance,
Prem

  • 2 Contributors
  • 1 Reply
  • 62 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

Crosspost. Already answered in MySQL forum.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.