Recent questions tagged MySQL

0 votes

663 views

1 answer

mysql - how to select max of mixed string/int column?

Lets say that I have a table which contains a column for invoice number, the data type is VARCHAR ... invoice_number ) FROM `invoice_header` See Question&Answers more detail:os...

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

0 votes

703 views

1 answer

mysql - Selecting all records using SQL LIMIT and OFFSET query

I wonder if there is a way to accomplish: SELECT * FROM table by using LIMIT and OFFSET like so: SELECT * ... but I rather avoid it if possible See Question&Answers more detail:os...

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

0 votes

595 views

1 answer

mysql - How to echo print statements while executing a sql script

We have a simple sql script which needs to be executed against a MySQL database and we would like print log ... across Windows / Linux OS. See Question&Answers more detail:os...

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

0 votes

503 views

1 answer

mysql - Design Pattern for Custom Fields in Relational Database

I have assigned a task to create (relatively) simple reporting system. In these system, user will be shown a ... for this type of systems? See Question&Answers more detail:os...

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

0 votes

625 views

1 answer

mysql - Stored procedures in Ruby on Rails

I am a .net guy with 6 years of experience. Recently I started working on ROR project and realized that ... cons of using stored procedures? See Question&Answers more detail:os...

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

0 votes

527 views

1 answer

mysql - How do I change all empty strings to NULL in a table?

I have a legacy table with about 100 columns (90% nullable). In those 90 columns I want to remove all empty ... do this on the whole table? See Question&Answers more detail:os...

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

0 votes

694 views

1 answer

mysql - Difference between Encoding and collation?

I have seen certain questions and bugs related to encoding and collation. Could anyone of the visitors explain the difference in MySQL domain? See Question&Answers more detail:os...

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

0 votes

524 views

1 answer

mysql - SQL ANY & ALL Operators

I have started using sql and have heard much about the ANY and ALL operators. Can somebody explain to me the kind ... used in and how they work? See Question&Answers more detail:os...

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

0 votes

502 views

1 answer

mysql - my nodejs script is not exiting on its own after successful execution

I have written a script to update my db table after reading data from db tables and solr. I am using ... a hell lot of instances unnecessarily. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - How to SUM and SUBTRACT using SQL?

I am using MySQL and I have two tables: master_table ORDERNO ITEM QTY stock_bal ITEM BAL_QTY Master table has ... there are many rows). See Question&Answers more detail:os...

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

0 votes

668 views

1 answer

mysql - Can you define "literal" tables in SQL?

Is there any SQL subquery syntax that lets you define, literally, a temporary table? For example, something like ... do something like that. See Question&Answers more detail:os...

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

0 votes

473 views

1 answer

mysql - How can I import data from ASCII (ISO/IEC 8859-1) to my Rails/PGSQL database?

I am trying to use data from the USDA found here: http://www.ars.usda.gov/Services/docs.htm?docid=23634 ... this. Looking for guidance, thanks. See Question&Answers more detail:os...

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

0 votes

506 views

1 answer

mysql - Best way to store a PHP App's Settings?

What is the best approach to storing a group of global settings for a custom PHP application? I am working ... needing setting inside the DB. See Question&Answers more detail:os...

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

0 votes

475 views

1 answer

mysql - Hive 2.1.1 MetaException(message:Version information not found in metastore. )

I'm running Hadoop 2.7.3, MySQL 5.7.17 and Hive 2.1.1 on Ubuntu 16.04. When I run ./hive, I ... Hive, how could I fix the exception? Thanks! See Question&Answers more detail:os...

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

0 votes

598 views

1 answer

mysql - Never delete entries? Good idea? Usual?

I am designing a system and I don't think it's a good idea to give the ability to the end user to ... this kind of trick in your applications? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - The server time zone value 'CEST' is unrecognized

I am using hibernate (Hibernate Maven 5.2.15.Final, Mysql-connector Maven 8.0.9-rc) whith mysql 5.7 on ... Could someone help me? Thank you! See Question&Answers more detail:os...

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

0 votes

853 views

1 answer

mysql - mysqldump doesn't work in crontab

I'm trying to add a cronjob in the crontab (ubuntu server) that backups the mysql db. Executing the script in ... .gz what can be the problem? See Question&Answers more detail:os...

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

0 votes

617 views

1 answer

mysql - How to verify if two tables have exactly the same data?

Basically, we have one table (original table) and it is backed up into another table (backup table); thus ... stores mappings between two ids. See Question&Answers more detail:os...

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

0 votes

683 views

1 answer

mysql - INSERT INTO ... SELECT without detailing all columns

How do you insert selected rows from table_source to table_target using SQL in MySQL where: Both tables have the ... entries for primary key. See Question&Answers more detail:os...

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

0 votes

517 views

1 answer

mysql - INSERT multiple records using ruby on rails active record

Is there a way to INSERT multiple records rather than one at a time? I have a very very ugly rake task that is ... there must be a better way... See Question&Answers more detail:os...

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

0 votes

577 views

1 answer

mysql - Best Practice / Standard for storing an Address in a SQL Database

I am wondering if there is some sort of "standard" for storing US addresses in a database? It seems this ... / application / library does that. See Question&Answers more detail:os...

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

0 votes

628 views

1 answer

mysql - Getting hierarchy data from self-referencing tables

Let's say you have the following table: items(item_id, item_parent) ... and it is a self-referencing table ... for a MySQL supported approach. See Question&Answers more detail:os...

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

0 votes

761 views

1 answer

mysql - SQL - IF EXISTS UPDATE ELSE INSERT Syntax Error

I have the following SQL query: IF EXISTS(SELECT * FROM component_psar WHERE tbl_id = '2' AND row_nr = '1') ... you guys' help on this one. See Question&Answers more detail:os...

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

0 votes

732 views

1 answer

mysql - PHP isset() with multiple parameters

I'm trying to work with AJAX autocompletes and I am having a few problems with getting the two languages to work in synergy. ... ); }); }); }); See Question&Answers more detail:os...

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

0 votes

621 views

1 answer

mysql stored-procedure: out parameter

I have a mysql stored procedure from this (google book), and one example is this: DELIMITER $$ DROP PROCEDURE ... isn't this example working? See Question&Answers more detail:os...

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

0 votes

565 views

1 answer

mysql - How to change all the tables in my database to UTF8 character set?

My database is not in UTF8, and I'd like to convert all the tables to UTF8, how can I do this? See Question&Answers more detail:os...

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

0 votes

635 views

1 answer

mysql - If else on WHERE clause

I've this query: SELECT `id` , `naam` FROM `klanten` WHERE ( `email` LIKE '%@domain.nl%' OR `email2` ... use email2. How do I accomplish this? See Question&Answers more detail:os...

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

0 votes

543 views

1 answer

mysql - How can I protect against SQL injection attacks using Perl's DBI?

Is there a function i can use in Perl to sanitize input before putting it into a MySQL db? I don't know ... if there was already one made. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags