Recent questions tagged MySQL

0 votes

568 views

1 answer

mysql - In SQL how do I get the maximum value for an integer?

I am trying to find out the maximum value for an integer (signed or unsigned) from a MySQL database ... max_int; # max_int | 9223372036854775807 See Question&Answers more detail:os...

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

0 votes

842 views

1 answer

mysql - Not unique table/alias

I get the error ERROR 1066 (42000): Not unique table/alias: I cant figure out whats wrong with it. ... Project_ID where Access_Type = 'Client'; See Question&Answers more detail:os...

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

0 votes

742 views

1 answer

mysql - How to use django models with foreign keys in different DBs?

I have 2 models for 2 different databases: Databases were created manually but it should change nothing. class ... model for different database? See Question&Answers more detail:os...

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

0 votes

535 views

1 answer

mysql - How to get the byte size of resultset in an SQL query?

Is it possible to get the size in bytes of the results of an sql query in MySQL? For example: select * ... resultset in bytes. Is it possible? See Question&Answers more detail:os...

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

0 votes

618 views

1 answer

mysql - RMySQL dbWriteTable with field.types

I have a data frame, called df, that looks like this: dte, val 2012-01-01, 23.2323 2012-01-02, 34. ... anyone shed some light on this? Thanks See Question&Answers more detail:os...

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

0 votes

805 views

1 answer

mysql - Removing duplicates with unique index

I inserted between two tables fields A,B,C,D, believing I had created a Unique Index on A,B,C,D to ... mess the table up or duplicate it. See Question&Answers more detail:os...

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

0 votes

592 views

1 answer

mysql - sql group by versus distinct

Why would someone use a group by versus distinct when there are no aggregations done in the query? Also, does someone ... a,b,c from table x See Question&Answers more detail:os...

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

0 votes

635 views

1 answer

mysql extract year from date format

I need a mysql query to extract the year from the following date format from a table in my database. For eg : ... there any way to solve this? See Question&Answers more detail:os...

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

0 votes

640 views

1 answer

mysql - Java+Tomcat, Dying database connection?

I have a tomcat instance setup but the database connection I have configured in context.xml keeps dying after ... are being closed properly. See Question&Answers more detail:os...

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

0 votes

696 views

1 answer

mysql - Too many auto increments with ON DUPLICATE KEY UPDATE

I have a basic table with columns: id (primary with AI) name (unique) etc If the unique column doesn't ... doesn't cause many issues. Yeah? See Question&Answers more detail:os...

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

0 votes

615 views

1 answer

mysql sort string number

I have a column of type varchar that stores many different numbers. Say for example there are 3 rows: 17.95, ... that field as numbers in mysql See Question&Answers more detail:os...

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

0 votes

487 views

1 answer

mysql - Delete from one table with join

I'm trying to delete records from one database based on a selection criteria of another. We have two tables, ... update in the FROM Clause. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - ERROR 1044 (42000): Access denied for 'root' With All Privileges

I have strange error. I am logged in local Mysql as root via command line. After creating database: create ... ? Any help is much appricated See Question&Answers more detail:os...

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

0 votes

493 views

1 answer

mysql - How to use python mysqldb to insert many rows at once

I have a list of lists, e.g [['a','b'],['c','d']]. I have a table called T and two fields F1, F2. The first ... values (%s, %s)", (i[0], i[1])) See Question&Answers more detail:os...

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

0 votes

505 views

1 answer

mysql - How to use python mysqldb to insert many rows at once

I have a list of lists, e.g [['a','b'],['c','d']]. I have a table called T and two fields F1, F2. The first ... values (%s, %s)", (i[0], i[1])) See Question&Answers more detail:os...

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

0 votes

537 views

1 answer

mysql - Convert datetime value into string

I am fetching the current date & time using NOW() in mysql. I want to convert the date value into a varchar and ... string. How do I do it? See Question&Answers more detail:os...

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

0 votes

600 views

1 answer

mysql - Error installing mysqlclient for python on Ubuntu 18.04

I installed Python 2.7.15rci and Python 3.6.7 on Ubuntu. When i did 'pip list' on virtualenv it ... persists. Any suggestions? Thank you! See Question&Answers more detail:os...

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

0 votes

539 views

1 answer

mysql - Mysqldump launched by cron and password security

I wrote a script to backup my MySQL databases using: mysqldump --opt --all-databases -u user - ... automatic mysqldump and password security? See Question&Answers more detail:os...

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

0 votes

819 views

1 answer

mysql real escape string - PHP mysql_real_escape_string() -> stripslashes() leaving multiple slashes

I'm having issues escaping/stripping strings with PHP/MySQL - there always seems to be redundant slashes. Let' ... this the correct way? See Question&Answers more detail:os...

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

0 votes

737 views

1 answer

mysql - How to make a primary key start from 1000?

create table tablename ( id integer unsigned not null AUTO_INCREMENT, .... primary key id ); I need the primary key ... 1000. I'm using MySQL. See Question&Answers more detail:os...

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

0 votes

836 views

1 answer

mysql - What is wrong with my SQL here? #1089 - Incorrect prefix key

CREATE TABLE `table`.`users` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `username` VARCHAR(50) NOT NULL, ` ... 'm doing wrong. Help, please! See Question&Answers more detail:os...

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

0 votes

626 views

1 answer

mysql - #1214 - The used table type doesn't support FULLTEXT indexes

I'm getting an error saying that the table type doesn't support FULLTEXT indices. How can I achieve this? Here' ... timestamp (timestamp) ) ; * See Question&Answers more detail:os...

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

0 votes

699 views

1 answer

mysql - Insert and set value with max()+1 problems

I am trying to insert a new row and set the customer_id with max()+1. The reason for this is the table ... and not having the same customer_id? See Question&Answers more detail:os...

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

0 votes

426 views

1 answer

mysql - How to save a Google maps overlay shape in the database?

I want to save a Google maps overlay shape in the database. This is my code. It works perfectly but I just need ... going to use MySQL and PHP. See Question&Answers more detail:os...

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

0 votes

444 views

1 answer

mysql - Should I normalize my DB or not?

When designing a schema for a DB (e.g. MySQL) the question arises whether or not to completely normalize ... insert-heavy effect the decision? See Question&Answers more detail:os...

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

0 votes

498 views

1 answer

mysql - Getting percentage of "Count(*)" to the number of all items in "GROUP BY"

Let's say I need to have the ratio of "number of items available from certain category" to "the number of ... single query? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

522 views

1 answer

mysql - When to use a left outer join?

I don't understand the concept of a left outer join, a right outer join, or indeed why we need to use a ... please explain this to me simply? See Question&Answers more detail:os...

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

0 votes

472 views

1 answer

mysql - Glassfish Admin Console throws java.lang.IllegalStateException when creating JDBC Pool

A week ago I downloaded Glassfish 4.1. Did a zip install. Attempted to use Admin Console to create ... (TCPNIOTransport.java:536) at org.glassfish.grizzly.strategies.AbstractIOSt...

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

Categories

Just Browsing Browsing

Most popular tags