Recent questions tagged MySQL

0 votes

593 views

1 answer

mysql - connection.select_value only returns strings in postgres with pg gem

I'm converting a rails app from using mysql (mysql2 gem) to postgres (pg gem). With mysql, ... connection.select_value when using postgres? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

777 views

1 answer

mysql - Using DATE_ADD with a Column Name as the Interval Value

I have a table which contains products, a start date and an interval value : product_name start_date expiry_period ... appear to work either. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

606 views

1 answer

mysql - Postgres Left Join with where condition

I need to left join two tables with a where condition: time_table id rid start_date end_date 1 2 2017-07-01 00: ... record3 2017-10-01 00:00:00 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

635 views

1 answer

mysql - NULL values in where clause

i've got a table "bla" like this: [id] [name] [fk] 1 test 4 2 foo 5 3 bar NULL if i do the sql ... Seems that this is wrong. Why is this so? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

752 views

1 answer

mysql - What is the workaround for using dynamic SQL in a stored Procedure

The Stored Procedure DELIMITER $$ CREATE PROCEDURE `lms`.`leads_to_bak` () BEGIN SET @table1 = (SELECT ` ... for a plausible workaround? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

945 views

1 answer

mysql - SQL: Syntax error with intersect?

This is my query: -- Sids of suppliers who supply a green part AND a red part (SELECT Suppliers.sid FROM ... cost: real) bold = primary key See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

713 views

1 answer

mysql - How to use ORDER BY inside UNION

I want to use ORDER BY on every UNION ALL queries, but I can't figure out the right syntax. This is what I want ... 2 3 4 5 Thank you very much! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

755 views

1 answer

mysql - How to fix "ERROR 130 (HY000): Incorrect file format"

I have a problem with my database when I made a query on one of my tables I get this error message ERROR 130 ... format please how to fix it? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

708 views

1 answer

mysql - How to update table after a certain time interval

How can I update a table after some time interval when a condtion is matched? tb_contest id contest_id name is_expire ... updated on 2012-09-16. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

757 views

1 answer

mysql - 'You have a usable connection already' error in Visual Studio 2015 adding Data Source

Visual Studio 2015; Windows 10; In the Data Source Configuration Wizard, trying to add a table from a MySQL ... there is no code written. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

831 views

1 answer

mysql - Importing CSV using LOAD DATA INFILE quote problem

I'm trying to get this CSV file that I exported from excel loaded into my database and I can't seem to get ... Any ideas on how to solve this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

635 views

1 answer

mysql - Quartiles in SQL query

I have a very simple table like that: CREATE TABLE IF NOT EXISTS LuxLog ( Sensor TINYINT, Lux INT, PRIMARY KEY(Sensor) ... (10,20,30.....1000) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

836 views

1 answer

mysql - Select n random rows per specified group

I am struggling to find an optimal solution for the following problem. Suppose I have a table 'Table' like this: id ... going to be a bit large. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

766 views

1 answer

mysql - Comparing strings with one having empty spaces before while the other does not

If I have to find a string name "Akito" and it lies in the table foo then following is the normal procedure ... did not work? Thanks in advance See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

702 views

1 answer

mysql - Group PHP results on first letter of name

I have a query which gets all records ordered by last_name. Now I would like to create a loop that groups these ... --- Delta etc... Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

765 views

1 answer

mysql proxy socks

Plain and simple, can anyone explain me how to connect to a mysql server through a proxy (socks4/5). Preferable ... ANY other method will work. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

mysql - How to make limit offset dynamic using only (My)SQL

This code doesn't work select pagenr into @offset from pages where id = 3; select * from table1 limit @offset*10, ... , not the limit as such. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

795 views

1 answer

mysql group_concat with a count inside?

i have 2 tables, users and follows. table follows has a column named status. I would like to count how many ... but didnt work. Any clues? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

761 views

1 answer

mysql - php while loop variable for every third div

Is their a way in a while loop to assign a variable to a class in a div, for every third item in a while ... "; }/*SHOEDATA WHILE LOOP ENDS */ See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

553 views

1 answer

mysql - Why don't connect android to database directly?

I see many people trying to connect an Android device directly in a database like SQL Server or MySql and ... with my Android application. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

648 views

1 answer

mysql - Why doesn't this sql query return any results comparing floating point numbers?

I have this in a mysql table: id and bolag_id are int. lat and lngitude are double. If I use the the ... the problem with the lngitude column? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k views

1 answer

mysql - Load data Infile @variable into infile error

I want to use a variable as the file name in Load data Infile. I run a below code: Set @d1 = 'C:/ ... LOAD DATA @variable infile ? Thank you. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

702 views

1 answer

mysql - Ruby mysql2 Error

I am getting the following error C:/Ruby193/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:36:in `require ... end Any ideas? Cheers Martin See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

643 views

1 answer

mysql - Formatting a PHP array for an SQL "IN" clause

I'm attempting to query a database for records where the "product_id" is included in an array of products IDs. ... the question if needed :) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

651 views

1 answer

mysql - Insert default into not null column if value is null

I have a table foo, which has a NOT NULL column with a default called message: CREATE TABLE foo( id int ... (i_id, IFNULL(i_message, DEFAULT)); See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

mysql - ERROR 1005 (HY000): Can't create table (errno: 150)

I get an error when I try to create a table in mysql. Any tips on resolving it? create table stock_in( ... 'posinventory.stock_in' (errno: 150) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

mysql - Error #1046 - No database selected SQL import on XAMPP

I am trying to import the SQL database from my Drupal production site into a sandbox testing site on my local ... #1046 - No database selected ? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

844 views

1 answer

mysql - What's the most efficient way to select the last n rows in a table without changing the table's structure?

What's the most efficient way to select the last n number of rows in a table using mySQL? The table ... a unique identifier for each row. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags