如何在phpmyadmin中创建类似EMP01，EMP02的ID？ [英] How can I make an id like EMP01, EMP02 in phpmyadmin ?

问题描述

我刚做了正常的增量方法，但它是数字的。我想要一个角色。









提前致谢。



我尝试了什么：



我使用的正常增量方法。

Just i did normal increment method but it was in numeric. I want with a character.




Thanks in advance.

What I have tried:

Normal increment method i used.

推荐答案

您正在使用数据库 - 每个列都有一个'type'。 ID通常是整数，并且通常允许系统自动生成该ID以避免重复;其他时候，它可能是由某种类型的管理员分配的号码。



使用整数（或你说的数字），因为它们的存储效率非常高并且使用，并且最稀有的例外情况，占用的存储空间远远少于字符名称。比较它们也非常简单。



我建议您查看文档并决定如何输入字符类型的用户userID（包含数字/字母） 。



既然您没有说明您要添加或更改的ID以及您尝试更改的方式/位置，我就不能更加具体。但是 - 通过最友好的警告：  在你没有数据库（损坏）之前找到并阅读手册！ PhpMyAdmin听起来就是这样的

You're working with a database - and every column has a 'type'. An ID is very often an integer, and often this is allowed to be generated automatically by the system to avoid duplication; other times, it may be a number assigned by an administrator of some type.

Integers (or a you say, numbers) are used because they're very efficiently stored and used, and with the rarest of exceptions, take up far less storage than character names. Comparing them is very easy, too.

I suggest you check through your documentation and decide how to enter a user userID of a character type (which holds numbers/letters).

Since you didn't say just which ID you're trying to add or change and how/where you were trying to change it, I can't be more specific. But - by way of the friendliest of warnings:   find and read the manuals before you end up with a no database (corrupted)! PhpMyAdmin is just what it sounds like

这篇关于如何在phpmyadmin中创建类似EMP01，EMP02的ID？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！