Question : After a crash of my PC I’m left with several databases (27Gb in total) that are left on […]
Tag: data
Post migration MySQL database validation
Question : We are migrating from 5.5 enterprise mysql to 8.0 mysql enterprise edition. And we are migrating version by […]
SUM first consecutive rows only SQL Server
Question : I have the following data: ROW SEGMENT ORDEN LONG 1 39 11 49.00 2 39 10 102.00 5 […]
MySQL date range if data not available display 0
Question : I’ve a table here here is the structure : id,id_berita,ip_user,tanggal I try to use this query : select […]
MySQL importing csv file by Data import wizard
Question : I tried importing a CSV file in MySQL via the data import wizard. My CSV file has 70,000 […]
Data sync between two local Mysql databases in different system in same netwrok
Question : I am using mysql as database for my application and for the purpose of fail over and I […]
How do I locate my Postgres data directory while the server is down?
Question : I’m on Mac 10.13.6. I restarted my machine and Postgres, which normally starts upon restart, wasn’t running. Sadly, […]
How can I arrange database structure for ranking card in a list in a Kanban Board?
Question : thank you for helping me. I got a problem when I design my database structure for kanban board […]
How to fill/insert fake data into a MS Sql Server
Question : I’m trying to test out some configuration settings for an MS Sql Server FILEGROUP and to do this […]
insert on table being unnaturally slow
Question : I have an “Basic” pricing tier Azure SQL database with a table of 7 columns, an ID column […]
- 1
- 2