mysql tag

409 questions

1 answers
42 views
0

MAMP can't do mysqli

<?phpdefine(HOSTNAME,localhost);define(USERNAME,root);define(PASSWORD,root);define(DB_NAME,testDB);$conn = new mysqli(HOSTNAME, USERNAME, PASSWORD, DB_NAME);if($conn->connect_errno) { echo(<b...

php mysql

2 years ago

3 answers
37 views
0

To count the number of rows in a table

Hello!When I want to know the total number of mysql's table Using count (*) is too slow when there is a lot of data...select TABLE_ROWS from information_schema.tables where table_name = 'table name';Y...

mysql

2 years ago

1 answers
109 views
0

I made a login form with HTml, but I don't know how to sign up and put it in db.

I made a login form with HTml, but I don't know how to sign up and put it in db.How can I make it easier?

javascript mysql login

2 years ago

1 answers
31 views
0

Sum of 20 digits in MySQL

Hello, I'm a beginner developer.In MYSQL, if you add up to 20 characters of 300 digits, as shown below,substring('12111111111111111111122111111111111111111211111111111111111112111111111111111111121111...

mysql summation

2 years ago

1 answers
42 views
0

html grammar in php grammar, how to solve it easily when mixing php grammar in html grammar

I'm practicing how to use php, html, and mysql to sign up for a web page Php Grammar HTml Grammar Mysql Grammar is not that difficult, but like the example below,Combination? It's so hard to mix itSom...

html php mysql javascript

2 years ago

1 answers
95 views
0

Oracle is converting to mysql, but the query is too complicated.

Converting from Oracle to mysql...select days.mdate , ifnull(login_cnt,0) as login_cnt , ifnull(logout_cnt,0) as logout_cnt from ( select '2016-06-16' as mdate from ts_user where limit 1,1 ) days left...

oracle mysql

2 years ago

1 answers
145 views
0

Developing node.js. What is the advantage of not using Sequelize (ORM) when using DB?

Developing node.js. I have two years of experience in mssql.Initially, the db part was developed using the mysql module.But I found out that it's called Sequelize.js, so I've been using it.It was a li...

sequelize.js node.js mysql mariadb orm

2 years ago

1 answers
32 views
0

If you say mysql.server start, you die immediately. Help me.

I'm using MacBook Pro Retina Elkepitane.I installed mysql with brew and ran it, but it didn't work, so I started mysql.server. And thenERROR! The server quit without updating PID file (/usr/local/var/...

mysql

2 years ago

1 answers
36 views
0

[Node.js] If logged in, if not.

Hi, everyone. Recently, I've been implementing a page with node.js.If I log in this part, I want to change it to log out. I have no idea how. The advice to use cookies didn't help much.I am using pass...

node.js mysql

2 years ago

1 answers
44 views
0

Django+Mysql+Apache2 Security Measures

Hi, everyone.I'm running a simple website with a long story.However, not long ago, the sql injection attack wiped out both DB and server settings and robbed Linux of administrator rights.So I had to b...

django mysql

2 years ago

- 28 -

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