mysql tag

409 questions


1 answers
46 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...

2 years ago

3 answers
43 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...

2 years ago

1 answers
114 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?

2 years ago

1 answers
36 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...

2 years ago

1 answers
46 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...

2 years ago

1 answers
103 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...

2 years ago

1 answers
159 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...


1 answers
37 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/...

2 years ago

1 answers
41 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...

2 years ago

1 answers
49 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...

2 years ago
« - 28 - »

© 2024 OneMinuteCode. All rights reserved.