Database Archives - Page 5 of 44

Why should I use document based database like CouchDB instead of using relational database. Are there any typical kinds of applications or domains ...

May 31, 2022
0 Comments

Database, Programming

IT Nursery

Is there a good reason I see VARCHAR(255) used so often (as opposed to another length)?

In multiple courses, books, and jobs, I have seen text fields defined as VARCHAR(255) as kind of the default for “shortish” text. Is ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

Add 2 hours to current time in MySQL?

Which is the valid syntax of this query in MySQL? SELECT * FROM courses WHERE (now() + 2 hours) > start_time note: start_time ...

May 31, 2022
0 Comments

Database, Programming

IT Nursery

How do I move a redis database from one server to another?

I currently have a live redis server running on a cloud instance and I want to migrate this redis server to a new ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

Copy values from one column to another in the same table

How can I make a copy values from one column to another? I have: Database name: list ------------------- number | test ------------------- 123456 ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

How to find the mysql data directory from command line in windows

In linux I could find the mysql installation directory with the command which mysql. But I could not find any in windows. I ...

May 31, 2022
0 Comments