mysql tag

409 questions

3 answers
99 views
0

If you set the MySQL password with mysql_config_editor, the file size of the mysqldump result is 0 only when you run the sh file via crontab.

environment·CentOS·MySQL 5.6...password is set in mysql_config_editor·Linux username...testThe following command creates the file as expected.sh hoge.sh▼hoge.sh mysqldump --single-transaction-u databa...

mysql linux shellscript sh

2 years ago

2 answers
49 views
0

I don't know the grammar error in php...

The error appears as follows: It seems to be a grammatical error, but is it written incorrectly?Error: Parse error: syntax error, unexpected '$_SESSION'(T_VARIABLE), expecting', 'or'; 'in/var/www/html...

php mysql

2 years ago

2 answers
46 views
0

Compare SQL to PHP arrays

Programming with PHP and MySqlThe $data array contains id (unique), date.Insert this data into the MySQL tableIf MySQL already has the same date, you want to exclude that $data and insert the data int...

php mysql sql

2 years ago

1 answers
67 views
0

I want to delete all tags in the string in the SQL regular expression.

Below is the data from the post_content column (type=LONGTEXT) in the wp_posts table.target data:<h1id=title1>h1</h2><a href=#title1>aaa</a><a href=#title2>bbb</a>&...

mysql sql regular-expression

2 years ago

1 answers
49 views
0

I want to export the results of database PHP execution using Mysql as an html file.

The database uses Mysql, but I would like to export PHP results as an html file, but echo<licclass='active'><a href='special.php?page={$i}'>{$i}</a>><</li>;;;;{/code>{ipo...

php mysql

2 years ago

1 answers
52 views
0

Is it possible to link and migrate data between AWS RDS for MySQL and Google Cloud SQL?

Is it possible to collaborate and migrate data between AWS RDS for MySQL (MariaDB) and GCP Cloud SQL?How do I migrate data from RDS for MySL in AWS to Cloud SQL for MySQL in GCP? Is there any problem ...

mysql aws

2 years ago

2 answers
127 views
0

Access Denied Error Connecting to Remote mysql with phpmmyadmin

in CentOS(1—Remote server) mysql(2:local server) phpmyadminConfiguring the server configuration (TCP connection).(2) includes php, php-mysql, and apache.The phpmyadmin login screen appears, but enter ...

mysql phpmyadmin

2 years ago

1 answers
53 views
0

Why can't I connect to mySQL database using php?

We use MAMP to develop applications.Initially, it was implemented on MacOS, and php implemented the general process of accessing MySQL-Database.After that, I deployed MAMP to Windows PC and applied th...

php mysql

2 years ago

1 answers
42 views
0

I'd like to put the column of MySQL aggregation next to it.

This is a MySQL aggregation question.Table 1: Number of user itemsMr. A, apple 1Mr. A, Banana 4Mr. A, Orange 2Results: Number of user itemsNumber of itemsNumber of itemsMr. A, apple, banana, orange, 2...

mysql sql

2 years ago

1 answers
45 views
0

Centos fails to launch mysql

When I try to start mysql at the terminal, I get an error similar to the following:ERROR 2002 (HY000): Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2)I tried the following solut...

mysql

2 years ago

- 19 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656