473,385 Members | 1,342 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

How to Add a Dynamic Column in Mysql

Hello all,

can any one Please help me how to add a Dynamic columns in Mysql database.

Thankyou InAdvance,
Phani Kumar.
Aug 12 '14 #1
1 1563
Rabbit
12,516 Expert Mod 8TB
You wouldn't do that in the table. Create a view that has the expression you want.
Aug 12 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Leo Muller | last post by:
I want to write a query that will give me a dynamic amount of columns back. What I want to do, I want to create a calendar application, in which for each employee, I want to show if he is in the...
0
by: Bill | last post by:
By dynamic mapping, I meant that before the records are transferred from one table to the other(source to target), the xml file which will have the field names of the two tables mapped, is to be...
0
by: me | last post by:
If i add an edit column dynamicly: EditCommandColumn edcol = new EditCommandColumn(); edcol.ButtonType = ButtonColumnType.LinkButton; linksDataGrid.Columns.AddAt(0,edcol); then when i press...
3
by: John E. | last post by:
I have a datatable that I am binding to a C# ASP.NET 1.1 web page datagrid. I also want to put an "Edit" column on the datagrid. However, whenever I use the following code, it puts the Edit...
0
by: Mark Parter | last post by:
I'm adding a dynamic column to a gridview control at runtime but I'm encountering a problem whereby I can only add 1 item to the column header. The column header should show the date in the...
1
by: Nagaraj | last post by:
Hello All, My Problem: Dynamic column – Example, if there is an Employee details, I should able to add or remove columns very easily. Selected Model: Meta-data model – storing all the values...
0
by: KA NMC | last post by:
I have a dataGrid that is populated by SQL table. The Datagrid has two dynamic columns - that I created to for calculations. I want to sort the grid on frmload by one of the dynamic columns is that...
2
by: hwalker | last post by:
Hello all. Long time reader, first time poster :) I'm creating a repot that shows "the last two weeks of data the next 6 weeks of data, week over week". So, I have a calculated field called...
2
Jerry Maiapu
by: Jerry Maiapu | last post by:
I know that you can limit a row by using the Top 5 clause etc..in a select query but is it possible to limit the heading in a cross tab query? The column haeding is dynamic ie..column will change so...
10
by: kavinhuh | last post by:
hello , i have a doubt , see my requirement is to add a new column to an existing table such tat the column name should be automatically given the name of the variable . i wrote the query as alter...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.