Database Administrators Questions, Problems & Solutions : TransWikia.com ~ Page 9

Putting some calculations on a database entry from phpmyadmin

I am creating an online store website for sale/purchase. I have to put a specific percentage of an amount (User enters) in database. for exampleIf user enters 100. I...

Asked on 12/12/2021 by farhangdon

1 answer

Users on same server connect to MySQL with different hosts

I am aware that when a connection is made to MySQL, MySQL does a reverse lookup on the IP address to determine the host it is coming from. I...

Asked on 12/12/2021 by CRM Dev

1 answer

Data modelling for specific units of measurement

I am currently adding a feature in our software where we save a timeout in the database to initialize cronjobs which get active after that timeout. To model this I...

Asked on 12/12/2021 by Vegaaaa

1 answer

What is the preferred / common way to separate "access-tokens" in a database design

I'm currently having a case where a user has to verify their email, is able to reset his password and can log into a web-interface (so far and not limited...

Asked on 12/12/2021

0 answer

compare the variance of sales from one day to another on the same table

I got this table on a SQL Server named "sales" that shows the sales per day for each vendor, this is the current table:+-------+-----------+-----------+--------------+| id |...

Asked on 12/12/2021 by Sabag

1 answer

Query output conditional upon values in dataset

If the number column contains values 5 AND 6, AND the value X exists in the chr column, I would like to exclude rows with 10 in the test column....

Asked on 12/10/2021

1 answer

Sql Server Database 2008 R2 is in recovery mode still after 16 hours

Sql Server 2008 R2 Database is in recovery mode still after 16 hours for one of the database which is is Simple Recovery model. The data file is...

Asked on 12/10/2021 by RS Ramgiri

1 answer

I can't successfully install postgreSQL. 'Problem running post-install step' error message pops up

I have successfully installed postgreSQL previously, but I am struggling to install it in one particular machine (Windows 8.1 Pro). Everytime I try to install it I get the following...

Asked on 12/10/2021

0 answer

How to increase max_connections in Postgresql-9.2

I need to increase production Postgresql-9.2 max_connections parameter from current 1000 to 3000.Used PGTune service to get the values and updated accordingly to the postgresql.conf file and /etc/sysctl.conf. /var/lib/pgsql/data/postgresql.conf...

Asked on 12/10/2021 by JineshJK

0 answer

Index Strategy for MySQL Query that matches on one column and between two others

I have a table that contains a set of measurements for a continuous stream of processes. Although each process is individual, they are categorized into groups. The events have a...

Asked on 12/08/2021

1 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 9)

Ask a Question