Recent questions tagged MySQL

0 votes

435 views

1 answer

I have a table of tags and want to get the highest count tags from the list. Sample data looks like this id (1 ... I'm using MySQL 4.1.25-Debian See Question&Answers more detail:os...

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

0 votes

506 views

1 answer

mysql - LOAD DATA INFILE Error Code : 13

In my remote MySQL, when I try to execute this query, I am getting the MySQL Error Code : 13. Query - ... chmod 777 (rwxrwxrwx) using FTP Tool See Question&Answers more detail:os...

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

0 votes

899 views

1 answer

mysql - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Error message on MySql: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for ... be much appreciated. See Question&Answers more detail:os...

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

0 votes

512 views

1 answer

mysql - Exporting a table from Amazon RDS into a CSV file

I have a MySQL database running in Amazon RDS, and I want to know how to export an entire table to CSV format. ... Is there a solution to this? See Question&Answers more detail:os...

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

0 votes

439 views

1 answer

mysql - Facebook like notifications tracking (DB Design)

I am just trying to figure out how Facebook's database is structured for tracking notifications. I won't go much ... read and which haven't? See Question&Answers more detail:os...

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

0 votes

484 views

1 answer

mysql - Multiple select statements in Single query

I am generating a report in php (mysql), ex: `select count(id) as tot_user from user_table select count(id) as ... If i did? Process gets slow? See Question&Answers more detail:os...

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

0 votes

608 views

1 answer

mysql - Bogus foreign key constraint fail

I get this error message: ERROR 1217 (23000) at line 40: Cannot delete or update a parent row: a foreign ... area TO something_else command :-?) See Question&Answers more detail:os...

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

0 votes

771 views

1 answer

mysql - how to get last insert id after insert query in codeigniter active record

I have an insert query (active record style) used to insert the form fields into a MySQL table. I want to ... return of the add_post in model See Question&Answers more detail:os...

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

0 votes

578 views

1 answer

mysql - How to auto generate migrations with Sequelize CLI from Sequelize models?

I have a set of Sequelize models. I want to use migrations, not DB Sync. Sequelize CLI seems to be ... CLI from existing Sequelize models? See Question&Answers more detail:os...

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

0 votes

477 views

1 answer

mysql - Force InnoDB to recheck foreign keys on a table/tables?

I have a set of InnoDB tables that I periodically need to maintain by removing some rows and inserting others ... 's foreign key constraints? See Question&Answers more detail:os...

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

0 votes

424 views

1 answer

mysql - Is there any reason to worry about the column order in a table?

I know you can ALTER the column order in MySQL with FIRST and AFTER, but why would you want to bother? Since ... columns are in in the table? See Question&Answers more detail:os...

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

0 votes

378 views

1 answer

mysql - When to use SELECT ... FOR UPDATE?

Please help me understand the use-case behind SELECT ... FOR UPDATE. Question 1: Is the following a good ... not possible, please explain why. See Question&Answers more detail:os...

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

0 votes

736 views

1 answer

mysql - How do I find which transaction is causing a "Waiting for table metadata lock" state?

I am trying to perform some DDL on a table and SHOW PROCESSLIST results in a " Waiting for table metadata lock " ... 'm using MySQL v5.5.24. See Question&Answers more detail:os...

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

0 votes

937 views

1 answer

mysql - SQL keys, MUL vs PRI vs UNI

What is the difference between MUL, PRI and UNI in MySQL? I'm working on a MySQL query, using the command: desc mytable; ... -------+-------+ See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Modeling Product Variants

I've been trying to model product variants and thought that I might need to use EAV. I ... COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; See Question&Answers more detail:os...

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

0 votes

438 views

1 answer

mysql - I cannot use mysql_* functions after upgrading PHP

I am having few problems with the PHP upgrade. Before, I was using PHP 5.2.0 and below; now I have ... )){ mysql_close($connection); } ?> See Question&Answers more detail:os...

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

0 votes

459 views

1 answer

mysql - Making changes to multiple records based on change of single record with SQL

I have a table of food items. They have a "Position" field that represents the order they should appear in ... and stuff like that. Thanks See Question&Answers more detail:os...

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

0 votes

529 views

1 answer

mysql - SQL query of multiple values in one cell

There is a table(Course Interests) which has all the values in one cell. But those values are just ids and ... help from the community. Thanks See Question&Answers more detail:os...

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

0 votes

447 views

1 answer

mysql - How to find non-existing data from another Table by JOIN?

I have two tables TABLE1 which looks like: id name address 1 mm 123 2 nn 143 and TABLE2 w/c looks ... 's still getting the existing records. See Question&Answers more detail:os...

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

0 votes

508 views

1 answer

mysql - int(11) vs. int(anything else)

I'm new to web programming and doing different tutorials that I can find on the net. I did my research and found ... I don't know of? Thanks. See Question&Answers more detail:os...

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

0 votes

655 views

1 answer

mysql - Calculate the time difference between of two rows

I have a table with column StartDate, I want to calculate the time difference between two consecutive record. ... getting correct on clause. See Question&Answers more detail:os...

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

0 votes

512 views

1 answer

mysql - auto_increment by group

Is there a way with MySQL (5.0 specifically) to have an auto_increment field who's value is based on a ... this, but will if necessary. See Question&Answers more detail:os...

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

0 votes

631 views

1 answer

mysql DECLARE WHILE outside stored procedure how?

I fairly new to mysql but have MS SQL experience. Is it possible to declare variables and use while statement ... proc Suggest me the right way See Question&Answers more detail:os...

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

0 votes

474 views

1 answer

mysql - Getting a PHP PDO connection from a mysql_connect()?

I have a legacy PHP/MySQL app that calls mysql_connect(). Tons of existing downstream code makes ... totally understandable)? Thanks! See Question&Answers more detail:os...

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

0 votes

475 views

1 answer

mysql - Select a column with a keyword name

I have a table named 'test' It contains a column named 'AND' For that I use the following queries insert into ... I select my 'AND' column? See Question&Answers more detail:os...

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

0 votes

409 views

1 answer

mysql - PHP Check for NULL

Here is the below Code: $query = mysql_query("SELECT * FROM tablex"); if ($result = mysql_fetch_array($query)){ if ... == NULL work? Any Ideas? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

mysql - How to join two tables with ssp.class.php

I started using DataTables Table plug-in for jQuery and got some problems. I am using example code from ... for it with particular father_id. See Question&Answers more detail:os...

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

0 votes

549 views

1 answer

mysql - Dynamic table name at sql statement

I am trying to executing a mysql query like this SET @id := '47'; SET @table := @id+'_2013_2014_voucher'; SELECT ... 1 How I can achieve that? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags