Recent questions tagged MySQL

0 votes

1.1k views

1 answer

mysql - phpMyAdmin not showing all rows - wrong number of total records shown

I'm showing all rows (825) in phpMyAdmin v4.3.2 for a mysql innodb table sorted by the default ... records phpMyAdmin thinks is there. See Question&Answers more detail:os...

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

0 votes

870 views

1 answer

mysql - PHP singleton database connection pattern

I've been working on a small project using PHP and MySQL. I've read a lot around about best practices ... connections instead of a singleton? See Question&Answers more detail:os...

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

0 votes

802 views

1 answer

mysql - How much faster is MyISAM compared to InnoDB?

People say InnoDB is not so fast like MyISAM. But how much slower? Just as a rule of thumb in the wind, ... platform vs. same thing with InnoDB? See Question&Answers more detail:os...

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

0 votes

680 views

1 answer

mysql - Spring - Invalid argument value: java.io.NotSerializableException

I am attempting to insert a record into a table and i am getting the following error: I also tried ... .java:603) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate...

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

0 votes

805 views

1 answer

mysql - Format date in SELECT * query

Is it possible to format a date field in a SELECT * query? I want to get all of the columns from my table ... process it in php after the query? See Question&Answers more detail:os...

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

0 votes

913 views

1 answer

mysql - Doctrine2 LEFT JOIN with 2 conditions

I'm trying to find a 'Product' by ID, and to left join all it's 'Photo' on two conditions: the locale AND ... the Photo, even if it's inactive. See Question&Answers more detail:os...

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

0 votes

737 views

1 answer

mysql - SQL Data Type to store build versions

What data type should i use for a SQL column to store Product version eg. Version 0.1 0.1.1 0.2 ... query to find highest number. Thanks See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Remove all non-numeric characters from a field

I have a results set from a webform that includes a phone number for each set. the format of this phone number is ... way to do this with SQL. See Question&Answers more detail:os...

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

0 votes

730 views

1 answer

mysql - New version of PHPMyAdmin has stopped me being able to edit data

PHPMyAdmin has just been upgraded by my server admin to v4.0.4.2. Now I am unable to edit rows in the ... I should have been doing anyway. See Question&Answers more detail:os...

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

0 votes

723 views

1 answer

mysql - Hibernate encodes wrong while persisting objects [UTF-8]

I'm facing with UTF-8 encoding problem while persisting my model objects. In Turkish '?' is a letter. Also there ... /props> </property> </bean> See Question&Answers more detail:os...

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

0 votes

654 views

1 answer

mysql - Is “Where IN” with multiple columns defined in Standard SQL?

I'm working on a query like this: SELECT * FROM requests where (id,langid) IN (SELECT nid,langid FROM node) ... but I'm not interested in that. See Question&Answers more detail:os...

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

0 votes

826 views

1 answer

mysql, space equals empty string

Just took me 2 hours to troubleshoot an issue on my backend. Cause was that of empty string being equal to space: ... this? Is it a setting? See Question&Answers more detail:os...

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

0 votes

719 views

1 answer

mysql - How to determine what is more effective: DISTINCT or WHERE EXISTS?

For example, I have 3 tables: user, group and permission, and two many2many relationships between them: user_groups ... situation? Why? Thanks! See Question&Answers more detail:os...

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

0 votes

731 views

1 answer

mysql - What would be a sql query to remove from the text?

I am using MySQL. My data has a column called text, which uses the TEXT data type. There are several newlines for ... query. How can I do that? See Question&Answers more detail:os...

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

0 votes

760 views

1 answer

mysql - How can I add a foreign key when creating a new table?

I have these two CREATE TABLE statements: CREATE TABLE GUEST ( id int(15) not null auto_increment PRIMARY KEY, ... not create a new table. See Question&Answers more detail:os...

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

0 votes

812 views

1 answer

mysql - Last inserted id from specific table

SELECT LAST_INSERT_ID() as id FROM table1 Why does this query sometimes return the last inserted id of another table ... I can only do queries. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - PHP strtotime() function wrong by 1 hour?

I am converting dates and times into timestamps using PHP before they are inserted into my MySQL database. My problem ... hour to all my dates? See Question&Answers more detail:os...

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

0 votes

972 views

1 answer

mysql - Update a boolean to its opposite in SQL without using a SELECT

Is it possible to upgrade a bool field by telling it to update the field to the opposite of what it is without ... query if that is possible ? See Question&Answers more detail:os...

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

0 votes

892 views

1 answer

mysql - Operation not allowed when innodb_forced_recovery > 0 [SqlYog]

I have created a table using SQLyog. When i insert values into it, it pops up following error message: Operation ... ', 'slugOne', 'descOne') See Question&Answers more detail:os...

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

0 votes

832 views

1 answer

mysql - How To Left Join 2 Tables On 2 Different Databases?

I have first database (dbA) with table like this, named Username : +------------------+--------------+ | Username | ... -----------------------+ See Question&Answers more detail:os...

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

0 votes

904 views

1 answer

mysql - Adding constraints in phpMyAdmin

I feel like I'm being stupid, but I can't find anywhere on the phpMyAdmin interface to add constraints ... it through the graphical interface. See Question&Answers more detail:os...

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

0 votes

830 views

1 answer

mysql - Cannot resolve table name close to

I want to create a references to foreign table. but i'm getting the following error: query: CREATE TABLE category_ids (id ... in set (0.00 sec) See Question&Answers more detail:os...

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

0 votes

700 views

1 answer

mysql - Why is Rails is adding `OR 1=0` to queries using the where clause hash syntax with a range?

The project that I'm working on is using MySQL on RDS (mysql2 gem specifically). When I use a hash ... and Ranges are handled differently. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Cannot login to phpMyAdmin, no errors shown

I have MySQL set up correctly on my linux computer, however I want a better way to input data into the database ... shows after I click "go". See Question&Answers more detail:os...

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

0 votes

810 views

1 answer

mysql - Doctrine2 LEFT JOIN with 2 conditions

I'm trying to find a 'Product' by ID, and to left join all it's 'Photo' on two conditions: the locale AND ... the Photo, even if it's inactive. See Question&Answers more detail:os...

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

0 votes

710 views

1 answer

mysql - SQL Data Type to store build versions

What data type should i use for a SQL column to store Product version eg. Version 0.1 0.1.1 0.2 ... query to find highest number. Thanks See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - Remove all non-numeric characters from a field

I have a results set from a webform that includes a phone number for each set. the format of this phone number is ... way to do this with SQL. See Question&Answers more detail:os...

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

0 votes

806 views

1 answer

mysql - New version of PHPMyAdmin has stopped me being able to edit data

PHPMyAdmin has just been upgraded by my server admin to v4.0.4.2. Now I am unable to edit rows in the ... I should have been doing anyway. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags