Data dodania Pytanie
2017-04-06 05:04 How to make a a query of similarity percentage in SQL Server? »
I have a process that before I submit the data to database I have to check whether the data is already exist in the database or not. And if its found ...
(1) odpowiedzi
2017-04-05 22:04 Mysql: Order rows by value frequency »
Let's say I have this table: +----+------+---------+ | Id | Item | Country | +----+------+---------+ | 1 | b123 | Austria | | 2 | a123 | Italy | ...
(2) odpowiedzi
2017-04-05 20:04 SQL: how to filter results beyond GROUP BY »
Original question The following relations keep track of airline flight information: Aircraft (aircraft_number, aircraft_make, cruisingrange) ...
(1) odpowiedzi
2017-04-05 17:04 Preventing duplicates while selecting into variable in MySQL »
My function generates unique combinations from Items table and stores into list variable. In the end of generation, it returns list as a result and ap...
(1) odpowiedzi
2017-04-05 12:04 How to Restore Mysql database to MS Sql Server in Rails 4 on Windows »
I created dump file of database in Mysql.Now i want to restore all the data of mysql to Sql Server.In case for mysql its simple by running source dump...
(0) odpowiedzi
2017-04-05 08:04 SQL WHERE and LIKE clause duplicated »
Hi guys I'm new to SQL and trying to learn it by myself. I have the following questions when I did the tutorial questions in sqlzoo website. Assume I ...
(6) odpowiedzi
2017-04-04 16:04 A way around having to loop through results to access more information using the first result set »
Given the following Database setup: Customers | customerId | accountId | addressId | |------------|-----------|-----------| | 1 | 110 ...
(1) odpowiedzi
2017-04-04 15:04 Cannot get mySQL.connector to download/work? »
I am trying to connect my raspberry pi to a MySQL database, unfortunately I cannot get it to connect. The error is: pi@raspberrypi:~ $ python HexCode...
(2) odpowiedzi
2017-04-04 12:04 MySQL get title from parentid with two tables »
I will try to explain much as possible. here is my query.. SELECT * FROM mm_star_ratings s JOIN mm_posts p ON s.post_id = p.postid WHERE p.type='B' O...
(1) odpowiedzi
2017-04-03 23:04 Joining a table to itself »
How do I join this table to itself to check if two users have both accepted a friend request? mysql> select * from friendships; +---------+-------...
(1) odpowiedzi
2017-04-03 21:04 MySQL+PDO: Advance cursor *without* fetching data? »
Seeing as that MySQL/PDO does not support scrollable cursors, is there any other way to advance the cursor without fetching the data, and without usin...
(0) odpowiedzi
2017-04-03 19:04 How to select till the sum reach some value »
having this table #table stock +-------+----------+ | id | stock | +-------+----------+ | 1 | 20 | +-------+----------+ | 2 | ...
(1) odpowiedzi
2017-04-02 23:04 Swift 3 - Pulling images from mySQL database »
I am currently in the process of designing an application that has a newsfeed. Images and text are stored in our database but I am having trouble pull...
(2) odpowiedzi
2017-04-02 18:04 Scala JDBC Connection to Cloudera VM mysql »
how to connect to mysql based on cloudera quickstat vm from scala? I can connect to vm using ssh cloudera@172.16.206.142 and able to launch ...
(0) odpowiedzi
2017-04-02 17:04 How to Merge fields after query, i know CONCAT, but not this way »
I know the way to merge field in MySQL: CONCAT( ) Oracle: CONCAT( ), || SQL Server: `+ but... I wanna merge AFTER query, is it possible? ...
(1) odpowiedzi
2017-04-02 16:04 How to get an array of records in php »
I execute an SQL query with php, this is the code: $get_inspection_dates_query = "SELECT `date` FROM `ve...
(3) odpowiedzi
2017-04-01 20:04 WordPress Database Error: [Table 'databasename.wp_users' doesn't exist] SELECT * FROM wp_users WHERE user_login = 'Username' »
I was developing a WordPress theme locally on a Mac (OSx Sierra) using XAMPP. It was set up so that when I typed localhost/ThemeName into the URL, I w...
(1) odpowiedzi
2017-04-01 18:04 Mysql select only child from a table tree »
I have a table name tbl_section this table is like that db_secid db_secname db_secdesc db_parent 1 Electrical NULL 2 ...
(2) odpowiedzi
2017-04-01 17:04 MySQL query becomes extremely slow when using Order By »
I have a messages table with 15 million rows. Below query returns about 5 million(But limited in 15 rows) records in less than 1 second : SELECT mes...
(2) odpowiedzi
2017-04-01 09:04 limit is not working in subquery »
I have saved vehicle types in 'vehicle_types_locales', drivers in 'drivers' and driver's current location in 'drivercurrentlocation' table. Logic : I...
(3) odpowiedzi
2017-04-01 07:04 Descending order in yajra not working properly for second page onwards »
For ascending sort , yajra is working properly(means response has properly sorted data). I have an array like this: suppose i have : $order = $order...
(0) odpowiedzi
2017-04-01 01:04 mySQL Query select / join not working as expected »
let me preface that I've done a good bit of searching to see if this issue can be resolved but have yet to find an answer that relates, so I'll ask no...
(2) odpowiedzi
2017-03-31 13:03 Sort descending based on part of a title in Wordpress? »
I'm having an issue how to sort a title in Wordpress. If I just know how I would solve this in MySQL it would be great. (If someone has an answer spec...
(5) odpowiedzi
2017-03-31 12:03 PDO query binding string instead of integer returns results »
I have a table with and auto increment id and was just testing a few scenarios when I stumbled across a problem whereby PDO or mysql seems to convert ...
(4) odpowiedzi
2017-03-31 12:03 Laravel datatables - Max execution time exceeded »
i use laravel datatables serverside to get data from 4 tables and display them. The code that i have on routes/web.php is: Route::get('/serverSid...
(0) odpowiedzi
2017-03-31 09:03 Laravel 5.4 updated syntax »
Hi guys got some problem.... Call to undefined method Illuminate\Database\Query\Builder::udpate() here's my update code... DB::table('gpl_team')-&...
(2) odpowiedzi
2017-03-31 09:03 Get joined reulst from 2 table and when value not exist any of them, fill with empty value »
I have tables clients and partners Table clients company_id | name ------------------ 11 | UA prods. 12 | CI corp. 13 | UAC...
(4) odpowiedzi
2017-03-31 09:03 VARCHAR SQL contains numbers how to get 2 decimals after comma »
I'm having some trouble getting the price to show correct on my website. Currently i have a row VerkoopPP40 which is a VARCHAR input. In this row ther...
(2) odpowiedzi
2017-03-30 16:03 SQL Select producing slightly different results in phpAdmin vs. phpHTML »
I consistently miss the first row result, which is more noticeable when there is only one row result. I have a problem with my PDO commands. Any sug...
(2) odpowiedzi
2017-03-30 14:03 Ruby on Rails - Emoji not saved in MySQL »
I'm working on a Rails app where users can upload photos to their profiles. Every photo has a title, which is supposed to support emoji. Despite chang...
(1) odpowiedzi
2017-03-30 06:03 Magento2 Database Import Error »
I am facing below error when try to import Magento 2 Database to popular hosting company, ERROR 1227 (42000) at line 1251: Access denied; you need (a...
(2) odpowiedzi
2017-03-29 15:03 Your password does not satisfy the current policy requirements »
I want to create new user in mysql with syntax: create user 'demo'@'localhost' identified by 'password'; But it's error. "your password does not sa...
(1) odpowiedzi
2017-03-29 13:03 not enough arguments for format string with bool and list »
I'm newbie to python and trying to update one column value (true/false) of all rows (ids provide in list) using IN on list. My query is like this : ...
(1) odpowiedzi
2017-03-29 09:03 Select odd numbers and does not contain special characters »
This is Table WWE : |**Col A** | **Col B** | -+-----------+-----------+- | Hello | 9%15A | | World | 2*10 | ...
(3) odpowiedzi
2017-03-29 07:03 Using & Searching through jsonb data in mysql »
We previously had PostgreSQL database setup and were using JSONB to hold some of our data in json since we need to keep one of our columns data dynami...
(1) odpowiedzi