Recent questions tagged MySQL

0 votes

782 views

1 answer

mysql - Average on a count() in same query

I'm currently working on an assignment which requires me to find the average on the number of resources for each ... any input you guys have. See Question&Answers more detail:os...

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

0 votes

851 views

1 answer

mysql - unable to drop the foreign key

I would like to drop the foreign key in my table but been into this error message mysql> alter table customers drop ... a3' (errno: 152) mysql> See Question&Answers more detail:os...

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

0 votes

756 views

1 answer

mysql - How set 0 with MAX function when it is NULL?

I would like to understand how to set 0 value of the attribute when it is NULL with MAX function. For example: ... (number) is NULL and not 0 See Question&Answers more detail:os...

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

0 votes

957 views

1 answer

mysql - What is the length of a PHP session id string?

I'm making a table in a MySQL database to save some session data, including session_id. What should be the ... to store the session_id string? See Question&Answers more detail:os...

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

0 votes

688 views

1 answer

mysql - Update C# client whenever database is updated

I am using MySQL with C# / Visual Studio 2008. I need to know any method so that if one user updates ... , not specifically for new records. See Question&Answers more detail:os...

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

0 votes

654 views

1 answer

mysql keyword search

I have a table with names of movies, and I want to be able to search for a movie in that table. But I ... the most, should be returned first. See Question&Answers more detail:os...

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

0 votes

835 views

1 answer

mysql - InnoDB's row locking the same as MVCC Non-Blocking Reads?

Is MVCC Non-Blocking Reads the formal name for InnoDB's row locking? I've come across this vocabulary ... or something completely different. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Average of data for every 5 minutes in the given times

I have a problem with MySQL. I need the average of data from MySQL between two particular times. For ... within two particular time periods? See Question&Answers more detail:os...

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

0 votes

837 views

1 answer

mysql - mysql5.58 unstart server in mac os 10.6.5

MySQL 5.5.8 uninstall MAC OS 10.6.5,restart computer is message /Library/StartupItems/MySQLCOM has not been ... mysql server not start ,why? See Question&Answers more detail:os...

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

0 votes

756 views

1 answer

mysql - Prevent duplicate records to a table using PHP

I want to prevent duplicate values into a database table from a form using PHP. I have created the following: A ... this into my existing code. See Question&Answers more detail:os...

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

0 votes

767 views

1 answer

mysql - Set default classpath to use in `java` command in command prompt

What I'm trying to do is running a .java source by compiling and running it from command prompt (not using any ... and Ubuntu as well. Thanks. See Question&Answers more detail:os...

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

0 votes

847 views

1 answer

mysql - How to use a subquery for dbtable option in jdbc data source?

I want to use Spark to process some data from a JDBC source. But to begin with, instead of reading original ... error message come from? Thanks! See Question&Answers more detail:os...

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

0 votes

877 views

1 answer

mysql - Limit SQL by the sum of the row's value

So I'm kind of stumped here, I have a table setup like this +-----------+------+ | Timestamp | ... 'm trying to accomplish this with just MySQL. See Question&Answers more detail:os...

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

0 votes

999 views

1 answer

mysql - mysqldump with multiple tables with or without where clause

I have a set of tables in my database that I have to take a dump ( :D ) of. My problem is I want to take ... files, which I wouldn't want to do. See Question&Answers more detail:os...

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

0 votes

894 views

1 answer

mysql - how can I add a new column which counts the number of rows as serial number

record of id fare commission routecode vehicle number productcode date time driver owner name 15 12345 123 4533 1 3344 ... by 1 for each row. See Question&Answers more detail:os...

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

0 votes

715 views

1 answer

mysql - update a column by subtracting a value

I'm trying to come up with a MySQL query that will update points... Can I do something like this? UPDATE `a75ting` ... `points` = '`points` - 5' See Question&Answers more detail:os...

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

0 votes

646 views

1 answer

mysql - Selecting/casting output as integer in SQL

I'm working on a site that requires me to display a graph of the average number per day of a user input. I ... output as an integer (in MySQL)? See Question&Answers more detail:os...

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

0 votes

658 views

1 answer

mysql - Selecting/casting output as integer in SQL

I'm working on a site that requires me to display a graph of the average number per day of a user input. I ... output as an integer (in MySQL)? See Question&Answers more detail:os...

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

0 votes

589 views

1 answer

mysql - How to combine multiple columns as one and format with custom strings?

SELECT id, <X> AS name FROM `table` Basically <X> is a combination of lastname + ', ' + firstname example ... want to combine names so simple. See Question&Answers more detail:os...

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

0 votes

828 views

1 answer

mysql - How does 'LIMIT' parameter work in sql?

I have 4000 rows for example, and I define X limit. The query stops after it finds X rows? or the query ... from the found rows? Thank you. See Question&Answers more detail:os...

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

0 votes

752 views

1 answer

mysql - Creating a custom query with Spring DATA JPA?

I'm working on a project with Spring Data JPA. I have a table in the database as my_query. I want to ... achieve this goal. Thanks in advance See Question&Answers more detail:os...

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

0 votes

670 views

1 answer

mysql - Bash: How to invoke command and store the result in a variable?

Basically I want to be able to invoke a given command, in this case mysql -uanon -ppwd -db mydb -e " ... the simplest way to achieve this? See Question&Answers more detail:os...

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

0 votes

816 views

1 answer

mysql - Order by last 3 chars

I have a table like: id name -------- 1 clark_009 2 clark_012 3 johny_002 4 johny_010 I need to get results in ... have no idea how to do this. See Question&Answers more detail:os...

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

0 votes

787 views

1 answer

mysql - Delete first X lines of a database

is there an SQL command to delete the first X lines of a database table? I have a database table containing some ... .. Do you have any clue? See Question&Answers more detail:os...

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

0 votes

810 views

1 answer

mysql - Importing sql file using phpmyadmin in EasyPHP

I have a website written in php and mysql (written by someone else) and I need to alter it- just for ... really appreciated. Thank you. Bridget See Question&Answers more detail:os...

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

0 votes

863 views

1 answer

mysql - Rails: displaying an image from a blob field in a database

So, I managed to get an image blob into my MySQL database (there's a big hex number in the field), ... would be greatly appreciated! Thanks. See Question&Answers more detail:os...

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

0 votes

695 views

1 answer

mysql - Joining different tables based on column value

I have a table called notifications: CREATE TABLE `notifications` ( `id` int(11) unsigned NOT NULL ... the CASE statement unsuccessfully. See Question&Answers more detail:os...

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

0 votes

721 views

1 answer

mysql - Writing a PDO search query from a PHP array

I'm building an application using PHP 7 and a PDO connection to a MySQL database. One part of the ... problem and probably another post. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags