Data dodania Pytanie
2018-02-11 03:02 SQL: Update column (username) with content from another column in same table (email address) »
I need to update the username of everyone in the wordpress users table so their email address becomes their username. I'm a total SQL muppet, so assu...
(1) odpowiedzi
2018-02-10 17:02 Rails: how to join two models through two different relations? »
I have two models: Saft (a magazine) and Keyword. Each "Saft" is defined by a series of keywords, but also has a title, which is always one of its key...
(1) odpowiedzi
2018-02-10 16:02 How can I make a collection unique? »
Here is my code: $products = Products::orderBy('id')->get(); And here is my table: // products +----+----------+----------+ | id | brand | ...
(2) odpowiedzi
2018-02-10 12:02 dapper c# returns rows found not rows affected »
I have a simple stored procedure which does update on a table. CREATE PROCEDURE `test_v1`( out v_changed_rows int ) BEGIN update mytable set...
(2) odpowiedzi
2018-02-10 05:02 How can I improve this query where multiple joins on the same table appears to be affecting performance »
The below query is used to apply multiple filter values when searching the product database on an eCommerce website. When you use more than 7 filt...
(1) odpowiedzi
2018-02-09 17:02 Foreach inner When query Laravel »
Hi Guys this is my function, i am using laravel 5.3 public function search(Request $request){ $word = $request->search; $status = explode...
(2) odpowiedzi
2018-02-09 14:02 Player ranking by categories »
Imagine the Player table with the following structure: PlayerId, Date, Kills, Gold, ClassId I need to make ranks by classes. The "global" ranking is...
(0) odpowiedzi
2018-02-09 09:02 SQL DELETE not work »
Good morning, everyone, I have a problem with my script I can't figure out how to make a feature. I'll explain: I'm using the outlook API I get my ma...
(1) odpowiedzi
2018-02-09 08:02 How acomplish a result from third Inner Join in mySQL- statement »
I use MySQL database. I run this question today SELECT t1.catalogID, t2.antfrp, t1.Latin, t1.Popular FROM `mydb`.`products` T1 INNER JOIN `mydb`.`pa...
(2) odpowiedzi
2018-02-08 21:02 MySQL set ID of primary child with constraint »
I have two MySQL tables where the primary relationship between the two is one-to-many. I also need a one-to-one relationship in the parent_table with ...
(3) odpowiedzi
2018-02-08 21:02 Is there a way to update a field in rails if same value exists for a different field maintaining its uniqueness? »
I am working on user's model in which users will be sorted on the basis of sort_order for them. What I am trying to achieve is that if we set same so...
(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 12:02 Laravel join with LIKE CONCAT »
Laravel 5.1.11 I have a simple search in my shop: public function search($request $request) { return Catalog::where('title', 'like', '%'.$re...
(2) odpowiedzi
2018-02-08 10:02 Spring Boot - Connect to Neo4j and MySQL datasources »
I'm trying to connect to two datasources, MySQL and Neo4j. I tried following this example but I have different versions of dependencies. <?xml...
(1) odpowiedzi
2018-02-08 07:02 .Net Core2 EF MySQL having issue while changing foreign key column to nullable »
I am working on an application where I am using .Net Core 2, EF Core and MySQL as database server via Code First approach. I have 2 tables: User Em...
(0) odpowiedzi
2018-02-07 22:02 MySQL select with max in multiple columns »
I have a table with stock prices by date, and I'd like to select the values closest to multiple dates. For example, give me the closest price to toda...
(1) odpowiedzi
2018-02-07 20:02 Optimizing delete operations in Rails 4 / ActiveRecord / MySQL »
Essentially, we need to delete T1 records that have not had a t3 record associated with it for given @user. Though not required, it would be nice to d...
(1) odpowiedzi
2018-02-07 18:02 mysql best index order for (FK, key, value) »
I have a key value table: id, data_id, key, value that references a data table: id, file_id, data which in turn references a files table: id, n...
(1) odpowiedzi
2018-02-07 13:02 Order multiple rows by field from most recent entry »
I'm trying to return a list of users, ordered by a field (pt_seen) on the users most recent row. Does that make sense? So far I have: SELECT u.use...
(2) odpowiedzi
2018-02-06 18:02 How to seed join table data from yaml file through seed.rb in Rails »
I am trying to add to my seed.rb the ability to load data onto a join table for my ROR 3.2.5 application. I have two models: Saft.rb and Keyword.rb, ...
(1) odpowiedzi
2018-02-06 14:02 PHP PDO Prepared statement bind NULL value »
I'm trying to run a SQL query as a prepared statement - and I try to bind a NULL value. Well I've done some research on the web and yes, I already fou...
(1) odpowiedzi
2018-02-06 13:02 How can fetching huge records using Laravel and MySQL? »
I Need experts Suggestions and Solutions. We are developing job portal website here by handle around 1 million records. We are facing records fetching...
(2) odpowiedzi
2018-02-06 11:02 Codeigniter getting data using where_not_in »
here is what I'm trying to achieve i have two table Delivery and Payment so i want to display data which is not in the payment table but exi...
(2) odpowiedzi
2018-02-06 00:02 Mysql: Get the ID where the percentage of certain element is the highest »
I'm new to MYSQL, and I have following table. The goal is to return the deptID with the highest percentage of engineering employees. empID empName ...
(1) odpowiedzi
2018-02-05 11:02 Trouble communicating between two docker containers »
I’m new to docker and I’m trying to connect my spring boot app running into my boot-example docker container to a mysql server running into my mym...
(3) odpowiedzi
2018-02-05 10:02 how to use time to count how many seconds you logged in »
Let's say I have a user/pass to enter and once it's entered another page will be redirected and in that profile page will show a line sayingi you have...
(2) odpowiedzi
2018-02-05 08:02 Laravel - How to get last 5 dates from database »
I have a model ImportantDate the schema is as below Schema::create('important_dates', function (Blueprint $table) { $table->increments('id');...
(3) odpowiedzi
2018-02-05 07:02 MySQL Update query - Will the 'where' condition respected on race condition and row locking? (php, PDO, MySQL, InnoDB) »
I am trying to build a first-come first-get model sale page. We have n number of items of the same type. We want to assign these n items to the first ...
(4) odpowiedzi
2018-02-04 15:02 Return multiple result sets in MYSQL using stored procedure in Laravel »
I'm preforming a query six times to return me multiple result sets. The query is same for all call but the params only vary. It is as follows: public...
(1) odpowiedzi
2018-02-04 13:02 Laravel double where returning no result »
I'm trying to do a double where on my table, but even if the arguments are correct I cannot view any result: Here is my Review model: class Reviews e...
(2) odpowiedzi
2018-02-04 09:02 Mysql build query with multiple constraints »
I am trying to set up a query that outputs the 5 most read articles over the last 4hrs. However, if there are no new articles over the last 4hrs, the ...
(3) odpowiedzi
2018-02-04 04:02 MYSQL / PHP Calculating number of occurrences »
First off all I am slightly confused what the best implemtentation would be for the following problem i.e pure can it be done with only mysql without ...
(1) odpowiedzi
2018-02-04 01:02 ExpressJS: push query values in array and route to ejs »
I need to get query values which will be routed to ejs file. I am able to do that using data:rows. However, this gives solution:Sandy. I only need San...
(1) odpowiedzi
2018-02-03 19:02 What is the $path of my item in my SQL database so I can download? »
I have found posts that explain how to download a a file (in my case an MP3) from an SQL database in PHP. It is apparent that a $path of the file is n...
(0) odpowiedzi
2018-02-03 18:02 Using MySQL sort varchar column numerically with cast as unsigned when the column can begin or end with letters »
I've ran into something I'm not really sure how to handle here. I'm building a database to store information on sports cards, and I'm having a bit of ...
(2) odpowiedzi