Data dodania Pytanie
2017-10-01 01:10 UPDATE a column in every row with a random unique number »
I have a small table of about 20k rows. In that table there is a column named random_uid (INT NOT NULL). I would like to update all 20k rows with a ra...
(2) odpowiedzi
2017-09-30 17:09 Cannot print data form mysql table into dropdown »
I have categories table with columns: id and name. I want to display them into dropdown menu. They are stored in the following $categoriesArray: arra...
(2) odpowiedzi
2017-09-30 14:09 MySQL dynamic SELECT column value »
My MySQL table has these columns: Status : int(11) and Closed : int(1). The thing is that when I retrieve rows with SELECT, I want Closed to be treate...
(1) odpowiedzi
2017-09-30 11:09 How can I get values null after inner join? »
I have this structure: Table A -- |id_A | field_1a | id_B | value_A| Table B -- |id_B | field_1b | field_2b | value_B| Table C -- ...
(1) odpowiedzi
2017-09-29 23:09 MySql aggregate by different initial values on other column »
I have a table structure as follows | user_id | value | date | |---------|-------|------------| | 1 | 5 | 2017-09-01 | | 2 | 6 ...
(3) odpowiedzi
2017-09-29 17:09 laravel whereHas results weird »
product model public function country() { return $this->hasMany('App\Models\ProductCountry', 'product_id', 'id'); } the controll...
(5) odpowiedzi
2017-09-29 03:09 Spring JPA select one column doesn't work »
I need to retrieve all the records for players column in sports table. SportsRepository method like below. @SuppressWarnings("unused") ...
(1) odpowiedzi
2017-09-28 22:09 Laravel - Save HTML Dom-Parser response to database »
I have managed to get some HTML from a website using HTMLDomParser (http://simplehtmldom.sourceforge.net/): $html = HtmlDomParser::file_get_html('htt...
(1) odpowiedzi
2017-09-28 13:09 Checking duplicated data in Laravel »
This code work as send to inn_db table from ext_db. but it cannot check if the data is the same or different in inn_db. So there posited same values...
(2) odpowiedzi
2017-09-28 13:09 Json from mysql breaks »
i have some issue with a json stored in mysql TEXT field, the thing is that everything is OK until i use ' (single quote) the json then is saved \' an...
(2) odpowiedzi
2017-09-28 12:09 Django ORM Group By ID »
I am trying to get some information from my table; total price, total trip etc between two dates. Here is my query start_date = Utils.subtract_day(da...
(2) odpowiedzi
2017-09-28 08:09 MYSQL - Check conflicting time »
Currently, I have this table 'tbl_subloading' : teacher_name | start_time | end_time de Guzman, J | 08:00AM | 10:00AM Harris, M | ...
(1) odpowiedzi
2017-09-27 22:09 InnoDB: breaking and fixing indexes »
From time to time it happens that some indexes in our tables get broken and the DB start consuming 100% CPU load and in some time it gets completely s...
(1) odpowiedzi
2017-09-27 15:09 Expressing formula within a SELECT query »
I have this existing query: SELECT extension , Total_Outbound+Total_Missed+Total_Received AS Total_Calls , Total_Missed , Total_Talk_Time_minutes ...
(2) odpowiedzi
2017-09-27 11:09 select sum qty from 2 tables »
In MySQL I have 4 tables: - product(id) - order(id) - order_detail_1(id, product_id, order_id, qty) - order_detail_2(id, product_id, order_id, qt...
(2) odpowiedzi
2017-09-26 19:09 Displaying mysql results on my website using datatables with dynamic headers »
So i have a website that I am developing for work. It allows sales people to go in and enter a date range and their initials and it queries my databas...
(2) odpowiedzi
2017-09-26 16:09 Populate selection field from Mysql with Odoo »
I want to populate a fields.Selection in Odoo with values retrieved from MySQL select statement. I tried adding the values of select resultset inside ...
(1) odpowiedzi
2017-09-26 14:09 Insert data in MySQL db in all tables »
here I'm again for some help. :) I'm trying to insert data into my MySQL database using F#. My schema includes 3 tables (Experiments, Gene and Results...
(1) odpowiedzi
2017-09-26 11:09 Difference between passing the data type and executing an array without them »
I just want to know if these 2 sets of code are doing the same thing or not, if not what's the difference? $connect= new CONNECT(); $sql = ("query he...
(1) odpowiedzi
2017-09-26 05:09 Laravel 5.4 query builder Missing argument 2 when using orWhere clause »
Can someone tell me why im getting this error and how to fix it please. $lastDayPreviousMonth = date("Y-m-d", strtotime("last day of previous mon...
(1) odpowiedzi
2017-09-25 17:09 Remove Order in hibernate »
I have 4 entities : Profile wich have a relation with companyContract : @OneToMany(fetch = FetchType.EAGER, mappedBy = "profile", cascade = { Casc...
(1) odpowiedzi
2017-09-25 10:09 MySQL Column headers into a single column, second column for the values »
I currently have a table that shows the data I need in the format of SELECT * FROM XYZ; Date | Brand | Game1| Game2 | Game3 | 2017 | xxxxx | xxx...
(3) odpowiedzi
2017-09-25 09:09 To Count the occurrence of pattern between specific values in Oracle table »
For example, with the help of below tables, Rn ID Pattern 1 C20 2 C21 3 C25 4 C25 5 C25 6 C25 7 C25 8 C21 9 C23 10 C20 11 C21 12...
(1) odpowiedzi
2017-09-25 04:09 Trouble with my Query »
I have made a simple database application however I am having trouble adding in one final Column. The amount column needs to be populated with the Yea...
(1) odpowiedzi
2017-09-24 23:09 Dynamic direction of ORDER in ActiveRecord query when using a JOIN »
I'm attempting to cleanup some code that was flagged as being vulnerable to SQL injection. As such, I am converting a lot of raw SQL query strings ove...
(2) odpowiedzi
2017-09-24 15:09 unable to save remote ip address in mysql »
I am having a weird issue: I want to save site visitor's IP address to database.below i am saying if visitor is not me (61.68.257.80 is my IP address)...
(1) odpowiedzi
2017-09-24 11:09 PHP 7.1.9 retrieves MySQL bit(1) as string(20) »
System: Debian Jessie (on cubietruck, armv7) PHP and MySQL have been compiled from the latest sources (PHP 7.1.9, MySQL 5.7.19). PHP info: https://ib...
(0) odpowiedzi
2017-09-23 23:09 Why won't my query let me assign primary key? »
Just a note, I'm pretty new to SQL. I'm using MySQL and using the app SequelPro. I receive this error when I try to make a table: "You have an err...
(2) odpowiedzi
2017-09-23 10:09 multiple the queried result from 'msql case' »
I can get the below output from the following query- SELECT ( CASE WHEN ta.Battery = 'HVA' THEN 'Huawei Valued Batte...
(1) odpowiedzi
2017-09-23 08:09 fetch and push the data in new table »
I have the table 'project','user' and 'role_mapping'.I want to to fetch the project_owner_id from the project table and push the user_id which is fet...
(2) odpowiedzi
2017-09-23 02:09 Get row values only if a particular column's value does not exist »
I have two tables in my database students: GRADE_REPORT: +----------------+-------------+------+ |StudentNo | SectionId | Grade| +---------...
(1) odpowiedzi
2017-09-22 11:09 Can I use where clause instead of AND in given SQL query? If yes, whats the difference in both? »
Came across this query online some where, explaining inner join with a condition (incentive>3k).Was just wondering if I can use where clause instead o...
(4) odpowiedzi
2017-09-22 10:09 Integrity constraint violation: How to join two tables »
I am making a program for a school project in laravel, so I try to join two tables: products and destinations The table Product has the columns: id,...
(2) odpowiedzi
2017-09-22 10:09 MySQL n results per GROUP BY, Order by count »
Country - Company have a 1-n relationship. Company - Dish have a n-n relationship. I need to get the Dishes from each locale ordered descending ...
(1) odpowiedzi
2017-09-22 08:09 How to filter mysql rows in PHP where data is either empty or 0 »
I am trying to find is there is an efficient way to do a query which can ignore rows of data where any column has a value of 0 or empty My current qu...
(3) odpowiedzi