Data dodania Pytanie
2018-02-15 10:02 Query with two conditions PHP »
I'm trying to make an array from a list of records from my database. Making the array is not hard, but I need to order the records from the database i...
(1) odpowiedzi
2018-02-13 14:02 Conditional Left Join in MySQL without Subquery »
I have two tables, X and Y : mysql> select * from X; +------+------+ | id | colX | +------+------+ | 2001 | 0 | | 2002 | 0 | | 2003 | 0...
(1) odpowiedzi
2018-02-11 23:02 Database field to describe if data should be high or low? »
So I'm making a web app for tracking various data for a bakery. Initially I want to track 3 different key performance indicators: Baguettes sold per...
(0) odpowiedzi
2018-02-08 18:02 How to query MAX(SUM(relation)) in Postgresql? »
I have read several related threads on StackOverflow but none of them solves my problem. I have a Sales database as where I need to query for the cust...
(2) odpowiedzi
2018-02-08 17:02 Safe approach of storing MySQL credentials »
I've just started studying PHP and having concluded my first PHP & MySQL for dummies book I have a concern about having a secure connection betwee...
(2) odpowiedzi
2018-02-08 17:02 SYSDATE in ORACLE »
I'm trying to get the system date using the SYSDATE function in oracle, but I keep getting results equal to the number of rows in the table I'm reques...
(2) odpowiedzi
2018-02-03 14:02 SQL query find records that not persists in other tables »
I need to print all persons which are not students and not teachers. I have three tables. Oracle database. Code so far: SELECT PersonID, FirstName, L...
(3) odpowiedzi
2018-02-02 04:02 Ruby on Rails Heroku Error »
I just tried to push my app to heroku but when I go to run heroku run rake db:migrate it says, "Cannot run one-off process at this time. Please try ag...
(1) odpowiedzi
2018-01-31 22:01 How do I get the raw script output instead of the query result from an Oracle SQL select in Java »
I need to backup some data as INSERT statements through a Java application. The most straight-forward approach I could find in SQL Developer was runni...
(1) odpowiedzi
2018-01-29 12:01 Sort postcodes alphabetically and numerically? »
I have a database table of postcodes that are simply stored with the first part of the postcode. When I query the table and order by postcode I get th...
(2) odpowiedzi
2018-01-28 18:01 Identity Server 4, EF Core, share DbContext between API and IS4 »
I'm using Identity Server 4, Asp Identity, EF Core and one database. I have 3 projects at the moment IdentityServer - Contains all data contexts an...
(1) odpowiedzi
2018-01-28 03:01 Database changes for products in woocommerce 3 »
Woocommerce v2.6 stores the following meta_key values in the wp_postmeta table: _sku _price _regular_price _sale_price _manage_stock _stock_stat...
(1) odpowiedzi
2018-01-27 23:01 Difference using joins or navigation properties in EF »
I am learning EF and I am trying to understand when to use which type of query. For example this query: From fe In Processes.Where(Function(process)...
(2) odpowiedzi
2018-01-26 18:01 multiple variable, table and parameters into one query »
I have three tables: coach c_id cName equipment e_id eName c_id termUsed sport c_id sports Here is a link to the SQL FIDDLE page so...
(1) odpowiedzi
2018-01-26 17:01 Oracle Export and Import »
Some Background: Somewhere around Oracle 10, which was about a decade ago (give or take), Oracle added a new method of exporting and importing databa...
(1) odpowiedzi
2018-01-26 13:01 Is there a more efficient way of reading BLOBs without writing them locally first? »
I want to be able to read a document from database and extract some data out of it. I am able to do the second part but I'm having issue with doing it...
(2) odpowiedzi
2018-01-25 16:01 Oracle - Indexes »
I have been wondering how I can improve this Query in Oracle: SELECT FN_FORMAT_PEROPE(PEROPE) AS PERIODO, NVL((SELECT COUNT(1) FROM PG_PAGO ...
(2) odpowiedzi
2018-01-24 13:01 How can I filter and update a table in Slick with composite key? »
I have a table: trait Schema { val db: Database class CoffeeTable(tag: Tag) extends Table[Coffee](tag, "coffees") { def from = colum...
(0) odpowiedzi
2018-01-23 15:01 Oracle jobs monitoring under certain schema users with functions »
Just started rewriting of oracle jobs monitoring. Currently which I'm using is that Nagios is calling two different functions to check DBMS and Sche...
(0) odpowiedzi
2018-01-21 23:01 Writing a NoSQL / MongoDB Driver »
I am currently thinking of undertaking the task specified in the title for one of the Lisp languages (most likely Common Lisp). However, I have no ide...
(0) odpowiedzi
2018-01-21 08:01 How to create a trigger on after insert without returning NEW in postgres? »
Why do it after insertion? How write something like this: CREATE FUNCTION update_auto_dates() RETURNS trigger AS $update_auto_dates$ BEGIN ...
(1) odpowiedzi
2018-01-19 23:01 Rails: Show action in controller is unable to access foreign key value »
I am attempting to build a chess application, and am testing the logic of the ability to only select pieces that match the color of the player. The me...
(1) odpowiedzi
2018-01-19 16:01 MySQL get latest record checking two columns »
I have results like this I need to get the latest race of each jockey (First getting the max date of the Race, and then the Max Race number). The r...
(2) odpowiedzi
2018-01-18 16:01 How do I return my OUTPUT clause in Laravel DB::insert »
I am using Laravel and sqlsrv, connected to SQL Server 2016 and all is working great until I try to use an output clause in my insert query. Query is...
(3) odpowiedzi
2018-01-16 09:01 cucumber and cheese database returns server error »
I`m trying to run the local app on windows from cucumber and cheese book and I get a server error. Below is the terminal output: F:\RM\puppies>...
(0) odpowiedzi
2018-01-14 23:01 Using a backing field with One-To-Many relationships »
I have a situation where I have entity, which should expose a list of Users, and I only wish to expose IEnumerable, not List. So I use a backing field...
(0) odpowiedzi
2018-01-12 19:01 Retrieve Oracle database name without querying »
I have two Oracle 11gR2 databases (one for testing purposes and the other is production). By using conditional compilation I need to create a functio...
(2) odpowiedzi
2018-01-12 12:01 MySQL - Where occurs at least 3 times »
I have got this query, which works fine: SELECT t1.*, t2.ip as ip FROM table1 t1 INNER JOIN table2 t2 ON ( t2.id = t1.t2id ) ORDER BY t1.timestamp D...
(4) odpowiedzi
2018-01-09 13:01 Select a random row from Oracle DB in a performant way »
Using : Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 I am trying to fetch a random row. As suggested in other stackoverflow questions,...
(1) odpowiedzi
2018-01-07 20:01 Can't render data in EJS »
beginner programmer here. I'm creating an app with node and express, and while I'm getting my h1 text and link to show up on the page, I can't seem t...
(0) odpowiedzi
2018-01-07 19:01 How to reclaim MySql disk space »
I have a table in MySql server and the table contains around 1M rows. Only because of one column table is taking more disk space day by day. The datat...
(1) odpowiedzi
2018-01-07 14:01 Database structure for survey style application »
This question is very similar to this previous question Database design for a survey, however, this asker didn't specify the amount of data they were ...
(2) odpowiedzi
2018-01-06 18:01 Table is mutating. Trigger may not see it (Even on different tables) »
I have two tables: Group and Schedule. The Group table consists of columns: Group_Name, No_of_member. The Schedule table consists of column: Group_Na...
(1) odpowiedzi
2018-01-05 20:01 Why isn't this trigger good? »
The problem is as follows: a maximum of 50 employees is allowed in any department My teacher said that the trigger below isn't the solution but I did...
(1) odpowiedzi
2018-01-05 17:01 How to enable SSL in Postgres database installed on windows machine »
It would be great if anyone can provide/share quick information along with the steps to setup the SSL in Postgres database. I want to know what are c...
(0) odpowiedzi