Recent questions tagged MySQL

0 votes

832 views

1 answer

mysql - Wordpress SQL: get post category and tags

I want to query Wordpress data stored in a MySQL database, in order to get a result with columns: post_id category ... . What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

985 views

1 answer

mysql double-quoted table names

I'm doing a mysql query like: Select * from "User"; and it returns: You have an error in your SQL ... make mysql cope with the double quotes? 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 find the hierarchy path for a tree representation

I have a tree hierarchy look this built into a table with the parent_id pointing to the previous root node ... /child1) root2 child2 subchild2 See Question&Answers more detail:os...

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

0 votes

622 views

1 answer

mysql - Will this (normalised) database structure permit me to search by tags as I intend?

I am trying to set up a normalised MySQL database containing the three following tables. The first table ... given the appropriate setup. See Question&Answers more detail:os...

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

0 votes

685 views

1 answer

mysql - SQL Replace multiple variables from another table in query result

I have a team schedule table that looks like this: DBO.SCHEDULE Game1_Time | Game1_Home_Team | Game1_Away_Team ==== ... The Monsters | Bug Bites See Question&Answers more detail:os...

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

0 votes

740 views

1 answer

mysql - Does anyone have considerable proof that CHAR is faster than VARCHAR?

Any benchmark, graph anything at all ? Its all academic and theoretical across the web. Ok its not the first ... shed some light over this? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Can I use a subquery inside an INSERT statement?

I need to insert a row into a table, with one field value being calculated from another table. Rather than ... not, what's your recommendation? See Question&Answers more detail:os...

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

0 votes

655 views

1 answer

mysql - How are reactive streams used in Slick for inserting data

In Slick's documentation examples for using Reactive Streams are presented just for reading data as a means of ... table NumberTable (value INT) See Question&Answers more detail:os...

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

0 votes

973 views

1 answer

mysql - Average of latest N records per group

My current application calculates a point average based on all records for each user: SELECT `user_id`, AVG(` ... 30 records for each user? See Question&Answers more detail:os...

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

0 votes

754 views

1 answer

mysql - How to execute DDL only when tables don't exist?

I'm using Slick 1.0 with Play Framework 2.1 and MySQL. I'd like to control the ddl table creation so that it ... play. How to do it in Slick? See Question&Answers more detail:os...

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

0 votes

723 views

1 answer

mysql - Resetting the primary key to 1 after deleting all the data

So i have MySql and i have a table user with a user_id column and it is the primary key and auto ... whole table and creating it again. See Question&Answers more detail:os...

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

0 votes

746 views

1 answer

mysql - Difference between Unique Key and Primary Keys

I came across the following SQL in a book: CREATE TABLE 'categories'( id SMALLINT NOT NULL AUTO INCREMENT, ... between PRIMARY and UNIQUE keys? See Question&Answers more detail:os...

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

0 votes

903 views

1 answer

mysql - How to specify Ruby regex when using Active Record in Rails?

To get all jobs which invoice_number is a pure number I do: Job.where("invoice_number REGEXP '^[[:digit:]]+$ ... in Ruby rather than MySQL ? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Query execution was interrupted, error #1317

What I have is a table with a bunch of products (books, in this case). My point-of-sale system ... using phpMyAdmin provided by GoDaddy.com See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

mysql - How to set global innodb_buffer_pool_size?

How to set the global innodb_buffer_pool_size mySQL variable? When I set it to system display I get this error: ... is a read only variable See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - SQL: tuple comparison

In my current application, I need to be able to do this type of query: SELECT MIN((colA, colB, colC)) ... isn't true in our production system. See Question&Answers more detail:os...

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

0 votes

915 views

1 answer

mysql - Parameter '@myLeft' must be defined

My question is quite similar to already answered ones but yet not. I'd like some help sorting this out. I'm ... Open" What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - LEFT JOIN order and limit

This is my query: SELECT `p`.`name` AS 'postauthor', `a`.`name` AS 'authorname', `fr`.`pid`, `fp`.` ... If not, feel free to post a comment. See Question&Answers more detail:os...

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

0 votes

795 views

1 answer

mysql - Select one row without duplicate entries

In mysql table info i have : Id , Name , City , date , status I want to select all names from "info" ... echo only one time. Is this possible? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - InnoDB: Unable to lock ./ibdata1 error: 35

I'm trying to start MySQL in safe mode but the log file just keeps spitting out: [ERROR] InnoDB: Unable to lock ... to lock ./ibdata1, error: 35 See Question&Answers more detail:os...

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

0 votes

698 views

1 answer

mysql - How do I set a full date & time sql using java, and not just the date?

I am trying to set a timestamp in my database using java, however in my table all I get is the date, and ... (1, timestamp); ps.executeUpdate(); See Question&Answers more detail:os...

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

0 votes

709 views

1 answer

mysql - Storing image files in Mongo database, is it a good idea?

When working with mysql, it is a bad idea to store images as BLOB in the database, as it makes the ... the database as small as possible? See Question&Answers more detail:os...

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

0 votes

895 views

1 answer

mysql - Laravel Eloquent Ignore Casing

I am trying to run a query using Eloquent the $vars['language'] is in lower case but the language column is not ... i can get them to match. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Check if a string contains numbers

How do I check if a string in a MySQL field contains a number then delete them? Example table: tbl_tags ----- ... there must be an easier way? See Question&Answers more detail:os...

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

0 votes

953 views

1 answer

mysql - How to insert multiple rows based on a query?

I am developing a system that has folders, groups and permissions. Permissions determine what the different groups can ... ? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

658 views

1 answer

mysql - PHP Image Resizing

I've got a script that uploads files to the server as well as adds the filename to a database, but what I'd ... "; } ?> Thanks for your help See Question&Answers more detail:os...

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

0 votes

907 views

1 answer

mysql - SQL function to get count of how many times string appears in column?

Is there a function for MySQL that will count the number of times a string occurs in another string or column? ... for each row in a SELECT. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Passing array parameter in prepare statement - getting "java.sql.SQLFeatureNotSupportedException"

I am facing error java.sql.SQLFeatureNotSupportedException in my prepare statement. I am using Mysql database. Below is my ... (); } } } See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags