Total Page Preview: 000000002779
What is Auto increment in SQL in English and Hindi
SQL auto increment in Engilsh
SQL autoincrement is a feature in database management systems that automatically generates a unique numerical value for a column when a new record is inserted into a table. This is typically used for primary key columns to ensure that each row in the table has a unique identifier.
Here's an example of how to use the autoincrement feature in SQL:
Suppose we have a table named "employees" with the following columns:
-
id (primary key)
-
name
-
age
-
salary
To make the "id" column an autoincrement column, we can use the "AUTO_INCREMENT" keyword when creating the table:
Now, when we insert a new record into the "employees" table without specifying a value for the "id" column, the database system will automatically generate a new unique value for us:
The resulting row in the "employees" table might look something like this:
The "id" column has been automatically assigned the value "1" because it is the first record in the table. If we were to insert another record without specifying an "id" value, the "id" column would be assigned the value "2", and so on.
SQL auto increment in Hindi
"Auto increment" ek SQL feature hai, jo kisi table ke column ko automatically increment karta hai, jab naye records insert kiye jaate hai. Is feature ka use mostly primary key column ke liye kiya jata hai, jisse har naya record unique identifier (ID) ke roop me pehchaan sakta hai.
SQL mei, AUTO_INCREMENT attribute ka use kiya jata hai, jo numeric data type ke columns ke liye hi apply kiya ja sakta hai. Ye attribute MySQL, SQL Server, Oracle, aur PostgreSQL jaisi popular database management systems mei available hai.
Example ke liye, hum ek "students" table ko consider kar sakte hai, jisme ek auto-increment primary key column "student_id" hai.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAosAAACxCAYAAACslPf1AAAgAElEQVR4nO3df3AU55kn8G+PfoykQTM2QcT6MUbEAoRg5YWK5UWUQDUSPrIp54hZ2KssIyVITrynkIM974FJIa8Hn4EkW1ZIWBdhIIFhqT27sFOkYrP2MAfmkMpiE9sso8gGB4hGko3AsVoRotGP9/7odGt6ZlqagQEJ8/1UvYXU/fbbT/fI8Oh5+21LAASIiIiIiGKwTHQARERERDR5MVkkIiIiIlNMFomIiIjIFJNFIiIiIjLFZJGIiIiITDFZJCIiIiJTTBaJiIiIyBSTRSIiIiIyxWSRiIiIiEwxWSQiIiIiU0wWiYiIiMgUk0UiIiIiMsVkkYiIiIhMMVkkIiIiIlNMFomIiIjIFJNFIiIiIjLFZJGIiIiITDFZJCIiIiJTTBaJiIiIyBSTRSIiIiIyxWSRiIiIiEwxWSQiIiIiU0wWiYiIiMhUalJGsTmA9fuAgjnq9/JV4EdrgJ4OYG458J0fA9ZM4zGBg8Ar29Wv1+0GShZHjxs+DjA61ke/BX7yndF+ZscDgDIA7P4fwPwlgGuN+f7fNY99jYtXAmueM98ffj1mceY4gacPAvYvGI9tOzXaTzv2le3AqcPR5zG7n5ExTEIejwfr169HU1MTGhsbJzqcm+L1elFXV4djx46hurp6osMhIiK6I8QttRynwI4TAut2j25btUndluMUmFsu8IO31T+1/XPLBZpOq/0A9djw483aqk0CL50dHdusz/cPC9gc8W2/mRbrmuKJU7tXi1ea3wvt+/A+iZw7ic3r9QpZloXb7U7KeB6PR8iyLDwez6SO06y53W4hy7Lwer23/d6zsbGxsbFNlnbr09CVfwfIV4B9/2t02+svqdsq/y72Mb9rVqtmD8yM/zw2BzD7EeDXL6nfzy67+Zhvp0Tj/F2zWoFM5F7QhNi0aRNkWcahQ4cmOhQiIqI75taSRS0x+vA00N87ur2/F/jfK8eeEn1gJmCfpo4RjwfnAdYs4J0jQKgdWPjYLYV+2yQaZ44TKCgGfvvmnYnvz7xeL4QQhhYMBgEAfr8fQgjU1dUhOzsbBw4c0Pt4vV79eFmW4Xa79TGDwaA+BgC43W7IsqwfW1VVFRWHx+OBoih6H7/fb9jX09ODI0eO6PtDoRBcLlfccY53rfFyu91wOp1ob29HIBBI6FgiIqK72a0li1l2NeHrOpfYcXPLgYcWGpPMksXAS2dHW9NptZ9m/hJAuQZck9XEKpFEU1MwB/jRKeN5Fq9MbIzxxBPnmudGz//9V4FfPBP7+UQz6ZnA935mvI51u+M+3OPxYPXq1di6dSskSYIkSfB4PDh8+DBcLheqq6shSRL27t2Lvr4+1NTU6P3q6+vjOofb7cauXbvQ0dEBSZJQVVWFGTNmwGq1GuLYuHEjfD4fJElCTU0NysrKDIme3W7HQw89pI8BAJs3bwaAuOIc71rjNWvWLFitVly8eDHuY4iIiD4PkrPAZTxachMucjFG+CKPSJEVzA9bgf9Sr1bxxluYEi70AdC01lgFTaZ44zz47GhyqC16+Y834l+cciPORTkm8vLyDEkbADz77LM3NZaZpUuXAgC2b1evKRAIYN++fVi/fr3eZ+XKlTh//rye2Pl8PtTW1mLRokV6H0VRcPjwYX2M9vZ25Obmxh1HMq9VURR0dXXd1LFERER3q1urLF6T1WcT82aN3e/GALDz28DTi9WEre1UYqt2H5wH5DyormZ+6SzgeUNNsuYvuaXwk+5m4uzpUBPF2Y8kXim9SfX19Th58iS2bNkSc3o3GQoLCyHLMjo7O2Pud7lccDgcKCkpMUwPV1VVweFw6LEoioJz5xKsXIdJ5rVarVbk5eXddCxERER3o1tLFvt71SpaZKJjcwDfPwys2hTd/9V/VqegE5n+nZoL9PxBTTb/fr7aAgfvaIIVl1uJ0z5Nnda/A9xuN06dOqVPy0qShN7eXhw4cCBpCePFixdht9uRn58fc38gEEBvby+OHTtmiEOSJBQUFCTtucBkXeu5c+egKAoKCwuTEhcREdHd4tZXQx//VzXRWfuD0W1rf6BuO/6v0f21ldCrNhmfSRzLwseiF9GcfRtw5KjVvMniZuLMcQJf/oq6GEZ7n+Rt5HK5sG3bNjQ2NhqeDezu7o7qq025zpoVXTnu6uqC1WrVp5s9Hg+Kior0/SdOnACgriDWzrt27VrDlHBLSwsqKirg8Xj0PqFQKOHKn1mciVzreHw+Hzo6OlBcXJzUCiwREdHd4NbfwWNzqO8wfOms2sLfZxjrvYBa/6bT6vZ1u0ePDW87Tggs+q+x3zuojRH5fsax3rMY6xxaDIlc71jvjhwrTu09i5ExhF+DNk6sWBevHHu/9q7GOJrX6xXhQqGQcLlcUf38fr+hX/g7BsPHCIVC4qOPPhLBYFDfr72XUHPq1Kmo9yx6PB6hKIrex+/3G/b19PQY3p/o9/sN50g0zrGudbzG9yyysbGxsd2LTfrzF0QUB/4fXIiI6F7DZJGIiIiITN36M4tERERE9LnFZJGIiIiITDFZJCIiIiJTTBaJiIiIyBSTRSIiIiIyxWSRiIiIiEwxWSQiIiIiU0wWiYiIiMgUk0UiIiIiMsVkkYiIiIhMMVkkIiIiIlNMFomIiIjI1D2ZLLrdbsiyDK/XO9GhxOTxeCDLMjwez7h9/X4/QqEQXC7XuH2nS1l4z1aLgewNUe09Wy2mS1loSF+gf61ZljpD37Yzoyrm8QPZGxCa8hRKLTlxX6fL5UIoFIIsy3C73VHb/X5/1LXKsoxf/vKXUBQFQoiYLRgMGo7RtkeeZzzhx0Y2LbZgMBh1/yM/E+16YsWh/SzGew3hTVEUeDweeL1eQ0zhx4THGWsMLRbt3obfH6/Xq28zOz48jnHNLQeaTgMvnTW2dbtH+6zbHb1/xwkgxwnYHMD3D0fvf+msOu7c8tFzhI+5eGX0ecLjMdseeY5Vm0Zj1M4XLsepxho5Xgyx/g7Stmn3c6zP/e2334aiKIafE43f74//MyEiipOY7M3tdgtZloXX652U493uccdqfr9fhEIh4XK5Ejqu1JIj3rd9U5RacgzbG9IXiIHsDWJnRpW+bVnqDPGerVZMl7Ki+r6WuULYpLSbit3j8QhFUYQQwnDPXC6XCIVCwu/3R12rLMvC7XbHdc8j702s4+NtwWBQBIPBmNuFEIZYw8+rxRd+bHgcseKPPGa8z9jr9QohhKFPZFxm8YfHJIQw9PF6vTHv183+zGFuucAP3lb/1LblOAV2nBBYtUn9ft1utYUft2632ifHGX3c4pXR52g6bey/apPAS2ejx9W2R44dK05t3PHi/P5hAZtj3HsR+blrP/ORP69j3WePxyNkWRYejyfqv6k7+XcQGxvb57/dk5VFGtuHI3/E0hRnQlXCm1FeXo7z58+jra0NixYtSurYHo8HZWVl2LdvHwKBAADghRdegCzLqK2tTeq5rl69irKysphVy9raWsiyjHXr1unbxovD5/Ph5ZdfhsPhiKtiDAB9fX2wWq3Iz8+Hy+VCRkYG+vr6ErqOvr4+OJ3OO1uR6ukA/uMNYPYjauUwln97HlCuAdOc8Y15Y0BtWv8HZgJXQsY+Nod6zl+/pH4/u2zsMX/XDJw6rI4FAP79wEML1aoloFYZnXOBV/8Z6O+NL84wP/nJTwAANTU1+s/reBobG9HR0YG1a9fqPycrV67E+fPnUV9fn3AMRERmJjxZjDUNp019eTweKIqCAwcOIDs7G3V1dVHTdOFTZZpgMGiYnomcBly/fv24ccQ6/siRI3qf8GmeeOIcT2SMZtNI2pSjdp/uv//++G50Ak4Md+DEcAfq00uTPrbG5XKhuLgYLS0taGlpgdPpTGiKeDx5eXkAgHPnzunbAoEA2tvbkZubm7TzAMAHH3wQM/lbsGABiouL0d7ebkgAAoEACgoKUF1dbTpmYWEh7HY78vPz44pBURQoioJZs2ahsrISANDT05PQdXR0dKCjowMrV65M6LjbbpoTsE8Dpsb5uV3vV9vUXHVq2D4N+EObsc+D8wBrFvDOESDUDix8bPxxH5ipjmVzjCaPX/seMGMe8MT/BE6/rm5PUDAYhNPpxDPPPBN3oqjZvn077HY7Nm/eDK/XC6fTie3btyccAxHRWCY0WXS5XNi2bRtaW1shSRIkSUJNTQ327dsHQP3N2Wq1oqamBn19fdi7d6/eb968eXGf48CBAwCAqqoqSJKEjIwMZGdn633cbjd27dqlx1FVVQWHwxH1zFxlZSUaGhogSRJOnjyp/0afjDi1BEKSJGzduhWKokT18Xq9qKur08dvamrC/Pnz4xo/Ud4bZ25rdbGyshJ2ux1dXV04ceKEnugkS2FhIWRZRmdnZ9S+RCp28RgYGMDRo0ejqovTpk2D3W7HxYsXExrP7XajrKwMHR0d8Pl8AID8/HwcO3bM8EtV+PNuWrJYXl6OvLw8XL9+HdevXzeMW1JSMu6zhocPH76z1cUcJ/DlrwAfnjavyFXXqpXFD1vjH/fyJTUBnOZUj1X6jfvnL1G3X5OB3745mgSamVuuVhLD43z9JUC+Amz6P+rxx/81/vj+bMWKFSgpKcHLL7+sf9bhxvvctSp0VVUV6urq0NraGnMcIqJbMaHJYn5+Pux2u2Gbz+fD+vXrk/YXnpaUhE9Hbt++3TBFp00VvvDCCwDUxO3o0aMoLi42JBXhfxE3Nzfr0353yqJFi9DW1qZPMTU2NuLkyZO35VxnRnpua3WxvLwcsizj+PHj8Pl8uHz5MsrLy8c/cJI6dOjQLU1xh1ejDxw4gI6ODsMvGp2dnfovO1qLnGpsbW1Fbm4uCgsL0d3dHXWOtrY2w/FWqxWNjY2GPtrU5m2rLqZnAt/72eiiEc8b6jT0K2HVsJLFxoUlBcXAj9aoU9bxajulVg7zZ6tJ4UBYsqhNQWuJ34etat8Hw36xi4zzez9TK4nhcfb3AscPqV8f2ZlYfH+WnZ2Nvr4+rF69OmZlPZ7P/dChQ+js7ERnZ6f+dxgRUTJNaLLo8/nQ1NSEioqKxFdWxinWdGSk3NzcqN/g6+rqoqYBE60QJZPL5YLD4YiZBNwuWnVxoeWBpI6rTUGH3/OSkpKo5PxWXLx40XQat7e3N+HpvvFov2CUlZXpjwZcuXIFsiyjsLBw3OO1anFbWxs6OzsNzzjG65NPPoHD4UBxcTGamxOfDtVo1cW5c+fe9BimbgwAO78N/P380fZKxLRp2yl1+8FnAWUA+MUziSdiV7vUBPDRx9XKYbgH5wE5DwKuNaMJa45TrTZGxvn0YiD0gRpTZJwA8Gk30Pep+udN8Pl8WLFiBWRZxqZNm25qjEAggN7e3tvyc01EBEyCZxbz8vJgtVr135p9Ph82btyYtISxq6sLAMac4uzu7o6qukiSBLvdPmmmdLR/EJL9vN1YtOriP1mTW/HLz8+H1WrF1q1b9Xu9detW2O12VFZWjnmtZlPLkWJ97lqSersSbq26uHDhQgDAu+++i/b29qgk2OzVQIDxGbRE/eY3vwEA2O32MX85Go9WXZzwSu+pw8BHv1WfBxxrijiWqyF1ijjnwehEbmou0PMHNRHUEtbAwdiLbPp71UUr4YtZkiwQCGDfvn0oKiqK+TNBRDTRJjRZ9Pv9qKurMywC6erqinper7Oz07RC09XVBavViqVLlwJQF5sUFRXp+48fPw5Zlg0rBjdt2mR4ZrG5uRlFRUWGZ4GCwWDC7+UbK85kaGlpQUlJiR6nx+NBRUXFbTmX5nmlBR+MfJrUMZcuXQpFUXD8+HF9m/Y5aQlKS0sLioqKDIuIKioqohaLmGlsbERra6vhc9+8eTPsdjv279+f1OvRaP/o37hxQ9+2f/9+2O12fbUroK58NYsj/Bm0RN8D2tnZid7e3rgT6rFEPqoxYf7tefV5wLU/SPzYjy+oU9BXIqqSCx+Lfkby7NuAI8c4Fa3RFrOs2hT9bsUk0R4pqaiouC3Pi2rvbIx3wR0RUbgJTRarq6tRU1MDp9OpT/9u3LgRTU1NhmeptH+Ew6ertb/0Ghsb4fP59Ge+1q5di1AoZDi2pqYGAPQpz+vXrxv+IWxsbER9fT1Wr16tjw8g4criWHGOJ3w19JYtW5CdnY0tW7ZACKG/4Lm+vh579+7Vr3X9+vU4e/Zs3PGFv5T7HdsazLbcj3dsawwv5Y50WVzDnsEzcZ8jnutcvnx51JSZtlJZWyRSX18Pn8+n34MtW7bg5MmTY64gjlRdXY329nb9cy8rK0NDQ0Pcn2n4S5FLSkoMC0TMKkCNjY04f/68/r02zehwOPRjHQ4HVqxYYRpHfX092traUFdXpyeMsRY6xHpko7u72zShjlzgMtaLyn0+H1pbE1hQcrv0dKjPA5YsBtbvHX0pt+cNwP4FYM1zxpdyh+s6p650Dp/C1haqdEVUXv8QBHp71MU0sbz+klqN/M6Pb1vCWF1djfPnz2PLli0Jf+5ERLeTBPWFi0RE9Dmm/YKTyC9cRETAJHhm8V4S+b9MS3Sam5KPnwndC/x+P8rKym7bIxhE9PnGyiIRERERmWJlkYiIiIhMMVkkIiIiIlNMFomIiIjIFJNFIiIiIjLFZJGIiIiITDFZJCIiIiJTTBaJiIiIyBSTRSIiIiIyxWSRiIiIiEwxWSQiIiIiU0wWiYiIiMgUk8VxTJey8J6tFjszqqL2NaQvwHu2WkyXsvRty1JnYCB7AxrSF0T1HcjeYGihKU+h1JJj6Kcdr7XwcRrSF+C1zBWwSWmG/pEx2KQ0vJa5Imo7AOzMqIqKI1Y/AHC5XAiFQpBlGW632zTGWNdSaslBaMpTMa8jfOxQKASXyxV1biIiIpo8BNvYrSF9gXjPViumS1n6NpuUJl7LXCEa0hcY+u7MqBID2RvEa5krhE1KM4wRa1toylOi1JIT8/vpUpZ4z1arnyPWGMtSZ0TFVmrJEaEpT4mB7A1iWeqMqPh2ZlRFbYscA4Dw+/0iFAoJl8sVdT8ixwhv2vm1c0deR3gLBoMiGAxO+GfMxsbGxsbGFruxshiHk0MhTJMy8XDKaOXsIek+fMlyH04OhfRt06Us/IVlGr59/U18yXIfHpLuG3PcXwyexenhj/FFSxamS1l4Mq0U37r+Bs6M9AAALotr+EflOJ5MK41Z+TNTkVqAV4fOYc/gGTyeWjRu/+eVFvxRXMcDkk3f5vF4UFFRgaNHjyIQCEQd88HIp6bj1aeX4tWhc3hr6NK413H48GE4nU54PJ54L4+IiIjuoAlNFrWpyCNHjkCWZQghoChKVOLg9/shhNCb1+s1HH/lyhUIIRAKhXDq1Cn96/DpzfAxYp1jLB+Jz3B6+GPMtkzVt1WkFuD3I5/hI/GZvu3hlBx8JhT8+9AF/H7kM1SkFow5rg1pmGlxYLZlqp6Ivj/cY+jz1tAl/GX/flwW1+KK1SaloTplBn41dB6/GjqPJSkF4yaaD0g2zLLcjy9aRvuVl5dDURScOHEiqv8cy1SUWXL1aebwKWiblAanlB2VTGrXFZ5wA8Dx48chyzLKy8vjuj4iIiK6syZFZbGyshINDQ2QJAknT57E2rVr9UQvGAyirKwMNTU1kCQJx44dw+rVqw3P0H3yySeoqlKfKRwYGEBNTQ2sVisqKysBqIli+Bg+nw/r1683jDGWfjEI//AlVKfMgE1K0xMy//Al9ItBvd/jqUXoEH24LK7BP3wJc8KSy1hWpc3BNCkTJ4dCmG2ZigsjvejH4JjHLE+diStTvqs/C3gk8wnDfq3i+cnINbw/3BNVMYylPr0UV8SAIVHNzc2FLMvo7Ow09NWSQbuUjjn9e5HZ9yK+df0NvJ61EqWWHD0B/jAiWezHIC6M9BoSbgAIBALo7e1FcXExn10kIiKahCZFstja2gqfzwcAaG5uhtVqRX5+PgBg3rx5sNvthv0AMGvWLP347u5u/euLFy8CAKxWK/Ly8uB2u1FWVoaXX35ZH+PQoUOQZRlLly6NO8aTQyF9atmGNNwnWaOmoJekFOBXQ+f1/n9hmWao6kUmes+kP4q/vnZYn3aOx9GhC5j2p58is+9FZPa9iK8NvGrYH17xvCyu4T9HrkRVOJ9MKzUsTlmSUoDHrr0SVb3s7e2NmoLuF4P4+sAv8fWBX+qJ8ltDl/Dq0LlxK6lERER095kUyaKW4Jlxu936NPWWLVtgtVrjHnvWrFmwWq2oq6vTp6GPHTuG/Px8FBYWxj3OR+IzfWpZm26OnIKeY5mKI5lPYCB7A96xrcFfpeQZpl21RO/R/oO4KgYMzyd+OPIpZlocsCEt6tzx0iqe4Unpk2mlekVUs2fwjJ5oXhUDqBl4PeY0t8PhiLva98HIp5hjmWpaQTSrOBIREdHkNimSxbEEg0Hs2rVLn6beunUrFEWJ+/hz585BlmVs3boVkiQZWnV1ddzjhE9Fr0mdFzUFPdsyVU/CtGa2wOTMSA+23XgHP7RW6pVHs2f6Yr0ax4xW8Xy0/6Aew6P9B00X22gVweesiw3JJKBWa+12u17h1cR6XRCgPsf4wcin6BeD6BB9UVPwZs9kulwuOBwOtLe3x1xIQ0RERBNrUieLWiIRPk1dXl6eUGXR5/Ph8uXLhucgPR4PFEWB3+9PKJ6TQyE8kvIAqlIfNExBhy8qCTfWApNfDJ7FhZFe7M54DDYpDZfFNewZPIOfZ3xFXyxSasnBzzO+gj2DZ+Ja4BKr4hleEY3leaUFMy0ObLMuMWzXHgeInKqPjBtQE8glKQV4ZfADfcwlKQVYljoDgDpF/0NrZczrqKyshN1u1x8viKQtTAoGg+NePxERESVf6kQHMJZAIIB9+/Zh48aNEEIAUJOYnp4erF+/Hmlp8U3Zzps3D36/H8eOHQMA3LhxAzt27EBjY2NC8WiromdaHPhY9Ovby1Py8EjKA/hEMSZCWhVtVdqcqLH6xSCeVU7h9ayVOJjxVay5/mvsuvEuPhz5FO/Y1uj9vjbwqv4KmrFkSan472kL0CH6DBVPrSL6ZFqpnsyF015roy2U+d519R41NjaivLwcy5cvh8vl0qt+/WIQa67/GgczvoorU74LQJ2CDn/m8bK4hseuvYI3s1ZhTqZaYXxaOY5dN96NOv/KlSvR0dGR8GdBREREd86Ev+yRbXI2l8slQqGQkGVZuN3u2zJ2rJd+Rza/3y/8fv+E3w82NjY2NrZ7sUl//oJoUtJee9TQ0KA/ikBERER3DpNFIiIiIjI1qRe4EBEREdHEYrJIRERERKaYLBIRERGRKSaLRERERGSKySIRERERmWKySERERESmmCwSERERkSkmi0RERERkiskiEREREZliskhEREREppgsEhEREZGp1IkOYKLZpDQczPgqlqfOjNp3VQzgr68dBgC8nrUS37r+Bt4augQAmC5l4c2sVfhH5TgA4EjmE6bneFo5jl033r0N0RMRERHdXvd8stgvBvH1gV8CMCaAWlIIAKWWHADAD62VeGz4FVwW1wxjvDV0CZl9L+p9fZlfhXvg1zgz0nOHroKIiIjo9uA0dJyuiuuQIGFV2pyJDoWIiIjojpnwZNHtdkOWZQghIIRAKBSCy+Uy9PH7/fr+YDCoN7Mxwvcly6diAD+6cRpPppViupSV9PGJiIiIJqMJTRY9Hg+8Xi9aW1shSRJqampgt9uxefNmvY/f70dZWRlqamogSRJaWlpQUlKi73e73di1a5c+RlVVFRwOB/x+f9Lj/X/DIVwY6WV1kYiIiO4ZE5osNjY2wmq1orq6GgDg8/nQ0dGB3NxcAIDL5UJxcTFaW1vh8/kAAIcOHUJnZ6c+Rm1tLWRZxgsvvAAACAQCOHr0KIqLi6MqlLeqXwziXwbfxZNppfgiq4tERER0D5gUC1z8fj+qqqr079va2gAA+fn5sNvtuHjxor4vEAigt7dX/z43Nxf5+fk4duyYYcy+vj7k5+cnPdbm4S5cGOnFf0ubm/SxiYiIiCabCZ+GVhQFACBJEiRJ0hNFAOjs7IQsyygsLNS3uVwuOBwO/fvu7m60tbXpx2vNbrfr1chk0qqL/5D+ZcyxTE36+ERERESTyYQmi3l5eVAUBfv37wegPn/odDr1/YFAAO3t7SgrK4Pb7QYAfOMb3zBUDJubm1FUVASv16tvCwaDkGVZPybZ3hq6hD2DZ27qWK/Xa7qQh4iIiGgyEhPZgsGg0MiyLI4cOSKEEMLv9+t9/H6/3icYDOpN2+92u4Usy4Y+8Z7fJqWJ1zJXiIHsDVEtNOUpUWrJEaWWHPF/s/5WTJey9ONKLTkiNOUpsSx1hmG8UkuOeN/2TVFqyYl5Pq/XK4QQIhQKCZfLNaH3no2NjY2NjY0tjjbhAZg2LQn0er36NpfLJUKhkCGZvNua1+tNKKFlY2NjY2NjY5uoNuHvWRyLtjp69erVhmnonJwcNDc3T3B0N8fr9cLtduPw4cMTHQoRERHRuCSoWeOkFgwG9Xcr3rhxAzt27EBjY+MER0VERET0+XdXJItERERENDEm9TQ0EREREU0sJotEREREZIrJIhERERGZYrJIRERERKaYLBIRERGRKSaLRERERGSKySIRERERmWKySERERESmmCwSERERkSkmi0RERERk6q5MFoPBIILBoOl+v9+PUCgEl8t1B6O6eTYpDa9lrsBrmStgk9IM+5alzkBoylMoteTo20otOQhNeQo7M6oMfbXtA9kbDK0hfYGh33QpC+/ZavX94edtSF8QFcey1Bl4z1aL6VKWYZydGVVRsWljRMYQqx8AuFwuhEIhyLIMt9sd8/40pC+IutZY1xt5nVqM2v5Y1+DxeKAoCvx+f8xzExER3evuymTx86ZfDOJfBt/FIykP4CHpPsO+x1OL8OrQOZwZ6dG3VaQW4AtSJpakFEQlP1fFdTzafxCZfS8is+9FPNp/EM+kP6onUqWWHPzWVoM9g2f0Ph2iD72sd/QAAAp+SURBVAczvhqVqI5lupSFJSlqHBWpBVH7jw5dwLQ//VQ/x7Yb7+D1rJVRCePmzZsBACtWrIDP54saxyaloTplRtT2UksOXs9aiW9dfwOZfS9ixp9248m0UkPCuDOjCk4pW49jz+AZvJm1ynDPGhsbUV9fj7KyMni93rivn4iI6F7BZHGSeH+4B1fEgCHx0hKyXw2d17dpydO3r78JAHg4JbpaF+7MSA+23XgHcyxTAQD16aV4degcdt14V+/zvNKCmRYHylPy4o734ZQcXBjpxT8pzahOmTFuovmLwbM4PfwxvmgZTdQ8Hg8qKipw9OhRBAIBQ/9lqTMwkL0BV6Z8F8tTZ0aNp13HW0OXAACXxTX8o3IcT6aVYrqUhVJLDpamOPGscgr9YlCP4cJIL1alzTGM5fP50NraiuXLl9811WgiIqI7ZcKTRbfbDVmWIYSAECLm9LHf7zfsz8jIMOz3er36flmWcf/99+v7tGlGIQQURYHX69XPF36uyDgip7kj92vnCp86DY9Ta/FOb14W1/D2cEhP6oDRRPD94dGq4kPSfbhPsuLfhy7g7eEQHk8tGnfsOZapcErZKLQ4opJP7dx/2b9fT7zi8XhqEfzDl/DG0O/xJct9URXRSDakYabFgdlh11deXg5FUXDixImo/m8NXdKrknsGzxjHktLglLLxwcinhu3afXo4JQdftGRBQOBj0a/v7xeD8A9fipncNjc3w263o7KyMr4bQEREdI+Y0GTR4/HA6/WitbUVkiShpqYGdrtdn5oE1ASsoqICW7duhSRJOHr0KL70pS/p+71eL+rq6rB3715IkoSmpibMnz9f39/Y2Air1YqtW7cCAFavXo2GhgZIkoSCggIEAgG43W7s2rVLj6OqqgoOh0NP9FwuF7Zt26bv12Ldt2+fIY6ysjLU1NTofX784x+jubk57vvxq6Hzhqnlx1OL8PZwCJfFNb1PRWoBPhMK+jGIXw2dh1PKHrOqV2rJwROps+AfvgQ70iFBwicj10z7A8Dy1Jm4MuW7+rN+RzKfMOzXKp4fjnyKj8Rn+P3IZ4aKYSyr0uZgmpSJk0MhfVtubi5kWUZnZ+eYx0bSEs8PI5LFfgziwkgvZlumYrZlKi6M9KIfg4Y+H458ipkWB2ww3rNz584BUBNYIiIiGpU6kSdvbGxEY2Oj/r3P58OmTZuQm5sLQE3SiouLcfLkSb1ffX09Fi1apB+zaNEitLW1ob6+Xh+zvLwcxcXFUedTFAVNTU1Rz8bV1tZClmW88MILAIBAIICjR4/q05L5+fmw2+2GY3w+n2GcwsLCqPOtX78+ofsRXhlrHu6CU8rGvwyOThdrU9D+4UvoF4N4f7gH96Vb8ZB0H84I9dgvSBl4x7bGMO7TynHsuvFuzAUmsRwduoA113+tT98uS52BH1pHK27hFU+tWvd4apGhMqklnJqrYgB/fe2w4dlLAOjt7Y2agiYiIqLJY8KnoQHj9G1JSYm+XUvSLl68GPM4l8sFh8OB7u7uWzp/bm4u8vPzcezYMT2Ouro62O125Ofnw+fzoampCRUVFfp+RVHg8Xj0Maqrq9HR0YEDBw6YTmWPR5uKfjy1SJ9ujpyCfiTlAfzIWomB7A24NOU7+KuUPMNzjtoCl2l/+imODl3AnsEz+vOJH4t+CIhxq4DjeTy1CHMsU3FpyncwkL0BP7JWRi220Ra4PNp/EFfFAL51/Y2oRBEAHA5Hws8JhlcQw4VXHM0qiGYVRyIiIoptwqehFUUBAH3qtq2tTd/f2dkJWZZjVu0AtQLY29urVyJvVnd3N9ra2vQYtGa32/XqYV5eHqxWq77P5/Nh48aNesK4YcMGeL1efb82lZ1owqhNRf9tWjH+c+SKYQr6i5YsnB7+2LDK+GnleMxn8PrFIJ5VTuGJ1FlYlqquJg5PRsNpr9LR+o1Fe17wawOv6jHM+NNuALEX22gLbH5orYxaud3d3a0n5InoF4PoEH2G5zvDz//+cA8+GbkGCRIekGyG2MMrs+FmzZoFAAk9NkBERHQvmNBkMS8vD4qiYP/+/QDURSROp1PfHwgE0N7ejoqKCj0p83q9hupjS0sLSkpK9NeeaCtsE9Hc3IyioiLDq1OCwaC+gMXv96Ours6Q+HV1demJrtvtxnPPPYft27frcWqJbKK0SuI/pH85aiGKtqgkPNE5ORQyXWCiJWo/z/iKPgXtvXEGT6TO0l8xY5PSsDvjMVwY6UXzcNe48cWqeJoloRptFfLujMcMSW1zczOsViuWLl067nkjPa+0YElKgZ7gTpey8ENrJfYMnsFlcQ1nRnrws8H38Zx1sX7Ob6bNx0yLA68MfhA1Xnl5OWRZxvHjxxOOhYiI6PNOTGQLBoNCI8uyOHLkiBBCCL/fr/fx+/16n1AoJD766CMRDAb1/V6v1zDGb37zGxEKhYTL5RIej0coiiIiafu1Mdxut5BlWd8fPn6s/YqiCI/HY+gTHmesMeJtOzOqRGjKU6LUkqNvK7XkiNCUp8Sy1BmGvjYpTbyWuULszKgSpZYc8b7tm4bjtP3h402XssR7tloxkL1BDGRvEDszqvT+DekLxGuZK4RNStO3LUudId6z1YrpUpbYmVEVtV/ro50j1hha/JHb/X5/1GehjafFF960OGJdR0P6gqh72ZC+IOaxsT5br9c7of8tsLGxsbGxTdI24QGw3cPN5XKJUCgkZFkWbrf7jp9f+2Ui/JcTNjY2NjY2ttEm/fkLIiIiIqIok2I1NBERERFNTkwWiYiIiMgUk0UiIiIiMsVkkYiIiIhMMVkkIiIiIlNMFomIiIjIFJNFIiIiIjLFZJGIiIiITDFZJCIiIiJTTBaJiIiIyBSTRSIiIiIyxWSRiIiIiEzdcrIYDAYhyzLcbncy4iEiIiKiSUQCIG51EL/fj+LiYtTU1CAQCCQhLCIiIiKaDJIyDb1//37Y7XZ84xvfSMZwRERERDRJJCVZ9Pl86OjowKJFi2Lu93q9EEIgFArB5XIl45REREREdAckbYFLd3c3nE4nn10kIiIi+hy5I6uh6+vrIUkSCgoK+EwjERER0V2Er84hIiIiIlNJWQ0NqK/QAYB58+YlYzgiIiIimgSSUll0u91wOp1oaWmJuZ8LXIiIiIjuTklJFmtrayHLMg4dOpSM4YiIiIhokki91QGCwSCcTicaGhpMF6/U19cDABYtWsQFLkRERER3kVtOFuN5RtHr9cLtdmPHjh23ejoiIiIiuoOStsCFiIiIiD5/+OocIiIiIjLFZJGIiIiITDFZJCIiIiJTTBaJiIiIyBSTRSIiIiIyxWSRiIiIiEwxWSQiIiIiU0wWiYiIiMgUk0UiIiIiMsVkkYiIiIhMMVkkIiIiIlNMFomIiIjIFJNFIiIiIjLFZJGIiIiIYkpPT2eySERERESxzZ8/n8kiEREREcX2N3/zN5AAiIkOhIiIiIgml4ULF+LUqWZYFi5cONGxEBEREdEksnDhQvh8BwEAKb///YV/stmy8Mc//hFXr17F8PDwBIdHRERERHdaeno6Hn74Yaxbtw579nhx//33AwCkgYHrnIYmIiIiopj+P9zUxq/7dFERAAAAAElFTkSuQmCC)
Is table ke saath, har naya record ke "student_id" column ki value apne aap increment hogi, jis se har record ka unique identifier banega. Is tarah, jab hum naye records ko insert karenge, to "student_id" column ko explicitly set karne ki zarurat nahi hogi:
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAokAAACFCAYAAAA3imJzAAAgAElEQVR4nO3dfXRU5b0v8O/wFkJCJiAIIUSgKCLQWIhFHQ6StXm5iVoXbURZ5zDEa2i9Fov2SC3GY1gMVThHavFteW0nVhJuF1bjOYtTJYuGWaGuRI0XuKYMIkoBMwECaWSGhMmEyr5/PDyzZ+89k8xbmKDfz1rPSma//vbME/ZvnpeNxe/vVgHgn+4oBhERERERAAxKdQBERERENPAwSSQiIiIiEyaJRERERGRikWMS09OHpzoWIiIiIhog2JJIRERERCZMEomIiIjIhEkiEREREZkwSSQiIiIiEyaJRERERGTCJJGIiIiITJgkEhEREZEJk0QiIiIiMmGSSEREREQmTBKJiIiIyIRJIhERERGZMEkkIiIiIhMmiURERERkwiSRiIiIiEyYJBIRERGRCZNEIiIiIjJhkkhEREREJkwSiYiIiMiESSIRERERmTBJJCIiIiITJolEREREZMIkkYiIiIhMmCQSERERkcmQpB4twwo89jow8UbzuoAfeO1R8ftDLwBvbQYaasTrsXnA2u3Azhe1ZcvWAcoKbX/XdrFPuHXGc7S3iONlXaNff6gBeOkh4CabiCEtPfx1yO16I2M2ngMAfH8HtqwACv8FuKVY/H62RaybVwLcs0YsW/5vwIx54Y8vr+XTRvO5Qt+LAayurg7Tp0/HypUr4XK5Uh1OzBRFQVVVFbKysrB69WpUV1enOiSKkt1uxyuvvII//vGPWLVqVdhtBmr9dDgc+OUvf4n3338fixYtSnU4RPRt5vd3q35/twoguWVsnop/36tiXol++U02FVs/FuvG5oXfdtm68OufqlGRYRXr5e/Rnlsu+9lr0cUZS7nJpuI//iJ+hi5ftk7Fqwf155xXor+20G3DXZMxPvl62bqkfl6Koqgej0etq6tL2jHr6upUj8ejKooyoOO8kvGzXJlit9tVn8+nOp3Oq/LzjSZ+FhYWlv4uqelu7vEDFotoaTMamyda33a+qLW+nW0B3nhS/D5mYnznPNsijpk1RrR4XinnO4C8m0TrZTyW/xvgOay1sMrruKVYvFfULxwOB+bPn4/a2toB1cpE3w7V1dVoampCUVERFEVJdThE9C2VmiSxuwv4y5vhE50LPsDXDsxZol/+aSPwTAlwwh3/eSfcIJLEEVnxHyNWLZ+Ksqg09n0zrCLe08f0y480AYELwJjok8S6ujqoqqordXV1sNvt8Pl82LNnD3Jzc7Fw4cLgeo/HA0VRoCgKPB4P6urqgsdzOBzw+XxwOBzBZU6nM7ivz+fDqFGjTHG43W7dNna7Xbe/x+NBQ0NDcBu3W3ze0cQJIBhr6HUGAgFdnNGw2WwIBALYu3evaV1vcYZ7L+R7HbouEAjA5/NBVVXs3Lkz+LvT6QxuJ6850jmSobc4AfP7KWMd6HE+9thjvR7DWD+N6+RnZLweh8MRXB4uDmOcxv1jqZ+NjY3IyspCYWFh3O8bEVEiUjdx5a/1Ihk0tiZ2eYF3fg1MnQO8ehD4973hW8wm3ghsaRDbyDKvJPL5ZAul57DWQnml1G2LrzVxRJZIEk9+bl6XNgIYnRPVYZxOJ+bOnYuVK1fCYrHAYrHghRdeQGNjI6qrq5GVlYWFCxeitbUVe/bsCW4zceLEqFvRnE4nysrKUFlZCYvFgq1bt2LWrFm6bdxuN6xWKxYuXAiLxYKmpiZs2rRJ11KSm5sLv98Pi8WClStXIi8vD06nM+o4X3rpJXi93uC6hQsXorq6Gp9/HuY97EVOTg58Ph9aW1vDro8UJ4Bg8r1x40ZYLBZUVlZi/vz5pkRg69atqKysRGFhIVavXo09e/bg9ttvB6CNqWtqagpeh9VqNSUliegrTjkmM/T9nDp1KkaOHBk8xkCKE0Cwbg0fPlwXZ1/1c9WqVcFjjxw5EkVFRSguLobFYsHMmTMBaGMFq6urg5/73Llzg5+7w+HAfffdF4zTYrHA4XCgpqYmWMdjqZ9ymc0WZy8EEVGCkjtxJRYXfED9H8Qkjr8aWms+bQQe+774fdk6wLFL/B46YcPzGbD1QZFURrJigyhSNBNS+sOnjVpr4v7dV/z0kydPNi0L19KSiNtvvx2HDh0KThKoqKiAzWbD9OnTAYgbaF5eHrZu3RpM6LZt24bnn38ehYWFwWXnz5/Htm3bAIgut3Xr1oWNPxxFUWC1WuH1anXC5XLF3V3s9Xoj7ttbnMbJBnv37sV9992HCRMmBJcFAgF8/vnnmDBhgi4ZtVqtUBQFpaWl8Pl8ePbZZ4PXUVtbG+x+TEYXeF9xFhYWIisrC6+//npwm5qaGlx//fXB1wMpztC6tXnzZrzyyivBffqqn6HOnz+PJ5980hR7SUkJvvjii+AxqqurUVpaGkzsJ0yYgLS0NN0+69evD/6e7PpJRNTfUvsInP9XJ1oT5y+LvM1bm4GHZwHb14uWwlha47avF/seahBJ5etPJB5zvGRr4tTvRb+P7HqfcIN5XeAC0HEqqsMsWrQILS0tqKqq6pcuQXnzO3UqcjwTJkzAyJEj8fTTTwdjqKqqwpgxY3TJU2+td31xuVx48sknkZeXp+vOC+0ajYVM2MLpK87QbsWqqipdq1Y0cnJykJubiz179gSvo6ysDFlZWcjNzY3pWL3pLU75uYS2cn3++ecIBAIDPk7jvn3Vz2jOb7VaMWPGDF3dki2niqJg1apVeP/993V1PHQoRLLrJxFRf0ttktjlFa2Jc5Zoj3dZtg54qsY8uaTjlJjwEo8dvxLdtnc+nFi8iZCtibf/MPp9urwiSRw/Rb982lzR3dweXbf5z3/+czidTl0Xl9VqTVqi6HK54PV6kZMTufv75MmTaG9v13V5yxLpESXxKCgowNKlS4PH3rhxI+x2e8w34lOnTsWd6NTV1WHXrl14/fXXg92S58+fj/n8hw4dMr1XWVlZSXsUT19xnjx5EgBwww3al5QbbrhB11o2UOMMFU397Is8RugwB+NwB7vdjoaGBt06r9eLqqqqYKIYS/2U19PY2Bh33EREiUj9w7QbakRLn1T/f0RC99jr+kRxUSngPQt8GUdiI2cEKyt6H7fY33b8SjxDMdZ9Jk7X4h6bJ7ro/++uqMZW2u12bNiwAZs3bw6O4ZI3vFC93UjluunTpwdvdiUlJbpk4YMPPsCMGTN047Pmz58fXF9fX49AIIB169YFl8lB/rEkcL3F6XQ68eijj+puysaWr2g1NjYiLS0NCxYsiHnfnJwcfPHFF6ioqAAALFiwIOaWxMbGRlx//fW698btdpsm+8hJI/FMzukrzvr6evh8PpSUaH8zJSUlGDZs2ICM88EHHwx+7uvWrdNt01f9jMYHH3xgGgvp8Xjg8Xjw+OOPY9OmTaioqNC9F6Gtl7HWT5vNBp/Ph/r6+pjiJCJKmqQ+JzHDKp719+pBc9n6sXiO4E02FY5d+ucEymcnhj6r8Gev6fcPfdagfP5gpHNEevahPGa45yfG+pxEuV+4OORzEJetMz+X0fgMyNDlkZ79aDxXHM9IrKurU0O53W7TNvLZbFLoM+Tk8wmlhoYG1efzqQ6HI7i/0+kMrvf5fOq+fftMz6Fzu926bex2u27/cNsbn4kYS5yqqsb9rLlIz9HrK05jfG63W3W73WogEFAdDofqdDqD1x56LOP5wh0n0mcmjx3L9fUVZ7j3c+fOnabn9w3EOPft22eKs7f6Gbqut78Th8OhBgKB4Hpj3TQex1hPoq2ffE4iCwvLgCj99jBtFparvMgbujGZHWjFbrerHo8n6TGGJrNymcPhMH05SHWc37QiE9Er8cB4FhYWll4Lk0QWlqu3yBan/kgo5LFDW9Pcbndc/0tJf8bJwsLCwtI/xXI5QUR6+nAQEYWSz0GU4/taW1sH3P91TERE/YNJIhERERGZpH52MxERERENOEwSiYiIiMiESSIRERERmTBJJCIiIiITJolEREREZMIkkYiIiIhMmCQSERERkQmTRCIiIiIyYZJIRERERCZMEomIiIjIZEhSjpJhBR57Xfy+9UGgy6utm1cCLFsHvPYo8GmjWHaTDXjoBeDofuClh8zH8bXrlxvXH/kYeGuztnzZOuCWYmDLCqDwXwBlhXnfgF+LQR5n4o3mdTFSFAVVVVXIysrC6tWrUV1drd8gfyqwdjnwRi3g2qdfV24Hbr5ev+yTL4BnDceIJH8qsOpu4JlqoK0j5tijUloM3Hmb9trbCTxd2X/nK7cD2ZmA4w2g05/0w784fCF+PDQfAPB31Y87L9Sg+dLZ4Pr8QWPx3ogSXGNJBwCsDdTjlZ4DSY8DQN/XmpkOVDwA1DaZ646sV2nDxGtjvZH7ThovXgd6gC07gOaj0cWmFAAP3QO89yGwbZdYJutC6LJYrhWIvm7HYtxoYGMZYM0Ur+Oto/I4DQdN1yf/zgHw/64mom+N5CSJXV6g/g8iWbtupj7ZmrNEJIOhy2bdAaSlAxOnA2PzgLMtSQkjyPOZOVmVQhPRh0vEsnklwJrfAq7t+uQzCuXl5QCApUuXRr5xdF8E2s+ZlxtvmPJGOtCcOK0lMqXFwHMPx5ZwxOpcZ78liHmWkRjT+TK61ItYPWw23htREkwUZYL4P7t34c//OIFrLSOwe8QyAOi/RLG3a/3OBGD8aPNy4xcPmdyU20WdkgniuU7gifViH6VA7BPr5zZzsjhepx/IHRP79Un9kRwC4RO70mLgxUeB13ZqybVSACxXokseW86YFrlcLkycOBFutxsvvfQSZs6cmeQLISIaeJLX3XykCQhcEAmgNDZPJIL7d2vLMqzAtO8D774qXk+bm7QQovK9RUDWGGDHr7RlDTUiQcy+VsQXJYfDgfnz56O2tjZygtj2FXDuvPj5TbBtF7BnP7BiiUgekq21XZQkyx80FgsG52F9oAFd6kUAwBsXD+Ljr09j/pCJAIBVw/Lxzj8+x5//cQIAcEa9gF8E6vHjofm41jIi6TFFvNZyO/DmBuCplVpLYai7bcDhL7UEqK0D2OECJo8XSdPcGaKFsvJdbR/3MaC7BxiTHX183i5g+DAgI1181sOHiWUDSdGtIhmuqdeWbdsFfHgIuDEvtmN1+YHTHeG/0F1WU1ODvLw8OByOOAMmIrp6JKclERCtgZ7DwPgp2jKZAB5p0pZdNxNIGwF8tBOYki9aGhtqkhZGnzpOifNPm6tvwYyxBREAbDYbAoEA9u7dm8QADUK7pCN1Gd5xM3Bvofg9tNVPtih9fBhYfIvojou12zGcA0eAed8VLV3yOH3FaewSjKVbPQlOq11QoWLcoBHAJfP6DMtQ5FlGou7rE7rln3wtuqJvHjw2mDz2O/m+yPfMqLVd38Jn5Npn7p6eefnv0n0s+ji6AyKxHDcKwCix7PTftfXGLm1jN6/sspYidYknUj9bzgAL5+jrIgD85k3x0zhc4sVHtd9DWxqjVF9fjwcffBA2my2m/YiIrkbJSxIB0WJ4zxqtC3nOEpE4hiZjs+4QLY4XfGL7wn8WrXfhuobjNfFGYEuDftn29SIZ/bRR/FyxQZRDDeHHP0YhJycHPp8Pra2tkTdq6wCeeDWu4wfHrJVt1rp6jV2G2ZnADROB+9drN92SQv2YqsW3aDfv0mLRCpjImL+2rwCoWqtUX3EauwRlnKXF5rFtsY51i9IZ9QK+17VNt2yqJRvfGZSN9wMNyMBQTBlkxZGL+q7ILlzEsUteTBs0Gn9GkpPEeK813H63zQCOn9Z3pYYm5p98AfzkudjO090jyuxpIhnr7jEf+/hp0aUtP9Oyu7REMDRZ7W0oRSL107VPXPtTK8Vr43jJbbtEiaa7udMPVFT2fjqXC16vF9OnT4eiKBybSETfaMmd3SxbDKfNFYlf1pjwXc1HPhZJ4ZEm0ap3XZLH93g+A9bOAx6epZXQ1sq3Notla+eJGF89CGz9WEyoiZHX6+2fG8W40aL7sLZJu1nW1IvusNnTtO26LwJ/ujzes9MPuI+bx441HNRujAeOaF2IVypOY5dgp19sL1vDUuBaywhUpd+JvV+36CauXJVKi4Hp12n1QGrrEInh/etF92vVU2I8YyyaPhX1Ke9afde4PLZMCGXdy86M/TNNtH4+Wy2ucc0LwLxZoqv+t78QdZOIiOKW3JZE2eU8Z4nWrWvsah57nWjpC52BPOuOuGYWJ6zLCzxzefLKz14DfvQ4sNUdU6um1WrtnxaFcaMAWPTjozr9ItkKTQK7A32PdwwzED9psUUTZ+4Y0SVZuU5/HG+nSAb6YZJKb+QElXf+8TnWdO8BELnFMFIL44BRbhcJYl9dtLLF7W5bbEMN2r0i8cvOBLbvNn8BMXYpnzgdW/xA8uqnTFzDtWoSEVHMkpskAlqX8z/dC5z9Ut/VPDpHLAudebxsnWhdjGbCSJdXzEoOHfco+dpFF3ZvIj1CBwBOHxOtijE4deoU8vLykJubG9N+YWWmixux+7h4bezSDbdNqsyeJibj/O3k5RafPuKULVAD4Ia9eMgk7Ez/kenRNl3qRbSo53HjIH3r082DxwLQxiYOGDIRys4EfvGqvgs13KN14q07x06Jn9mZ+i8jod3N91+eQV1aLFqHrxQZww6Xfmyh/JLSDxRFgdVqxeHDh9nVTETfeMl/mLZsOZyzRN/VLJfJrmbp4F8A69jou5z37wamztG6hm+yiUfYGI8bjnxUj7JCJKfS2DzxnMVojhGisbERaWlpWLBgQdT7RFRSKB53cuCIeN3WIW7ARXO17jvjNqlQWiwmCmzfLW7G0cR54Iho7VIKtOOU2+PqEqyrq4OqqnC73TGHvnrYbPx+eDFu7doe9pE2vwp8gDsGT8TiIZMAiC7p59IK8buLzTijXghuZ7fb4fP5EAgEUjPLddxo4PlHRCL0k+fMY+z+1Cje/5JCbdncGfHVna7LCde5TvF7MIbLLciyizsz/comiIC47oaDoiUztG7lTxX17cND2rL2cwAsl+OOX2FhIbKystDYGL7nI5H6SUQ00CS/JVF2OU+dI7qcpZtsYpkxcfzSDXjPAotKgdefEMtmzBPjBEPJCSZybOGa32rrjM83DDdxRT4wu6FGJLJrt+u7vOXElhhUVFTAZrOhqKgo9i5nYzedt9PcIvRstUimZDdtMmYmxyO0qzieOJuPin02lmnXHM9EigTkDxqLJ4fdimss6fgoQ/+w9d9dbMaa7j04o17AkgtvYfeIZbgxXSSv/fow7UiMD1l/6B5R5OzgsrvEZJSbrxfj76TQ912+33JmbyJ1Rz6qJ3RYQPNRoOGv2oSRQA/w343AD2zAmntFnMY6DmjxvrYTaDqEhG3bJRLftcu1c4W7VmO8MoYYZzeXlJSgpaUFFRUVicdORDTQ+f3dqt/frQJgiaMoiqJ6PB7V5/Opdrs95fF8G0pdXZ1aV1eX0hjsdrvq8Xj4mX9Livw793g8qqIovW47EOonCwsLS1IKk0SWq6nU1dWlPCG32+2qz+djIsBiKgOhfrKwsLAkq1guJ4hITx8OIiIiIiKgPyauEBEREdFVj0kiEREREZkwSSQiIiIiEyaJRERERGTCJJGIiIiITJgkEhEREZEJk0QiIiIiMmGSSEREREQmTBKJiIiIyIRJIhERERGZMEkkIiIiIpMhqQ7gaqcoCqqqqpCVlYXVq1ejurpav0H+VGDtcuCNWsC1T7+u3A7cfL1+2SdfAM8ajpFqSgHw0D3a60RiLLeLn7HurxQARXMBxxtApz/yduNGAxvLgIaDwLZd8cXYiwzLUGwffheKhkwBAHx2qQNLLryFM+qF4DaLh0zCzvQfBV+vDdTjlZ4DSY8lqmvNTAcqHgDGjwa27ACaj+r3tWbqt3/vQ/2xSouBO2+LvL43xn2lQI+Ipe0rfQzeTuDpSqCtI7rjR0u+B5PG688v34tYlNuB7Myw9dDpdKKsrAyVlZVYtWpVEgInIkotJokJKi8vBwAsXboULpcr/EbdF4H2c+blxkRJJlADiVIAPFAEPFMlbqryhvvbX8R3Q+8tOSwtBmZO7jsRjEbLmcT2D0MmiC3qeaSf/w0A4MXhC7F7xLJgorh4yCT8fngxbu3ajuZLZ5E/aCzeG1ECAP2TKAK9X+uae0VyFOjRLx83CujuAZ5+IfJnWFoMzJsFrLm8jfzsy+3RJ/knTvf+ef7kOfFTKQCWK9EdMxYy5nOdwBPrtXM9tVKf8Mrt3Mf7ToLPdYa9nlWrVuHkyZN47LHHcPLkSVRUVCT5YoiIrix2NyfA4XBg/vz5qK2tjZwgtn0FnDsvfl5tMtNF692e/VqrS6cf+PWb4kY5JSe18YXT5QdOd4RPyhNkGzwBUwZZ8avAB8Fl8vebB49FhmUofjp0Njb1fITmS2cBAM2XzmJTz0dYNHgSMixDkxtQX9eqFADTrwPerhdfVIzOdYpjhJM/FZj3XeDld7QkstMPPPHqwGvp7s3cGaLlr/JdbZlrn0gQR2eJOh6L1nZRIqioqEBLSwtKSkriDJiIaOBgS2ICbDYbAoEA9u7d2z8nMHaTGbvj8qcCq+4G3m8G7i0Uy8K13IR2a8fSpdfpF4nEzMkiFnnMtg6RLABaS2P3RcCaIRKSxbeILsTXdoobcl/d1cZu98p14me4bkH7/wAKZ4c/Tj9ru3QBFlgw3pKh616WutSLaFHP48ZBo69YTBGNGy1a5t6oFUnk4u/r14/JFsnTsz8R2wL6lrXZ08SXmxHDgaqngLRhiXXTxnsNG8tE3Ro3SnzegKgr0X727eeA4cOAmVP0dV5e57jRwPOPaF3ek8ZrXeR9tYJG8MEHH+C+++6D3W43Dz8hIrqKMElMQE5ODnw+H1pbWyNvFJpQxULeII+fFt1kMmEsu0t/c8zOBG6YCNwfsk1JoXYTlGOoyjaLm11pMfD4/dHf/CrfFXFUrus9SXi5RiQeyxWRhBbdCtw2QySJssh4jOT19NXdPGm86A68f732/igF+rGenX6gorLv64pD86WzuLnrDd2ymwePBQB88rVoOVzTvUe3PsMyFIsGT0Ld1yfQpYZpzUtEpGvNTBef8fHT4r3Jn2reJu9aUS/k5ynfT0DUndwxQPZIkTD99Hmt7qxdHluiOGm8lvRL8stDtPZ9BtR+JOLb4QL+1Ci+HI0b3feXneajoiX8oXtEMSaXbR2iyzva7uYoxmOePHkSaWlpWLBgAZNEIrqqMUlMkNfrjdzVnAh585I6/eIGZmzV674obpqh2+SOEa/zpwKTc0QCJ7ev/QgomAZ8Z0J0N/rQOORYLkB/s+3uEd3pY7L1XZjZmfpYE+XtFPHLuI6fFslOiuQPGovfDy/Gpp6PwrYsAsCmtDswZZAVb3V/duUCK7ncqvzi25G32bZLn/C0dYgErGhuSBesCrzyn9rnV1Mv6t/sadEniXG2xunIMZfdPVrX+vA00boYTYu4vFaZCL654cq3ihIRXYWYJCbIarVCUZT+SRQBc1ftidP69d2ByOMdx2SLLmCZ2BnXxUq2CMoZ20pB7MdIRG9j6K4wOYM50sxlOcllyiCrafZzv8pMF4lcuBa8p1b2PtxAds1mpItxd9mZ+vdbDj+QX0KuNnJMJSBatFcsSc4kKSKibygmiQk4deoU8vLykJubm/jBMtPFTdl9XLwO7W6+//KsTNkdG632cyIZeKY6vseKyBmnxqSi7SvRqvMttXrYbGxJK8Q9/nfw53+cMK2/1jICu0csw7FLXsy78IfkdzP3JjQRkvKnAo+UiBbl5qPi9XMPmx/LNCZbfK5dfuDAEdHinBHSEmysowNdb13IMgnuBxMmTOjfscpERFcIZzcnoLGxMTj2KGElheJZdgeOiNfjRgGwaF3JsoUoFn87KW76ZXdpy5QC0d0WTStg0yHRcrSxTJvcAIjxhgDgPhZbPH1pOSNu3BkxzjiNgaIo8Hg8UFUVTqcz5v1fHL4QPx6aj0mdr4VNEPMHjcX+jJX43cVm/ND/XxETRLvdDp/Ph0AgAIfDEXMcCZHj9B4o0sYr5k8Vr2ubRFLYfFTMnH78fq37uaRQfD6yy3+g6/SL67nzNvEFSxo3Wjzax31cS4CT2Ep6++23o6WlJex4xJR+7kREMWJLYgIqKipgs9lQVFQUe5ezsRvZ2wn84lWtxa75KNDwV62rONAD/Hcj8AObePZdNDM7ZatSuV0khvI8a3p5Nl64/UuLgRcf1ZafOA3868ti/cwpsV8roMUTOonBtU9MdpHnGmDjxhYPmYQfD80HAJzIfEi3bm2gHm9cPIgNafNwjSUdW9IKsSWtMLg+3EO3U0q2rIUORTBOKHm2WtQd2W0dz8Ouw3V7R3qYNqB99p98oX9sTbxc+8SXmY1l+gd7h5s8IydpyboZx3hKh8OBvLw8bN26NfHYiYhSze/vVv3+bhUASxxFURTV4/GoPp9PtdvtKY+HJbrP7OjRo6rD4UhpHHa7XfV4PKw335DidDpVVVVVp9PJz52FheWbUZgksnybikzq3W53SuOw2+2qz+dT6+rqUv6esPBzZ2FhYQlXLJcTRKSnDwcREREREcCJK0REREQUBpNEIiIiIjJhkkhEREREJkwSiYiIiMiESSIRERERmTBJJCIiIiITJolEREREZMIkkYiIiIhMmCQSERERkQmTRCIiIiIyYZJIRERERCZDUh3A1U5RFFRVVSErKwurV69GdXW1foP8qcDa5cAbtYBrn7a8tBi48zb9toEeYMsOoPlolCcvAJYrwNOVQFtHfBeQmQ5UPABMGq9f/t6HwLZd0R2j3A60tke/faqVFgPzZiX2vvVi8ZBJ2Jn+o+DrtYF6vNJzIOx2Px06Gyu630WXejHpcQAQn012JuB4A+j0i2XjRgMbywBrZvh9Xtsp6qpxO2+n/j0z1h3j+lhivPl68fuJ0/pYo90/0fqnFAAP3aO9/uQL4NnqyNtHEunvHdq/FQCwcuVKuFyu+OMlIroCmCQmqA4BascAAAkJSURBVLy8HACwdOnSyP/od18E2s+ZlxtviOV24JEf9VvyElanH3jiVe21vPF/053rBLpiSESitHjIJPx+eDFu7dqO5ktnkT9oLN4bUQIApkTxB0OuT/r5wzrXaU66unuAl6v0X0hk8uw+piWIDQe15EspEMuerhTvXcUD4thPrNf2l+ujrb/ldvHz/vXa64oHYk8UE6EUAA8UAc9cfj/k38Bvf6G/ltJiYObkvmOL8PfucrkwceJEuN1uvPTSS5g5c2Y/XRARUXKwuzkBDocD8+fPR21tbeQEse0r4Nx58bMvf2oEYAHGjUpqnGTQciZ84pSgDMtQ/HTobGzq+QjNl84CAJovncWmno+waPAkZFiGIn/QWHgy/xf8I3+OHw/NT+r5w2ptF6Uv+VOBhXOAHS6RFI0bJRLJ2o+0bdzHxLJxo4C5M0QLZeW72vqaevG+Ft0aXWxKATB5vP4Yle+K486dEd0xEpWZDhTNBfbs1xLmTj/w6zfFtUzJie14Ufy919TUIC8vDw6HI4HAiYj6H1sSE2Cz2RAIBLB3797kHHD2NHGD+dtJbVloV1yk7uh/XgzcdvmmGk93XV9kF1raMPE6XFfciDTgPx7Wuh5ll6Xcf9XdwPvNwL2F4eMM1wVq7L40dgmGdolHc45+1qVeRIt6HjcOGh1xm+ZLZzGx838DAFYPm41Fgyddkdh02jqANS9orzPTgRVLgMNfap/Z306KhLDoVu09njkFGD5MJECzp5lbYzv9YlnumOjiyLvWfIy2DuD4abFOMg7NCK1b4ci/mWiGTMiYZ04W74OsK20dWgt76N8gAFSuEz9jHR5yWX19PR588EHYbDbTOtklnZubi8rKSqxatSqmYxMRJROTxATk5OTA5/OhtbU18kahNxujSeO1Gw4gkq/QbeV4srLN4uZVWiyStdAbkzUT6PCJ7jrZTbbm3vjGU4VjHGMlk7lyu/4ct8/U4pJjJd3HtAQvOxO4YaI+zpJCcRPPTAcev1/ftTlutL4Vx9glKOMCtH16O0co177ek4wErOneo3udYRmKRYMnoe7rE/037rA30YzT+84EIHsksH23tkwOQyi3A29uEMs++QL4yXPi95Yzoms6IySxykwXn4H8va/kPHdM5BZdmWiW20Vr45oXRF0qLTbXrVDGv5loVL4r6nTluvCJn6zn0XQ39/b3fpnL5YLX68X06dOhKArHJhLRgMUkMUFerzf+f+SNLV2lxdo4KEDcHHe4tPU19eImNXuadhPzdmpdgp1+oLZJ3ETHjU7OuMbZ04DTHUDTIfG6rUPEZDzH4S+1mEK7JeX67ouXu9Mvx+k+riUCGSHJhdTWoY//thn6czQfFV2EsgWor3OkyKa0OzBlkBVvdX+W0jh6Fa4FO/TLgUySlAKg6imRRDUdEt20ZXdp60sKgeFpQHcgebEZv+wcOALM+66+bknhJulEo61DS36VAuCpleL3eCevJECOWyQiGgg4JjFBVqsViqIk52Ay2Zs55fK4RIt+AHy47jxjd137OSR1XGO41p5w5+hr3Ft3IPI4rbYO4OV3xJi4NzeIUvWUSFQArYXKeI6WM2J5hkwSeznHFZZhGYr/TF+KOwZPxJILb+GMeiHVIYWXmS4Sbfdx/Wd8t03f/QyI3w9/KdbJcXuTx2ufGQDs+yz68Z6t7eLzk0m+cZ00brT48vTmBpHADR9q3v7O20SX8PjRomU0Xq59oiX6mSpg+nUiaSQi+pZiS2ICTp06hby8POTm5ib3wHnXitY4qMCYbG25TJbcx7VlMkmSN+Ux2WK/eJMl2arXcka8bm03j9dK9BzhjMkGVj6jvVYK9F3r4ca66ca0DZzJPtdaRmD3iGU4dsmLeRf+kJpu5mgZP+9oyMQutAUO0IYi7IiyZT1cl/W40SLx/PByy7XsbpZjU/OnAo+UmI8lW/3K7WJ8ZbStiZEeI9X2lWgN7weKosBqteLw4cPsaiaiAY0tiQlobGxEWloaFixYkJwDFt0qJgYcOKIN4C+aq7W0lBSKlpIDR7R9rJnabFI5U/P46fi7msvuEj/dx8TPA0fEOeVs03GjxU01kXMYlRaLCSnycSiAaK3sDkmuPjwkWnZk66KcjWtsAUsCp9MJVVXh8XhibiXOHzQW+zNW4ncXm/FD/3/FnSAqigKPxwNVVeF0OuM6RlTGjRJ1zujDQ6JlLrQlTSkQy2qbRH14c4N+fdldImmXQxP64ton6pGsc8ZjyC9FDQe1ujZ7WviWRNny+OLb4ueae6OLoemQON/GMlG3Jfk3Jf8OAHPLdZwKCwuRlZWFxsZG07or9rkTEUWBLYkJqKiogM1mQ1FRUXwD0I0TV4yD5mXLSG+zKb2dwOgsrbvvxGntRhkN48zRE6eBf31ZS7yaj4pzrl2uzSxO9litbbtEV/vGMu06jNcquz3leDEgtgd+XwEZlqHYkDYP11jSsSWtEFvSCoPrPrvUgSUX3sJ4SwbeG1GCayxaotGe+Qj+rvpx54Wa4KNzrqhwz/Vz7RPLQj93QD+z2LjeOPEqGrKOh9bf0FbA7bvFOWQdrT8gxshGep5op1/bxzi5Khw5Qae0GHjxUW258e9Avie3zdC2i3N2c0lJCVpaWlBRURHTfkREV5zf3636/d0qAJY4iqIoqsfjUX0+n2q321MeD0tyitPpVN1ud0pjUBRFPXr0qOpwOFL+frAk5/P0eDyqx+NRFUXh587CwjLwC5NEFhZ9cTqdaiAQSOlNWiYUqU5UWfi5s7CwfHuL5XKCiPT04SAiIiIiAjhxhYiIiIjCYJJIRERERCZMEomIiIjIhEkiEREREZkwSSQiIiIiEyaJRERERGTCJJGIiIiITJgkEhEREZEJk0QiIiIiMmGSSEREREQmTBKJiIiIyIRJIhERERGZMEkkIiIiIpNgkjhs2LBUxkFEREREA0gwSZw1a1Yq4yAiIiKiASSYJN57772pjIOIiIiIBhCL39+tyhfz5tmwf//+VMZDRERERAOAbuJKdfV2zJkzJ1WxEBEREdEAoWtJlH7zm+fx9ttv4+DBg+jp6UlFXERERESUQmGTRCIiIiL6dvv/6V0REgEhgLQAAAAASUVORK5CYII=)
Is code se, humne students table mei 3 naye records insert kiye hai, jisme "student_id" column ke values automatically increment hue honge.Is code se, humne students table mei 3 naye records insert kiye hai, jisme "student_id" column ke values automatically increment hue honge.
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com