如何将列动态添加到规范行 [英] How to add a column dynamically to a specifice row

问题描述

你好朋友

我想动态地向数据库表中的特定行添加一列.
我不想将该列添加到整个表中，而只添加到特定行中.

Hello Friends

I wanted to add a column to a specific row in a database table dynamically.
I dont want to add that column to the entire table but to just a specific row.
Is it possible to do so?

推荐答案

无法在行内添加列

不可能.您需要了解数据库是一个分层系统.

数据库具有用于存储的表.
表具有列的结构.
数据行属于一个表，并且必须具有一组完整的列.

DBA做您想做的事情的方式是使用NULLable列.这样，如果特定行不需要数据，则可以为空.

Not possible. You need to understand that a database is a hierarchical system.

Databases have tables for storage.
Tables have a structure of columns.
Row of data belongs to a table and must have a complete set of columns.

The way DBAs do what you are trying to do is with the use of NULLable columns. That way, if a specific row doesn''t need a piece of data, it can just be empty.

这篇关于如何将列动态添加到规范行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！