Data dodania Pytanie
2017-11-29 21:11 Converting Oracle to MySQL : Different Outputs Seen »
I have an SQL query from Oracle which I am trying to convert to MySQL. Below is part of the query from both. The database structure is different henc...
(1) odpowiedzi
2017-11-29 15:11 SQL sorting by number and stay grouped »
Thank you for the time you'll spend to read and possibly answered to my question. I've a little problem of sorting I show you : My SQL query is that...
(1) odpowiedzi
2017-11-29 10:11 Django get_or_create returns False »
I'm creating a population script, from an MysqlDatabase to Django Models. Im looping through my receiving data from the Mysql and thats going good. N...
(1) odpowiedzi
2017-11-29 09:11 mysql select removes + sign from varchar »
I have noticed a strange behavior in mysql, and cannot understand why it happens. I have a varchar field, storing a telephone number, like: '+1234567...
(0) odpowiedzi
2017-11-29 06:11 mysql value sort by date but this column type is not a date type »
i have a database values values like this format premium_paid_date 31-10-17 30-10-17 11-10-18 31-08-18 31-10-17 25-11-17 but it was stored type is ...
(3) odpowiedzi
2017-11-29 06:11 Joining two mysql tables to get a true/false column »
I'm working with PHP and MySql. I'm trying to find a way to select a number of movies from a mysql table, but apart from the movies table I have a wat...
(1) odpowiedzi
2017-11-28 22:11 How to query for a phrase on SQL database of words? »
I am using MySQL and I have an SQL database of of songs with a table that consists of 8 columns of information on words of a song. each row represents...
(3) odpowiedzi
2017-11-28 12:11 SQL join to join values in primary table with child table values as diffrent columns in a single row »
I have a survey_datas table contain data's as like this survey_data_id | title 1 | Paul 3 | Anna 4 | A...
(1) odpowiedzi
2017-11-28 12:11 Converting Array to bulk Create in nodejs with Sequelize »
This is my req.body json data from angularjs controller: { phoneno: [ { id: 1, gsm: '123457801', firstName: 'Mohamed', lastNam...
(1) odpowiedzi
2017-11-28 02:11 PHP code snippet inside of functions.php »
I'm helping a friend with his wordpress website and I've found this snippet of code in his functions.php file. I'd like some help trying to understand...
(1) odpowiedzi
2017-11-28 01:11 Java 8, Complex groupingBy over time interval »
Using Java 8 + JavaFX I am trying to do some data analysis and output my results to an XY Chart. I've gotten my chart itself squared away, and it acc...
(1) odpowiedzi
2017-11-27 21:11 What is my SQL missing? »
I'm learning about PHP and MySQL. I have a lab that I'm working on where I have created a database (using the terminal in Ubuntu through a Virtual Mac...
(1) odpowiedzi
2017-11-27 11:11 Get the primary key id of the inserted row in symfony »
I have a symfony function that returns a rest api. I can post data to a new record successfully from an endpoint. This is the symfony controller as sh...
(1) odpowiedzi
2017-11-27 10:11 Spring JDBC Template not responding after specific Hits »
I am Using Spring JDBC template . In My Controller class method I am trying to get data using below code. String sql = "select id, query_sql, CONVER...
(0) odpowiedzi
2017-11-26 22:11 Do not connect oracle database with PHP through PDO »
I want to connect the oracle Schema database by default that comes in the oracle bd through PDO with php but it throws me this error: Fatal error:...
(1) odpowiedzi
2017-11-26 08:11 Proper way to convert SQL results to JSON »
I am creating a API using nodejs. The API takes request and responds in JSON For example: I have a table QUESTION in my database so a GET request to ...
(0) odpowiedzi
2017-11-26 04:11 Format Number Show in Value List Adapter »
I want to change format number in my code public class ListAdapterClass extends BaseAdapter { Context context; List<Student> valueList...
(1) odpowiedzi
2017-11-25 20:11 MySQL Subquery Looping for each row returned »
This uses two queries and I like to get result for each rows returned in the first subquery that will run the second query, essentially this will act ...
(1) odpowiedzi
2017-11-25 12:11 MySql query tooks 0.16 seconds in PhpMyAdmin, but 10 minutes in Php »
SELECT r.id randevu_id, r.id,m.ad,m.soyad,r.musteri_id,m.telefon, r.tarih,r.hizmet_id, IFNULL((SELECT MAX(o.tarih) FROM odemeler o WHERE o.sil=0 AND...
(1) odpowiedzi
2017-11-25 08:11 how to pass ajax return value php variable »
i know this question is asked many times, but non of them having right solution. i am using ajax to get the response from PHP Page. After getting the ...
(4) odpowiedzi
2017-11-24 22:11 When should we close database connection »
I'm using Spark to create a rest API. also I'm using ormLite + mysql database for persistent database. now the question is when should i close the c...
(2) odpowiedzi
2017-11-24 16:11 Access data from a join table »
I would like to select a user's groups where the join table is marked with favorit: true. I have User which has Groups through a join table named Us...
(1) odpowiedzi
2017-11-24 11:11 UNION vs GROUP BY or better solution »
I have a situation where I have some hundred of thousands of rows in database table with, let's say 8 columns, where first two columns indexed (two in...
(1) odpowiedzi
2017-11-24 02:11 mysql - Return all items in one row »
Is there a function in mysql that would return all items in just one row? EXAMPLE: Table: | id | name | ------------- | 1 | john | | 2 | mike | |...
(2) odpowiedzi
2017-11-23 20:11 Getting multiple maxes of summed values »
Consider this sample data: +----------+------+--------+-----------------+ | username | qnum | qvalue | date | +----------+------+--------+...
(2) odpowiedzi
2017-11-23 20:11 Adding a Row-Total Column in DataTables editor »
https://datatables.net/forums/discussion/45999 Need to make Column(total) for Sum 3 Column(No.1, No.2, No.3) Like this table ----------------------...
(1) odpowiedzi
2017-11-23 17:11 'Startup' is a type, which is not valid in the given context »
New to Asp.Net Core 2.0 and following https://medium.com/@lugrugzo/asp-net-core-2-0-webapi-jwt-authentication-with-identity-mysql-3698eeba6ff8 article...
(0) odpowiedzi
2017-11-23 09:11 Get parent id from child id SQL PHP »
I have data in table, and want get top of ID (parent id from child ID). id (primary_key) item_id secondary_item_id 464 ...
(2) odpowiedzi
2017-11-23 08:11 mySQL - Multiple rows into one row »
I need data from multiple tables using joins. Below are the tables. table 1 : list_vehicles pk_vehicle_id vehicle_reg_no vehicle_type 1 ...
(1) odpowiedzi
2017-11-23 07:11 how to avoid duplicate records insertion in php mysqli? »
How do I avoid duplicate records insertion in PHP MYSQLi? this my script : $nama=$_POST['nama']; $member=$_POST['member']; $peserta=$_POST['peserta']...
(4) odpowiedzi
2017-11-22 22:11 Creating temporary table inside stored procedure »
I am working on writing my first stored procedure for MySQL. The stored procedure needs to create a temporary table and then insert some data into i...
(1) odpowiedzi
2017-11-22 22:11 MySQL Index and Explain Plan »
I have this query: SELECT * FROM dwDimDate d LEFT JOIN tickets t FORCE INDEX FOR JOIN (idx_tickets_id_and_date) ON DATE_FORMAT(t.ticket_date, '%Y%m...
(2) odpowiedzi
2017-11-22 13:11 Laravel: LAST_INSERT_ID() is 0 after insert? »
I have the following working query: $year = 2019; $month = 6; $stmt = $db->prepare('INSERT INTO officeRechNr (jahr,monat,za...
(1) odpowiedzi
2017-11-22 08:11 The difference in the work of two similar queries with GROUP BY clause WITH ROLLUP in MariaDB »
Please, help me to understand why the following two queries return different results. The difference in queries is only in using DATE_FORMAT function ...
(1) odpowiedzi
2017-11-21 20:11 _mysql_exceptions error(1064, "check the manual that corresponds to your MySQL server version for the right syntax to use near 'default) VALUES »
I am trying to import CSVs to mysql database automatically using python script. I used the script from https://bitbucket.org/richardpenman/csv2mysql t...
(2) odpowiedzi