Recent questions tagged MySQL

0 votes

870 views

1 answer

I have a problem using the MySQLdb library. I'm trying to insert values into my table but MySQL isn't showing ... ' cursor.close() conn.close() See Question&Answers more detail:os...

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

0 votes

718 views

1 answer

mysql - Max Tables & Design Pattern

I am working on an app right now which has the potential to grow quite large. The whole application runs through ... I should (could) go. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - PHP mysqli prepared statement for stored procedure with out parameter

I have a stored procedure IsUserPresent like: DELIMITER $$ CREATE PROCEDURE IsUserPresent( in userid varchar (150), ... result set's header 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 password_verify() not working with database

I'm in the process of making a login and registration system. The system works so now I have to add ... planning to add SQL injection defenses. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - Update multiple rows with known keys without inserting new rows if nonexistent keys are found

Let's imagine that we have table items... table: items item_id INT PRIMARY AUTO_INCREMENT title VARCHAR(255) ... elegant solutions? Thank you. See Question&Answers more detail:os...

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

0 votes

911 views

1 answer

mysql - SQL tree traversal

I am not totally sure I am naming this right, but please bear with me. I am wondering if is possible to ... any given row utilizing solely SQL? See Question&Answers more detail:os...

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

0 votes

918 views

1 answer

mysql - SQL tree traversal

I am not totally sure I am naming this right, but please bear with me. I am wondering if is possible to ... any given row utilizing solely SQL? See Question&Answers more detail:os...

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

0 votes

985 views

1 answer

mysql - Converting table from MyISAM to INNODB

I am simply trying to convert a table from MyISAM to INNODB. This is for a bugzilla upgrade with testopia. This ... for them and drop them all? See Question&Answers more detail:os...

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

0 votes

725 views

1 answer

mysql - How to handle foreign key while partitioning

I am working on fleet management. I am having large amount of writes on a location table with following columns ... there any alternate way... See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - Workaround for dynamic statements in stored procedures called from triggers

Mysql PREPARE and EXECUTE statements can not be used in a stored procedure that is being called by a trigger. ... plausible work around to 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 12 hr to 24 hr time conversion

How can we convert the time in AM/PM to 24-hrs format. For eg. (1:30 PM) should be converted to (13:30). See Question&Answers more detail:os...

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

0 votes

705 views

1 answer

mysql - How does one deal with multiple TimeZones in applications that store dates and times?

I realize this is a bit subjective, but I'm hoping to pick everyones brain here on how they deal with ... issues did you have to overcome? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - JDBC on Google Apps Script. Exception: Statement cancelled due to timeout or client request

I am trying to fetch data from mySQL database on Google Cloud SQL using JDBC from Google Apps Script. However, I ... me a solution for this? See Question&Answers more detail:os...

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

0 votes

928 views

1 answer

mysql foreign key error #1452

ALTER TABLE `groups` ADD FOREIGN KEY ( `company_id` ) REFERENCES `summaries`.`companies` ( `id` ) ON DELETE ... anyone shed some light on this? See Question&Answers more detail:os...

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

0 votes

783 views

1 answer

mysql - WARN SqlExceptionHelper:143 - SQL Error: 0, SQLState: 08S01- SqlExceptionHelper:144 - Communications link failure

I have problem with Hibernate (hibernate-core-4.1.9.Final.jar) Case 1: Hibernate testing inside for loop. Everything went ... >  See Question&Answers more detail:os...

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

0 votes

764 views

1 answer

mysql - Getting difference between counts of two subqueries

I'm trying to determine the score of an entry by finding the difference between the number of upvotes and downvotes ... ORDER BY [above query]? See Question&Answers more detail:os...

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

0 votes

935 views

1 answer

mysql - How to use LOAD DATA INFILE statement when file is another location?

I want to use LOAD DATA INFILE statement to import data in my table. If the file is available on the same ... from another system, or remotely? See Question&Answers more detail:os...

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

0 votes

765 views

1 answer

mysql - PHP Database Dump Script - are there any issues?

I found a PHP function to dump a mySQL database that someone else had written, and then cleaned it up and ... , $return); fclose($handle); See Question&Answers more detail:os...

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

0 votes

839 views

1 answer

mysql slow query

ALTER TABLE customers ADD split INT(1); 10 mil. records... I performed this command for 1 hour and still loading ... to make it finish faster ? See Question&Answers more detail:os...

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

0 votes

997 views

1 answer

mysql - LAST_INSERT_ID( ) returning multiple rows of 0?

Working in phpMyAdmin for now: order table strucure: OrderID int(11) auto_increment CustomerID varchar(50) BillAddr ... each row in phpMyAdmin. See Question&Answers more detail:os...

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

0 votes

780 views

1 answer

mysql - Slow INSERT into InnoDB table with random PRIMARY KEY column's value

For my website I use the PHP API for Flickr ( http://www.flickr.com/services/api/ ). This API provides ... How can I check disks performance? See Question&Answers more detail:os...

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

0 votes

844 views

1 answer

mysql - Connecting to a remote database through CodeIgniter

Unable to connect to your database server using the provided settings. I've been having difficulty connecting my ... 'stricton'] = FALSE; See Question&Answers more detail:os...

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

0 votes

944 views

1 answer

mysql - How to run a query to find a string in blob files?

Mediawiki has a table in the database 'text' which contains the page content. It is saved as a [BLOB] file. I ... query to search [blob] files? See Question&Answers more detail:os...

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

0 votes

991 views

1 answer

mysql - Multiple tags search query

I working on a tag based search. I have three tables tag(id,name), tagXmedia(id,tag_id,media_id), and ... on this would really be appreciated. See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

mysql - Sequelize geospatial query: find "n" closest points to a location

Using Sequelize and geospatial queries, if I want to find the "n" closest points to a certain location, how should the ... / how to fix it? Thx! See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - Basic DB connection pool with Java and Tomcat 7

I'm trying to create my first connection pool. I'm creating a Java web aplication with Tomcat 7 and a MySQL DB ... to do this? Thanks very much! See Question&Answers more detail:os...

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

0 votes

857 views

1 answer

mysql stored procedure is slower 20 times than standard query

i have 10 tables with same structure except table name. i have a sp (stored procedure) defined as following: select * ... i am close to end :) See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Chaining orX in Doctrine2 query builder

I have to dynamically add OR expressions to the query builder returned by getListQueryBuilder, right after adding a where ... /* here */)); See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags