Recent questions tagged MySQl

0 votes

809 views

1 answer

mysql - How do I view my stored procedures in phpMyAdmin?

I created a stored procedure in phpMyAdmin CREATE PROCEDURE Sample() SELECT * FROM feedback Where could I view ... procedures, tables, etc? See Question&Answers more detail:os...

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

0 votes

589 views

1 answer

mysql - Database - Designing an "Events" Table

After reading the tips from this great Nettuts+ article I've come up with a table schema that would separate ... (neither UPDATEs or DELETEs). See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - ERROR 1064 (42000): You have an error in your SQL syntax; Want to configure a password as root being the user

I have just downloaded WAMP. I want to configure a password for the MySQL root user using MySQL console. No password ... user='root'' at line 3 See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - #1146 - Table 'phpmyadmin.pma_recent' doesn't exist

Solution Guys... FYI i am using xampp to use phpmyadmin. and this error happens during the process of creating ... servers configuration */ ?> See Question&Answers more detail:os...

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

0 votes

671 views

1 answer

mysql - Repeating calendar events and some final maths

I am trying to have a go at the infamous repeating events on calendars using PHP/MySQL. I've finally found something ... % EM2.`meta_value`) = 0 See Question&Answers more detail:os...

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

0 votes

576 views

1 answer

mysql - Ranking with millions of entries

I'm working on a server for an online game which should be able to handle millions of players. Now the ... to use would be much appreciated! See Question&Answers more detail:os...

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

0 votes

716 views

1 answer

mysql - #1025 - Error on rename of './database/#sql-2e0f_1254ba7' to './database/table' (errno: 150)

So I am trying to add a primary key to one of the tables in my database. Right now it has a ... MySQL database with InnoDB table engine. See Question&Answers more detail:os...

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

0 votes

638 views

1 answer

mysql - Joomla! 3 installation freezes at creating database table

I am trying to install Joomla! 3.2.1 on my system but the installation freezes half way through. I've ... installer to go past this point? See Question&Answers more detail:os...

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

0 votes

731 views

1 answer

mysql - Automate mysql_secure_installation with echo command via a shell script

I am trying to automate mysql_secure_installation script with automated response. My code is as follows : echo "& y ... for the first question. See Question&Answers more detail:os...

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

0 votes

755 views

1 answer

mysql - How to use mysqldump for a portion of a table?

So I can export only a table like this: mysqldump -u root -p db_name table_name > table_name.sql Is there ... this with mysqldump or a query? See Question&Answers more detail:os...

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

0 votes

762 views

1 answer

mysql - Repair all tables in one go

How to check all the tables in the database in one go? Rather than typing the query check table ''tablename' ... all or anything like that? See Question&Answers more detail:os...

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

0 votes

675 views

1 answer

mysql - InnoDB takes over an hour to import 600MB file, MyISAM in a few minutes

I'm currently working on creating an environment to test performance of an app; I'm testing with MySQL and ... getting more usable for me. See Question&Answers more detail:os...

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

0 votes

936 views

1 answer

mysql - Unlocking tables if thread is lost

http://dev.mysql.com/doc/refman/5.0/en/internal-locking.html The following is the extract from the ... do I unlock tables manually? See Question&Answers more detail:os...

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

0 votes

795 views

1 answer

mysql - B-Tree vs Hash Table

In MySQL, an index type is a b-tree, and access an element in a b-tree is in logarithmic amortized time O ... to access data inside a database? See Question&Answers more detail:os...

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

0 votes

702 views

1 answer

mysql - Table is marked as crashed and should be repaired

I am getting this error in wordpress phpMyadmin #145 - Table './DB_NAME/wp_posts' is marked as crashed and should ... with PHP is very basic. See Question&Answers more detail:os...

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

0 votes

649 views

1 answer

mysql - How to manage Rails database.yml

What's the best way to handle the Rails database.yml if multiple people are working on the project and database ... (the socket in particular). See Question&Answers more detail:os...

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

0 votes

678 views

1 answer

mysql - How can I edit a view using phpMyAdmin 3.2.4?

I need to simply edit a very complicated view in phpMyAdmin 3.2.4 but I cannot figure how to do that. Any suggestions? Thanks! See Question&Answers more detail:os...

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

0 votes

963 views

1 answer

mysql - Error Code: 1822 when data types are matching, with composite key

Getting an Error Code: 1822. Failed to add the foreign key constraint. Missing index for constraint 'subject_ibfk_1 ... grade(subj_code) ); See Question&Answers more detail:os...

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

0 votes

594 views

1 answer

mysql - What type of JOIN to use

What type of JOIN would I use to get table1 and table2 to be matched only once. For example, I have ... Location" = "table1"."LocationArea" See Question&Answers more detail:os...

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

0 votes

677 views

1 answer

mysql - How do I handle single quotes inside a SQL query in PHP?

I am using a particular query for inserting records. It is going well. I am even fetching records with a select ... to insert in my records. See Question&Answers more detail:os...

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

0 votes

656 views

1 answer

mysql - Two autoincrements columns or autoincrement and same value in other column

I need two columns in table that would have same value on insert. Is there any way to do it from database side? See Question&Answers more detail:os...

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

0 votes

716 views

1 answer

mysql - Designing non-overlapping date-time events

I have the following problem: Events have a "begin" and "end" time and an amount. I use MySQL DATETIME for ... of tables at any given time) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - java.net.ConnectException: Connection refused

I am trying to connect to a mysql database on remote server and whenever I try to run the code it is ... listens to connection over port 3306? See Question&Answers more detail:os...

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

0 votes

716 views

1 answer

mysql - What is wrong with this stored procedure?

I keep getting this error for the below MySQL SP any ideas? CREATE PROCEDURE productpricing( OUT pl DECIMAL(8,2), ... INTO pl FROM Card; END; See Question&Answers more detail:os...

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

0 votes

660 views

1 answer

mysql - Join table depending on value of column in main table

notificationTable ID type typeID userID ============================================== 1 ... = 2 Anyone knows the real query for my intention? See Question&Answers more detail:os...

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

0 votes

841 views

1 answer

mysql - Select unique records limit with N rows

I have database records shown below, id | dataId | value 1 | 1 | xxx 2 | 1 | xx1 3 | 1 | xx2 4 | 1 ... N in this case is 3 thanks in advance. See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

mysql - Php PDO rowCount() return wrong result

I have a function for getting path in a tree structure data. According to my table in DB, root should get no ... <= it should found 0 Why? See Question&Answers more detail:os...

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

0 votes

555 views

1 answer

mysql - Is using a Master Table for shared columns good practice for an entire database?

Below, I explain a basic design for a database I am working on. As I am not a DB, I am concerned if I am ... DB design, and want a 2nd opinion. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags