Data dodania Pytanie
2017-10-11 16:10 Combine three tables to make an updatable new table »
Is there any way (except views) to create a new table in mysql that combines data from three or more different tables and when inserting new records i...
(1) odpowiedzi
2017-10-11 13:10 Compress a local file by php before storing it in the database »
I want to compress a file in php before sending it to the db. One solution $statement = $pdo->prepare('INSERT INTO test(datablob) VALUES(?);'); $...
(1) odpowiedzi
2017-10-11 12:10 Laravel count-function in Model, then sortBy count() »
I am trying to Order the Posts table by the number of votes a Post has got. The votes are stored in an other table (Votes: post_id, user_id, vote_ty...
(3) odpowiedzi
2017-10-11 12:10 Group by in django create wrong query »
we have write down this query in django ManageInterview.objects.filter (post_id=request.data['job_id']) .order_by('-id') .annotate(total=Count('pitch...
(2) odpowiedzi
2017-10-11 11:10 why addition need to check null but sum not need to check null? »
select sum(a) from Sometime when Sum, we don't need to check null value, but in add we need to check, who can tell me why? example Sum we don't need ...
(3) odpowiedzi
2017-10-11 10:10 Laravel Query builder, how to have 1 leading where and the other orwhere? »
I'm having a problem with my query. I want to filter through all Orders where user_id is the authenticated user. And run the searchquery on field num...
(1) odpowiedzi
2017-10-11 08:10 How to count record month group with unix timestamp in php & mysql. »
Example my_table ID | Name | Date -------------------------- 12 | John | 123456789 13 | Mike | 987654321 ... 29 | Rick | 123498765 30 | Adam | 987651...
(2) odpowiedzi
2017-10-10 18:10 File read to DB insert resulting in unicode strings »
I am reading a JSON string from a file, parsing it, then inserting the data into a MySQL database. My insert query is throwing the following error: ...
(1) odpowiedzi
2017-10-10 17:10 How to use airflow xcoms with MySqlOperator »
def mysql_operator_test(): DEFAULT_DATE = datetime(2017, 10, 9) t = MySqlOperator( task_id='basic_mysql', sql="SELECT count(*)...
(1) odpowiedzi
2017-10-10 13:10 laravel groupby with array »
i have post with category $response=Post::groupBy('post_category','id')->get(); The above query will return all posts with category in the orde...
(2) odpowiedzi
2017-10-10 06:10 MySQL - Round seconds to nearest half minute »
I am trying to round the mysql table field to next nearest half minute.Field contain only seconds like 22,44,121 But looks like my logic is wrong. Can...
(1) odpowiedzi
2017-10-10 04:10 Laravel 5.4 update all records in table without using where clause »
I am trying to update all records from table withing single eloquent query in Laravel 5.4 Currency::update(['default'=>0]); I am expecting that ...
(1) odpowiedzi
2017-10-09 13:10 How to migrate subset of data from production to develop by scrambling sensitive data? »
I like to create a tool which scrambles the production sensitive data and added it into another dev DB. I've built a couple of scripts that make rando...
(2) odpowiedzi
2017-10-09 13:10 Group by and nested array with php/eloquent/mysql »
Say that I have a time based dataset, which contains an array of data like this: { "group": "a", "date": "2017/01/01", value: 0.01 }, { "group"...
(1) odpowiedzi
2017-10-09 12:10 Database access with Angular »
Is it possible to access MySQL databases in Angular framework or would that be insecure like other Javascript and I will need to post to a PHP page to...
(3) odpowiedzi
2017-10-09 09:10 How to get price and sum the price as a total price according to date? »
THIS IS MY CODE $filter = DB::table('detail_clothes') ->get(['id', 'clothes_detail_date', 'clothes_price']) ->gro...
(1) odpowiedzi
2017-10-08 23:10 MYSQL select count(*) in one table if id exists in another table »
This should be really simple but I'm stuck on it and couldn't find the answer here. I want to count the number of records in one table that match a ...
(2) odpowiedzi
2017-10-08 22:10 Hibernate-spatial jpa with myql and Spring boot 1.5.7 not working »
I want to use hibernate spatial with mysql and spring boot. I tried but failing. application.properties file given below spring.datasource.url=jdbc:m...
(1) odpowiedzi
2017-10-08 20:10 Jquery interval not working »
I've made a small script to load a page into a div of another page, which gets refreshed every 5 seconds. The page is loaded as expected, but the int...
(4) odpowiedzi
2017-10-08 13:10 Get records within specific year and month »
I'm having this class method for filtering records that belong to specific year and month @posts = Post.filtered(params).published def self.filter...
(2) odpowiedzi
2017-10-07 17:10 MySQL Update IF (ROW_COUNT() = 0) »
I have this SQL : UPDATE gcd_data SET post_title = 'Hello World', post_content = 'How Are You?', post_date_gmt = '', post_modified_g...
(1) odpowiedzi
2017-10-07 15:10 The strategy to handle database connections: To 'close it immediately' or 'when script is over'? »
I'm to developing a back-end for a demanding application that may generate a really high traffic and processing load on the server. To deal with the d...
(1) odpowiedzi
2017-10-07 11:10 SQL Sum top 5 rows for each team »
I got help with this SQL-question below to sum up top 5 lenght for each team. The problem for me now seems that SQL is randomly selecting 5 of the for...
(3) odpowiedzi
2017-10-07 08:10 Laravel Eloquent Runs two queries on update? »
I was curious to know, if laravel eloquent runs only one query on updating a row. So I tried the following Route::get('/cli', function(){ DB::enab...
(1) odpowiedzi
2017-10-06 17:10 Predicting future IDs used before saving to the DB »
I am saving a complex dataset in Laravel 4.2 and I am looking for ways to improve this. $bits has several $bobs. A single $bob can be one of several ...
(1) odpowiedzi
2017-10-06 14:10 While querying my DB and showing results in form of a table, cannot choose other than first »
Currently I am displaying a table on my jsp by querying the mysql DB, I have several buttons that you can do things with this object. There is an upda...
(1) odpowiedzi
2017-10-06 13:10 Why is Rails returning a different float value when using a different database? »
I have an app running Rails 4.2 with this migration create_table "nutrient_amounts", force: :cascade do |t| t.integer "nutrient_id", limit: 4 t.i...
(1) odpowiedzi
2017-10-06 12:10 MySQL Group By Query X or not X »
This should be easy but I have not found the answer. I have a query that is running a count and I want to group this within the query into those where...
(4) odpowiedzi
2017-10-05 15:10 Laravel get orders assigned to my user (with assignments history) »
I have 3 tables/models User (id) Order (id) Assignments (order_id, user_id, created_at) Admin can assign order to some user, then reassign it and ...
(2) odpowiedzi
2017-10-05 13:10 We have an app that sends image to dot net server. Sometimes when network is flaky - »
enter image description here the image is not uploaded on server. Any input what area to look into - how to troubleshoot - any tools to identify the ...
(0) odpowiedzi
2017-10-05 13:10 SQL LEFT JOIN with COUNT that returns NULL values »
I have two tables: one that stores the product id and one which stores total sales per product_id and per sale_date Table Products product_id ------...
(2) odpowiedzi
2017-10-05 12:10 Why isn't zero date when compared to null, null? »
SELECT NULL; prints <null> SELECT CAST('0000-00-00' AS DATE); prints <null> SELECT NULL IS NULL; prints 1 SELECT CAST('000...
(4) odpowiedzi
2017-10-05 10:10 Fetch users who have posted the last comment 3 days before eloquent »
Actually, I need to send the reminder emails to all my users in a time interval. So basically if a user has not posted any comment in last 3 days I ne...
(2) odpowiedzi
2017-10-04 22:10 Laravel or PHP unique with multiple conditions »
I'm trying to get the unique rows from a MySQL DB from PHP and Laravel. In my DB I have: Email Errors Status a@a.a error1 pending a@a.a ...
(1) odpowiedzi
2017-10-04 19:10 AWS Codebuild containers very very SLOW »
I just setup my Codebuild pipeline for PHP Symfony2 testing by phpunit. Situation : Some of our tests talk to a local Database (classic mysql-ser...
(0) odpowiedzi