Recent questions tagged MySQL

0 votes

877 views

1 answer

mysql - Command to drop all columns in a database that have prefix test_ to run

How I can run a command in phpMyAdmin which will drop all columns in a database that have the prefix test_. See Question&Answers more detail:os...

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

0 votes

631 views

1 answer

mysql - I need to join table from other database and sometimes other server

My project has its own database. Also, I use table of users, which is on other database. Two offices have their ... this scenario? I use MySQL. See Question&Answers more detail:os...

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

0 votes

889 views

1 answer

mysql - ssh first with mysqldb in python

I'm trying to connect to a MySQL database on a remote server using MySQLdb in python. The problem is ... Can anyone make any recommendations? See Question&Answers more detail:os...

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

0 votes

895 views

1 answer

mysql - Laravel 5 using OR condition with BETWEEN

Hi can anyone help me building below query in laravel Eloquent i am really confuse in using OR condition with between ... no idea how to use OR See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - find missing dates from date range

I have query regarding get the dates which are not exists in database table. I have below dates in database. ... for looking and giving time. See Question&Answers more detail:os...

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

0 votes

797 views

1 answer

mysql - Row numbering with p:dataTable

I have this query: SELECT @rownum:=@rownum+1 'no', m.title, m.author, REPLACE(SUBSTRING_INDEX(m. ... using purely the CriteriaBuilder method? See Question&Answers more detail:os...

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

0 votes

837 views

1 answer

mysql - Using pdo in php with stored procedure

I have a simple stored procedure in MySQL database: DELIMITER $$ CREATE DEFINER=`vidhu`@`%` PROCEDURE `test`( ... FETCH_ASSOC); echo $result[0]; See Question&Answers more detail:os...

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

0 votes

925 views

1 answer

mysql - Codeigniter Insert Multiple Rows in SQL

I am fresh to Codeigniter. I have a form which looks something like this. <tr> <td><input type="text" name=" ... to insert all data at one go? See Question&Answers more detail:os...

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

0 votes

806 views

1 answer

mysql - Changing a SQL column title via query

I have the following query: SELECT product_description.name, product.quantity,product.price,product_option_value_description. ... this option. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - How can I create and load a second database in ddev?

I have a Drupal multisite that needs to have one database for each site, and want it to run in ddev, but ddev ... can I get a second database? See Question&Answers more detail:os...

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

0 votes

938 views

1 answer

mysql - Adjusting for the default time-zone setting on RDS

We recently switched to an RDS instance and noticed that bunch of our database tasks were getting triggered 4 ... used any other solutions ? See Question&Answers more detail:os...

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

0 votes

801 views

1 answer

mysql - What to do if the auto-increment value reaches its limit?

I am doing a little research for a problem that might occur someday. Lets say you have an InnoDB MySQL ... number can be generated anymore. See Question&Answers more detail:os...

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

0 votes

850 views

1 answer

mysql - Rails on OSX 10.11 El Capitan: Library not loaded: libmysqlclient.18.dylib

Since I upgraded OSX to 10.11, I can't use MySQL with my Rails app anymore: $ rails s /Users/josh/ ... and versions changed since solving, etc. See Question&Answers more detail:os...

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

0 votes

868 views

1 answer

mysql - Number of DB connections opened

Can anyone know the way to get the number of DB connection being used , in MYSQL 5.0 See Question&Answers more detail:os...

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

0 votes

869 views

1 answer

mysql - get number of rows with pdo

I have a simple pdo prepared query: $result = $db->prepare("select id, course from coursescompleted where person ... or explanation for this? See Question&Answers more detail:os...

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

0 votes

729 views

1 answer

mysql - How can I pass an "array" of values to my stored procedure?

I want to be able to pass an "array" of values to my stored procedure, instead of calling "Add value" ... MySQL, I haven't decided yet. See Question&Answers more detail:os...

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

0 votes

805 views

1 answer

mysql - Liquibase - how to generate a changelog for existing database

I'm trying to use liquibase for generating the changeLog, starting by snapshoting the current state of my database. ... 10 views, data... See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - ERROR 1118 (42000) Row size too large

I know that this question has been asked (and answered) many times, but none of them appear to be the same ... around it? Thanks in advance! See Question&Answers more detail:os...

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

0 votes

834 views

1 answer

mysql - String truncate on length, but no chopping up of words allowed

I want to limit a string field length in MYSQL on a certain length, but I don't want any chopping up of ... in MYSQL in a simple statement. See Question&Answers more detail:os...

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

0 votes

763 views

1 answer

mysql update increment int field that is null

I have a very large table with two INT columns that are null on Default. This is a problem because since they ... the Default to none from null See Question&Answers more detail:os...

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

0 votes

837 views

1 answer

mysql - How do I know how many rows a Perl DBI query returns?

I'm trying to basically do a search through the database with Perl to tell if there is an item with a certain ... if it returned rows or now? See Question&Answers more detail:os...

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

0 votes

785 views

1 answer

mysql - How do FULLTEXT INDEXES on multiple columns work?

When adding a FULLTEXT INDEX on 3 columns, does that add 1 single index on 3 columns, or does it add 3 ... ADD FULLTEXT 2colsIndex (col1,col2); See Question&Answers more detail:os...

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

0 votes

721 views

1 answer

mysql - Removing unwanted character from column

I would like to remove the character '?' from column Column Name: asds?dfgdfg dfgwer?werwer And Want to ... Name: asds dfgdfg dfgwer werwer See Question&Answers more detail:os...

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

0 votes

705 views

1 answer

mysql - Does the space occupied by deleted rows get re-used?

I have read several times that after you delete a row in an InnoDB table in MySQL, its space is not reused, ... table here, or is it paranoia? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Python: How do I get time from a datetime.timedelta object?

A mysql database table has a column whose datatype is time ( http://dev.mysql.com/doc/refman/5.0/en/time.html ). ... ). Note: I use Python 2.4 See Question&Answers more detail:os...

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

0 votes

835 views

1 answer

mysql - How to SELECT the last 10 rows of an SQL table which has no ID field?

I have an MySQL table with 25000 rows. This is an imported CSV file so I want to look at the last ten ... Excel) all fields are of type TEXT See Question&Answers more detail:os...

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

0 votes

829 views

1 answer

mysql - PHP Try and Catch for SQL Insert

I have a page on my website (high traffic) that does an insert on every page load. I am curious of the ... #10'); mysql_close($conn); ... See Question&Answers more detail:os...

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

0 votes

947 views

1 answer

mysql - INNER JOIN same table

I am trying to get some rows from the same table. It's a user table: user has user_id and user_parent_id. ... user record and its parent record. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags