Is it possible to create columns but doesnt name them on SQL?

[west pollen]

Hello

[surreal ocean]

⌛ This post has been reserved for your question.

Hey @west pollen! Please use /close or the Close Post button above when your problem is solved. Please remember to follow the help guidelines. This post will be automatically closed after 300 minutes of inactivity.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

[west pollen]

Is it possible to create columns but doesnt name them on SQL?

[queen blaze]

not really but I think you could just use numbers as names

But why?

[surreal ocean]

Ask about your actual problem, not an attempted solution.

[wheat pier]

The whole point of sql is that things have names. If you don't want names, you're doing something wrong

What is it you're actually trying to accomplish?

[west pollen]

I try to make a log program that an exact user logs his stuff to a certain day and then if he wants he can see what did on certain days

And i would like to create columns without names so when user does his logs it will be created such as 02.06.2024

[wheat pier]

What would that table look like then?

[wheat pier]

That's not, no

You need a table with username, date, content as columns

Also, format your dates using ISO8601, so 2024-07-02, or if you use my layout, just set the type correctly

[west pollen]

wdym

date and then another column for content?

[wheat pier]

yeah

and the username ofcourse

[west pollen]

wait got your point

[wheat pier]

If you want to add columns or tables in a running application, you're doing something wrong 🙂

I suggest a good book on database design

https://support.microsoft.com/en-us/office/database-design-basics-eb2159cf-1e30-401a-8084-bd4f9c9ca1f5

This is basic but has some good starting points