Recent questions tagged MySQL

0 votes

501 views

1 answer

mysql - Biggest value from two or more fields

I need to get the biggest value from two fields: SELECT MAX(field1), MAX(field2) Now, how can I get biggest value from these two? See Question&Answers more detail:os...

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

0 votes

560 views

1 answer

mysql - How to use greater than operator with date?

No idea what is going on here. Here is the query, right from phpMyAdmin: SELECT * FROM `la_schedule` WHERE ' ... 2012-11-01. What gives? See Question&Answers more detail:os...

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

0 votes

530 views

1 answer

mysql - How to get a percentage of total when the query has a GROUP BY?

Say I have a non-normalized table with movie actor names and the movies they've been in. eg. CREATE TABLE ... idk... yucky. Any ideas? See Question&Answers more detail:os...

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

0 votes

602 views

1 answer

mysql - Putting Rails over top of an existing database

I have an application written in PHP/MySQL (symfony, to be specific) that I'd (potentially) like to rewrite ... something that gives me forms. See Question&Answers more detail:os...

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

0 votes

565 views

1 answer

mysql - How do I create a CSV file from database in Python?

I have a Sqlite 3 and/or MySQL table named "clients".. Using python 2.6, How do I create a csv file named ... out how to use file as log. See Question&Answers more detail:os...

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

0 votes

414 views

1 answer

mysql - Is there a way to 'listen' for a database event and update a page in real time?

I'm looking for a way to create a simple HTML table that can be updated in real-time upon a database change event; ... "No"} </cfif> </cfif> See Question&Answers more detail:os...

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

0 votes

550 views

1 answer

mysql - select the TOP N rows from a table

I am making some paging, and I need to make some query and get the result form defined slicing . for example: ... on mysql, mssql, and oracle. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

mysql - #1030 - Got error 176 "Read page with wrong checksum" from storage engine Aria

Created a new database but can't create new user account due to this error. Does anyone know how to fix ... checksum" from storage engine Aria See Question&Answers more detail:os...

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

0 votes

531 views

1 answer

mysql - Troubleshooting "No such file or directory" when running `php app/console doctrine:schema:create`

I am new to Symfony2 (beta4) and Doctrine and am having issues when i try to create the DB schema via command line ... */ protected $date; } ?> See Question&Answers more detail:os...

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

0 votes

751 views

1 answer

mysql - Error Code: 1055 incompatible with sql_mode=only_full_group_by

I have been having issues switching to an offline version of the Lahman SQL baseball database. I was using a terminal ... know how to fix this? See Question&Answers more detail:os...

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

0 votes

620 views

1 answer

mysql - Find out where your PHP code is slowing down (Performance Issue)

Here's my first question at SO. I have a internal application for my company which I've been recently ask to ... app is crapping up. Thoughts? See Question&Answers more detail:os...

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

0 votes

531 views

1 answer

mysql - Site has been hacked via SQL Injection

Recently my site was hacked via SQL injection. The hacker used the following query to get my DB name. I cannot ... explain how the query works? See Question&Answers more detail:os...

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

0 votes

618 views

1 answer

mysql service fails to start/hangs up - timeout (Ubuntu, MariaDB)

I set up my first Ubuntu Server with Ubuntu 16.04, nginx, php7.0, MariaDB, nextcloud and external ... initiates the cluster log_daemon_msg "Bootstrapping the cluster" "mysqld"...

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

0 votes

726 views

1 answer

mysql - In a join, how to prefix all column names with the table it came from

I'm analysing a rather horrible legacy database/codebase, trying to reduce server load by combining queries into joins ... way to achieve this? See Question&Answers more detail:os...

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

0 votes

658 views

1 answer

mysql - how to partition a table by datetime column?

I want to partition a mysql table by datetime column. One day a partition.The create table scripts is like ... make use of partition.Thanks! See Question&Answers more detail:os...

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

0 votes

697 views

1 answer

mysql - Is there way to match IP with IP+CIDR straight from SELECT query?

Something like SELECT COUNT(*) AS c FROM BANS WHERE typeid=6 AND (SELECT ipaddr,cidr FROM BANS) MATCH AGAINST ' ... is for example ::1/64 See Question&Answers more detail:os...

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

0 votes

667 views

1 answer

mysql - using group_concat in PHPMYADMIN will show the result as [BLOB - 3B]

I have a query which uses the GROUP_CONCAT of mysql on an integer field. I am using PHPMYADMIN to develop this ... to see the actual results? See Question&Answers more detail:os...

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

0 votes

591 views

1 answer

mysql - Select from multiple tables without a join?

What is the easiest way to select data from two tables and rather than join them, have them appear as separate ... be 50 rows on the return. See Question&Answers more detail:os...

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

0 votes

835 views

1 answer

mysql - PHP date showing '1970-01-01 ' after conversion

I have a form in which date format is dd/mm/yyyy . For searching database , I hanverted the date format to yyyy- ... I format it to yyyy-mm-dd? See Question&Answers more detail:os...

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

0 votes

585 views

1 answer

mysql - How many rows will be locked by SELECT ... ORDER BY xxx LIMIT 1 FOR UPDATE?

I have a query with the following structure: SELECT ..... WHERE status = 'QUEUED' ORDER BY position ASC LIMIT 1 ... .];<null>;1;'Using where' See Question&Answers more detail:os...

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

0 votes

555 views

1 answer

mysql - There can be only one auto column

How do I correct the error from MySQL 'you can only have one auto increment column'. CREATE TABLE book ... ENGINE=InnoDB DEFAULT CHARSET=latin1; See Question&Answers more detail:os...

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

0 votes

568 views

1 answer

mysql - If table exists drop table then create it, if it does not exist just create it

I'm stumped, I don't know how to go about doing this. Basically I just want to create a table, but if ... be able to help? Thanks, George 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 delete duplicates in SQL table based on multiple fields

I have a table of games, which is described as follows: +---------------+-------- ... , awayteam_id, locationcity, and locationstate fields? See Question&Answers more detail:os...

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

0 votes

624 views

1 answer

mysql - How do I lock on an InnoDB row that doesn't exist yet?

How can I guarantee that I can search if a username exists in my database, then insert that username into the ... what to do in this situation. See Question&Answers more detail:os...

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

0 votes

657 views

1 answer

mysql - Query to find tables modified in the last hour

I want to find out which tables have been modified in the last hour in a MySQL database. How can I do this? See Question&Answers more detail:os...

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

0 votes

563 views

1 answer

mysql - Ruby, Rails: mysql2 gem, does somebody use this gem? Is it stable?

I found mysql2 gem. It works fine with ruby 1.9 and utf8 encoding (as opposed to mysql gem). But I have ... than mysql gem? Is it stable? See Question&Answers more detail:os...

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

0 votes

613 views

1 answer

mysql - Does index on Varchar make performance difference?

Does index on a varchar column make the query run slower? I can make that be int. and I don't need to do the LIKE % comparison. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

mysql - Insert using LEFT JOIN and INNER JOIN

Hey all i am trying to figure out how to go about inserting a new record using the following query: SELECT ... ) VALUES (LAST_INSERT_ID(),4); See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags