Awesome q2a theme
+1 vote
17 views
can i take an id input as 5372A623Z with number data type
in Databases by (7 points) | 17 views

1 Answer

0 votes

Token consists of <Token class,lexeme>

One of the Token class is identifier. And it's lexeme must matched with Pattern.

Pattern for identifier is

Identifier = (letter)(letter | digit)*

Rules for naming identifiers

  1. A valid identifier can have letters (both uppercase and lowercase letters), digits and underscores.
  2. The first letter of an identifier should be either a letter or an underscore.
  3. You cannot use keywords as identifiers.
  4. There is no rule on how long an identifier can be. However, you may run into problems in some compilers if the identifier is longer than 31 characters.

Now we can say 5372A623Z is not an id

https://www.programiz.com/c-programming/c-keywords-identifier

https://www.tutorialspoint.com/compiler_design/compiler_design_regular_expressions.htm 

by (739 points)
0

he's asking in context of databases (SQL) maybe because he tagged it as #databases?

Since the question is unclear anyways, I think he meant to ask something like 

CREATE TABLE bruh(
    id NUMERIC,
    name VARCHAR(30)
);

INSERT INTO bruh(id,name) VALUES ('13DY2019F', 'bruh_name');

which shouldn't be possible. 

0
may be.
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Top Users Jun 2020
  1. vps123

    4 Points

  2. ummokkate

    1 Points

  3. Kushagra गुप्ता

    1 Points

  4. faseela45

    1 Points

  5. srestha

    1 Points

7,385 questions
1,744 answers
10,702 comments
90,357 users