Two part question: What is Postgresql behavior for storing text/varchars in-row vs out-of-row? Am I correct in thinking that with default settings, all columns will always be stored in-row until the …
Tag: database
Find out available days and slots for doctor appointment
I have three tables: TimeSlotToken is the number of patients a doctor will see in his TimeSlot. TimeSlot 1, 2, and 3 are Morning, Afternoon and Evening respectively. I need to find the days where the TimeSlot is not full, i.e TimeSlot token is less than total bookings on that particular day and that slot. Sin…
Querying MySQL database using Python
I have a table named ‘staff’, with several columns, but the two I’m interested in are ‘username’ and ‘password’. I am trying to create a prompt which asks the user for their username (and later I will do password) and checks the table in the database to see if that us…
How to migrate data from MongoDB to SQL-Server? [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 6 years ago. Improve this question I searched around I found that there are ways to transfer/sync data from s…
Why does Hibernate generate a CROSS JOIN for an implicit join of a @ManyToOne association?
Baur & King said in their book: Implicit joins are always directed along many-to-one or one-to-one association, never through a collection-valued association. [P 646, Ch 14] But when I am doing that in the code it is generating a CROSS JOIN instead of an INNER JOIN. Mapping is from Member2 (many-to-one) -…
How to unify three different queries in mysql when exists multiple criteria?
I have a table and I need to get the number of rows using different criteria. Currently I use 3 queries one after another: SELECT COUNT(status) FROM projects WHERE project=’1′ SELECT COUNT(status) FROM projects WHERE project=’1′ AND status>’10’ SELECT COUNT(status) FROM …
Create MySQL Tables with Ansible
I’m using ansible to manage a small mail server using ubuntu. I wanted to use ansible to create a database which I can do and also create users for the database(s) which I can do also. But I’m not …
Trying to get value out of a select option in the same form
I’m trying to get value out of the select option. But it doesn’t seems to be able to get since it’s on form. How do I do it ? I mean by having taking the value out of the option select. Answer 1.) You can not select all the items in a select with selected ! Without multiple=”multiple&#…
Compare row count of two tables in a single query and return boolean
I want to compare row count of two tables and then return 0 or 1 depending on whether its same or not. I am thinking of something like this but can’t move ahead and need some help. I am getting multiple rows instead of a single row with 0 or 1 Answer you have to remove : Otherwise it will
Running sqlplus in background in Unix
I am trying to run an .sql file from sqlplus in Unix environment as a background process. I am connecting to Unix using Tectia or Putty, and I want sqlplus to continue running in background even if my terminal closes. This command works but when trying to start it in background it fails What is the right comm…