Welcome To Ask or Share your Answers For Others

Recent questions tagged MySQL

0 votes

409 views

1 answer

mysql - Using IS NULL or IS NOT NULL on join conditions - Theory question

Theory question here: Why does specifying table.field IS NULL or table.field IS NOT NULL not work on a join ... What is the reason for this? See Question&Answers more detail:os...

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

0 votes

774 views

1 answer

mysql - Enable binary mode while restoring a Database from an SQL dump

I am extremely new to MySQL and am running it on Windows. I am trying to restore a Database from a ... and data which is not comprehensible. See Question&Answers more detail:os...

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

0 votes

531 views

1 answer

mysql command for showing current configuration variables

Can not find a command that displays the current configuration of mysql from within the database. I know I could look ... is not what I need. See Question&Answers more detail:os...

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

0 votes

674 views

1 answer

mysql - Database/SQL: How to store longitude/latitude data?

Performance question ... I have a database of houses that have geolocation data (longitude & latitude). ... help would be greatly appreacited See Question&Answers more detail:os...

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

0 votes

611 views

1 answer

mysql - How to speed up "select count(*)" with "group by" and "where"?

How to speed up select count(*) with group by? It's too slow and is used very frequently. I have a ... on object_title could not work well. See Question&Answers more detail:os...

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

0 votes

577 views

1 answer

mysql - INSERT INTO .. ON DUPLICATE KEY UPDATE for multiple items

I want to do something like this INSERT INTO t (t.a, t.b, t.c) VALUES ('key1','key2','value') ON ... queries so i really want to avoid that. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Can't reset root password with --skip-grant-tables on ubuntu 16

I am trying to reset the root password following MysqlPasswordReset but when I try to start the server with --skip ... socket file don't exists. See Question&Answers more detail:os...

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

0 votes

653 views

1 answer

mysql - Fill database tables with a large amount of test data

I need to load a table with a large amount of test data. This is to be used for testing performance and ... /junk data for my database table? See Question&Answers more detail:os...

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

0 votes

604 views

1 answer

mysql - SQL UPDATE all values in a field with appended string CONCAT not working

Here is what I want to do: current table: +----+-------------+ | id | data | +----+---- ... bluehost (I think its version 4.1) Thanks everyone. See Question&Answers more detail:os...

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

0 votes

682 views

1 answer

mysql - DB Schema For Chats?

I need to store chat conversations in a database schema. The way I would use this database is I would post ... suggest a schema for this? See Question&Answers more detail:os...

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

0 votes

766 views

1 answer

mysql - How to update a record using sequelize for node?

I'm creating a RESTful API with NodeJS, express, express-resource, and Sequelize that is used to manage ... a record using Sequelize ORM? See Question&Answers more detail:os...

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

0 votes

504 views

1 answer

mysql - Change a column type from Date to DateTime during ROR migration

I need to change my column type from date to datetime for an app I am making. I don't care about the data ... developed. How can I do this? See Question&Answers more detail:os...

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

0 votes

645 views

1 answer

mysql - Apache not starting on MAMP Pro

Apache wont start and it throws an error: OR Apache couldn't be started. Please check the log file for ... perfectly fine. Any suggestions? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Mysqldump only tables with certain prefix / Mysqldump wildcards?

I have this huge, messy database I am cleaning up. It houses 500+ tables, which is the result of combining Magento ... to do this, if possible. See Question&Answers more detail:os...

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

0 votes

666 views

1 answer

mysql - How to see full query from SHOW PROCESSLIST

When I issue SHOW PROCESSLIST query, only first 100 characters of the running SQL query are returned in the ... are longer than 100 characters) See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - how to mysqldump remote db from local machine

I need to do a mysqldump of a database on a remote server, but the server does not have mysqldump ... -u mysql_user -p database_name table_name See Question&Answers more detail:os...

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

0 votes

626 views

1 answer

mysql - Your password does not satisfy the current policy requirements

I want to create a new user in mysql with syntax: create user 'demo'@'localhost' identified by 'password'; But it ... work. How can I fix this? See Question&Answers more detail:os...

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

0 votes

682 views

1 answer

mysql - where is the fault in my sql code?

'SELECT * FROM t1 JOIN t2 ON t1.wid = t2.wid WHERE t2.wid IS NULL LIMIT ' . $number; This code nothing ... why i do not take values back?? See Question&Answers more detail:os...

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

0 votes

520 views

1 answer

mysql - JDBC prepareStatement doesn't work

I'm trying to use the prepareStatement function. The code is below. After it executes, it returns me a ... resultSet = statement.executeQuery(); See Question&Answers more detail:os...

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

0 votes

571 views

1 answer

mysql - how to group result in subgroups in php

Hey everyone. While I'm trying to learn some PHP and mySQL, I ran into a problem that I've had some difficulty in ... ----------+ Thank you See Question&Answers more detail:os...

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

0 votes

859 views

1 answer

mysql - Left join with default relation

Need to find all words with their Italian translation, if Italian doesn't exist, then need with Spanish ( ... exists conditions in my situation See Question&Answers more detail:os...

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

0 votes

937 views

1 answer

mysql - Arabic characters doesn't show in phpMyAdmin

So I am currently working on a certain project where I need to create a database in which its records will hold ... solve it ? Thanks in advance See Question&Answers more detail:os...

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

0 votes

696 views

1 answer

mysql - Create trigger error: invalid syntax

SQL query: CREATE TRIGGER tg_newuser_insert BEFORE INSERT ON tbl_newuser FOR EACH ROW BEGIN INSERT INTO tbl_seq VALUES (NULL ... END' at line 6 See Question&Answers more detail:os...

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

0 votes

432 views

1 answer

mysql - Constraint to prevent violation of FK constraint in a third table

I can implement the constraints that I want in stored procs, but I'm wondering if I can define a set ... ) ENGINE=InnoDB DEFAULT CHARSET=latin7 See Question&Answers more detail:os...

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

0 votes

588 views

1 answer

mysql - PHP changing old mysql_query to PDO

I have some old mysql_query queries in my code which i want to convert in to PDO but am struggling to get to work ... ("Location: view.php"); } See Question&Answers more detail:os...

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

0 votes

605 views

1 answer

mysql - Laravel 4.2 BIT datatype issue

there is a bit(1) type column in database table. but its not working as i expected. problem is $invitee = ... if someone can explain the issue. See Question&Answers more detail:os...

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

0 votes

570 views

1 answer

mysql - SQL NOT BETWEEN query

Thanks in advance for any advice or tips! I have a booking table in a mysql database, table1. It contains a ... it to work! Any suggestions? See Question&Answers more detail:os...

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

0 votes

593 views

1 answer

mysql - Group by substring

I have a field with text like "/site/index?sid=18&sub=321333&tid=site.net&ukey=1234543254". How can I group it by ... the end of line and etc.) See Question&Answers more detail:os...

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

Page:

« prev
1
...
29
30
31
32
33
34
35
36
37
38
39
...
105
next »

...