Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

How do you start studying MySQL?

irl last edited by

How do you start studying mySQL software?
Reply Quote 0
1 Reply Last reply
carriann last edited by

Authors of the book: Maxim Kuznetsov, Igor Simdian. Name: MySQL 5.
Look at this: http://www.helloworld.ru/texts/comp/db/mysql/mysql2/mysql.htm ♪
Reply Quote 0
1 Reply Last reply

mysql 49766

2
Posts

0
Views

Suggested Topics

O

What better and faster than compare int or string?
Software Programming • mysql if data base data streams • • Oba22

2

0
Votes

2
Posts

0
Views

E

The best comparison isint
How does mysql work?
Software Programming • mysql sql • • Demir

2

0
Votes

2
Posts

0
Views

E

Can they (PHP and MySQL server) be on different Companies?Yes! Usually MySQL works through a local loop, but it's a web-based adapter, and nothing prevents MySQL from working and through a real network.Moreover, as the system grows, the removal of OBD into a separate vehicle may be forced by means of a cluster instead of one server. Or... in Docker, for example, it's accepted to have a BDE container separate from the annex container. And the containers interact with each other on the network almost as different machines.If so, what protocol do they communicate?Po https://dev.mysql.com/doc/internals/en/client-server-protocol.html ♪ He doesn't have a separate name, so he's formed at MySQL, and while there are other BDEs that are real, they position themselves as "shared with MySQL protocol."What program, besides the PHP interpreter, can be the client of the MySQL server?Anybody, provided, of course, that it can be installed with the OBD-TCP-connection server (namely TCP, not above) and can implement the MySQL protocol.Of course, there's a whole set of language-based depository libraries that implement this protocol, so it's usually enough to connect the library and start work. And since one of the official depository libraries is written on C, it can be attached to almost every programming language.Why would logic and password be introduced when mysql monitor?Because the OBD won't allow access. It's a client. And the server needs to be presented before work starts to determine the client's privilege.A host can be introduced.\h) Can I work with mysql server when the client is on one computer and the server mysql is on another computer?Key h That's what I need. Really, you should be able to reach the port where MySQL works. As many as they saw the different MySQL, they only listen to the local loop and the external connections don't take. For safety reasons, of course. This does not prevent this port from slipping through the SSH-tonnel, where the compound will be seen at the end of the local car. SSH is relatively secure.
Docker - Mysql + PHP error on time to connect with mysql
Software Programming • doc languageker doc languageker c languag • • Analeea

2

0
Votes

2
Posts

0
Views

Your mysql will not be accessible via localhost (127.0.0.1) because it is in another https://www.docker.com/what-container , this container works as a stand-alone insulation of services,environment and network. There are 2 ways to do since you are using https://docs.docker.com/compose/ : you can try to access using db (name of your mysql container) as hostname changing in docker-compose. _links: - mysql:mysql And in PHP:define( 'MYSQL_HOST', 'mysql' ); Or then set a ip so that the containers converge using the previously defined ips:version: "3.0" networks: mynet: driver: bridge ipam: config: - subnet: 10.2.0.0/16 services: php: build: . ports: - "8082:80" volumes: - ./www:/var/www/html links: - mysql:mysql networks: mynet: ipv4_address: 10.2.0.2 mysql: image: mysql:5.7 ports: - "3306:3306" volumes: - ./var/lib/mysql:/var/lib/mysql environment: - MYSQL_ROOT_PASSWORD=phprs - MYSQL_DATABASE=phprs networks: mynet: ipv4_address: 10.2.0.3 Within the networks group a network was created called "mynet" it uses the bridge drive, which means that this network is visible to the host and will use that same network to connect to external networks to the host. In the service group the network property was added and a ipv4 was set for each service.
K

update mysql attribute according to a day (12/12/2019) cakephp, mysql
Software Programming • mysql mysqli cakephp c languageakephp 2 c languageakephp 3 • • Kadir

2

0
Votes

2
Posts

0
Views

You can create an event.An event is a task performed based on a predefined schedule, so sometimes it is referred to as a scheduled event. A procedure runs only when it is called directly, a trigger runs when an event associated with a table occurs, such as an insertion, update or deletion event. Already an event can be run at regular time intervals one or more times. The event is also known as "temporary trigger" because it is triggered by time.An event is similar to a cron activity in UNIX or to a task scheduler in Windows. You can use events in many cases, such as optimizing database tables, clear logs, archive data or generating complex reports outside peak hours.Starting the event scheduler on MySQL.By default, the event scheduler is not enabled. To enable and start scheduling events, you need to run the following command:SET GLOBAL event_scheduler = ON; To disable the event scheduler run the command:SET GLOBAL event_scheduler = OFF; Creating new events MySQLCreating an event is similar to creating other database objects such as procedures or triggers. An event is a named object that contains instructions SQL.Syntaxe.CREATE [DEFINER = user] EVENT [IF NOT EXISTS] nome_do_evento ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO corpo_do_event; schedule: AT timestamp [+ INTERVAL intervalo] ... | EVERY intervalo [STARTS timestamp [+ INTERVAL intervalo] ...] [ENDS timestamp [+ INTERVAL intervalo] ...] intervalo: quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE | WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE | DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND} CREATE EVENT requires privilege EVENT for the scheme in which the event should be created. The clause ON SCHEDULE determines when and how often and for how long the action defined in defined body_do_event repeats itself. This clause takes one of the two forms:AT timestamp which is used for a unique event. It specifies that the event is executed only once on the date and time provided by timestamp or should be an expression that is resolved to a date and time value. You can use a type value DATETIME or TIMESTAMPfor that purpose. EVERY which is used to repeat actions in a regular interval. The clause EVERY may contain a `STARTS clause followed by a timestamp that indicates when the action should start repeating itself. It may also contain an ENDS clause followed by a timestamp that informs MySQL when the event should stop repeating itself. The minimum requirements for a declaration CREATE EVENT valid are as follows:The keywords CREATE EVENT plus a unique event name, that uniquely identifies the event in a database scheme.A clause ON SCHEDULE that determines when and how often the event runs.A clause DO which contains the SQL statement to be executed by event.To rule out the event use the statement DROP EVENT: DROP EVENT [IF EXISTS] nome_do_evento For more details about the syntax CREATE EVENT https://dev.mysql.com/doc/refman/8.0/en/create-event.html For more details about the syntax DROP EVENT https://dev.mysql.com/doc/refman/8.0/en/drop-event.html AnswerApplying your question what I can offer is a superficial example of an event that every day checks the customer table and if the payment is 0 it changes the customer's status to debtor, since no specific data on the data format were presented in your question:CREATE EVENT verificarEstatus ON SCHEDULE EVERY DAY STARTS CURRENT_TIMESTAMP DO UPDATE alugueis.clientes SET status = "DEVEDOR" WHERE pagamento = 0; This event starts checking on 12/12/2019:CREATE EVENT verificarEstatus ON SCHEDULE EVERY DAY STARTS TIMESTAMP('2019-12-12') DO UPDATE alugueis.clientes SET status = "DEVEDOR" WHERE pagamento = 0; This event starts today the verification and ends on 12/12/2019:CREATE EVENT verificarEstatus ON SCHEDULE EVERY DAY STARTS CURRENT_TIMESTAMP ENDS TIMESTAMP('2019-12-12') DO UPDATE alugueis.clientes SET status = "DEVEDOR" WHERE pagamento = 0;
How to make a python program start from the start of the raspberry SO?
Software Programming • python tkinter raspberry pi • • emmalee

2

0
Votes

2
Posts

0
Views

Edit the file /etc/rc.local and add the call to the script there.Edit rc.local: sudo nano /etc/rc.localAdd the call to the script where you want it to go (always before exit 0(c): sudo python /ruta/al/script.pyIf your program has an infinite loop or is not going to end, you must add a & not to block the start of the operating system. In that case the previous step would be: sudo python /ruta/al/script.py &.The script will run before other services, I don't know if it's worth it, or you need to have the system already prepared.Another similar option is the same above, but in the file .bashrc (on your user's route, probably /home/pi/.bashrc). In this case the script would run both at the start of the operating system, and every time you open a terminal, so it may not be worth it.Another option is to add it to the folder init.dBut it's more complex. You can search for details on the internet if you need it.And another option is to use crontab, also search on the internet what it is and research a little and you will find how to run the script when lighting the Raspberry Pi
S

MySQL : Are hash indices useless?
SQL, Database Testing • mysql database rec languageomme database agnostic languag • • Saumya

2

0
Votes

2
Posts

0
Views

F

A BTree index is arguably better than a Hash index. A BTree can efficiently handle "ranges", whereas Hash is useless for such. For "point queries" they are about equivalent. As for MEMORY, the allure is the speed of access. However, the caching of disk blocks makes any other Engine nearly as good in many production situations. In a survey of over 1000 tables discussed on forums.mysql.com, only 6 were MEMORY. I suggest that says that MEMORY is only very rarely the 'engine of choice'. The lack of persistence makes MEMORY a non-starter. As a "cache", Redis, memcached, Memory, etc, have appeal. But InnoDB, for example, has a builtin cache, and it is usually inefficient to put a cache in front of a cache. Perhaps you are thinking of some niche usage where MEMORY is well suited?
D

Why is a full-text search of mySQL putting the processor up?
Software Programming • mysql mysqli • • derk

2

0
Votes

2
Posts

0
Views

K

You need to look through the team. EXPLAINit will indicate how a request will be implemented For example:EXPLAIN SELECT * FROM table1 WHERE MATCH(`name`,`model`,`vendor`) AGAINST('samsung galaxy S10' IN BOOLEAN MODE) LIMIT 10; Details http://www.mysql.ru/docs/man/EXPLAIN.html You probably have a lot of tapes on the pole. vendor containing samsungAnd you've got a huge number of records, and then only 10 grand of them.
I started studying Java Script, and I'm having a problem with my code (from an exercise). And I have no idea how to solve the problem
Software Programming • javascript node.js • • emmalee

2

0
Votes

2
Posts

0
Views

Y

The problem occurs because your code is entering the following condition:else if(x !== undefined && y !== undefined) That's because the two checks if are satisfied so that it is executed, to resolve this incident you may include a third check in this if, similar to that in the previous conditions, where the third value is verified (in this case z) equals undefinedelse if(x !== undefined && y !== undefined && z === undefined)
D

compare dates within the sql query
Software Programming • mysql sql pdo • • Duquan

2

0
Votes

2
Posts

0
Views

Is that something like that?SELECT aluno,title , dt_banco FROM liberar WHERE DATE_ADD(dt_banco, INTERVAL 10 DAY) < CURDATE() Basically the query is getting all the table records liberar in which the value of the column dt_banco + 10 days is less than the current date.
MYSQL No
Software Programming • mysql linux c languageents • • carriann

2

0
Votes

2
Posts

0
Views

J

Talk, bitch!I managed to solve the problem... It seems that SELINUX was stopping initiation, creating some kind of restriction. For those who have the same problem just use:$ setenforce 0Valeu!
R

How do I make a "yes" show to me each one who finds the first module of each course?
Software Programming • php mysql sql • • Rossere

2

0
Votes

2
Posts

0
Views

F

can be solved with an auxiliary variableexample:$sqlModulos = "SELECT * FROM moduloscurso INNER JOIN curso WHERE moduloscurso.idCurso=curso.idCurso ORDER BY moduloscurso.idCurso"; mysqli_select_db($conn,'bdaita'); $ret = $conn->query($sqlModulos); $i=1; $moduloAux=""; while ($row = mysqli_fetch_array($ret, MYSQLI_ASSOC)) { $n = $row['nombreCurso']; $nn = $row['nombreModulo']; echo $n.' '; echo $nn.(($moduloAux!=$row['nombreCurso'])?'SI':' no').' '; $i++; $moduloAux=$row['nombreCurso']; } You could also handle the module id. $moduloAux=0; while ($row = mysqli_fetch_array($ret, MYSQLI_ASSOC)) { $n = $row['nombreCurso']; $nn = $row['nombreModulo']; echo $n.' '; echo $nn.(($moduloAux!=$row['idCurso'])?'SI':' no').' '; $i++; $moduloAux=$row['idCurso']; }
F

Where is the cache for the MySQL caching_sha2_password auth plugin stored?
SQL, Database Testing • mysql authentication mysql 8.0 • • fbio

2

0
Votes

2
Posts

0
Views

M

'when there exists a cached copy of the password hash in memory' (ref). So its all in memory. FLUSH PRIVILEGES can clear it
S

Apache does not start
Software Programming • apache mac languageos xampp • • simrah

2

0
Votes

2
Posts

0
Views

/etc/hostsTry adding the following entry to the file:127.0.0.1 myMacBook-Air.local Reference: Similar Questions and Answers in English SO https://stackoverflow.com/a/52587865/2322778
GeoJSON MultiLineString import to MySQL with SRID/CRS 27700, 'out of range'
SQL, Database Testing • mysql geometry geojson srid • • Alberto

2

0
Votes

2
Posts

0
Views

The way I've found to work around this to use ogr2ogr to import the eastings and northings (in a geojson file). An example code would be as follows: ogr2ogr -f MySQL MySQL:test,user=root import_file_location \ -nln FILENAME -update -overwrite -lco GEOMETRY_NAME=MULTIPOLYGON This will import as British National Grid coordinates, which can then be used to create buffers in MySQL.
K

How do you get a different color from the database?
Software Programming • javascript php mysql jquery css • • kalyn

2

0
Votes

2
Posts

0
Views

O

Like that. Try it. An accidental colour shall be assigned to each company. You can do that in order. <?php include ("connect.php"); $data = mysql_query("SELECT * FROM news"); while($row = mysql_fetch_row($data)){ $color = array("#9FD477", "#46CFB0", "#4FC2E5", "#5E9DE6", "#AD93E6"); $mycolor = array_rand($color) ; echo $row[name]." "; echo ''.$row[text].''; } ?> Order:<?php include ("connect.php"); $data = mysql_query("SELECT * FROM news"); $i = 0; while($row = mysql_fetch_row($data)){ if ($i == 5) $i = 0 ; $color = array("#9FD477", "#46CFB0", "#4FC2E5", "#5E9DE6", "#AD93E6"); echo $row[name]." "; echo '' . $row[text] . ''; $i++; } ?>

How do you start studying MySQL?

Suggested Topics

What better and faster than compare int or string? Software Programming • mysql if data base data streams • • Oba22

How does mysql work? Software Programming • mysql sql • • Demir

Docker - Mysql + PHP error on time to connect with mysql Software Programming • doc languageker doc languageker c languag • • Analeea

update mysql attribute according to a day (12/12/2019) cakephp, mysql Software Programming • mysql mysqli cakephp c languageakephp 2 c languageakephp 3 • • Kadir

How to make a python program start from the start of the raspberry SO? Software Programming • python tkinter raspberry pi • • emmalee

MySQL : Are hash indices useless? SQL, Database Testing • mysql database rec languageomme database agnostic languag • • Saumya

Why is a full-text search of mySQL putting the processor up? Software Programming • mysql mysqli • • derk

I started studying Java Script, and I'm having a problem with my code (from an exercise). And I have no idea how to solve the problem Software Programming • javascript node.js • • emmalee

compare dates within the sql query Software Programming • mysql sql pdo • • Duquan

MYSQL No Software Programming • mysql linux c languageents • • carriann

How do I make a "yes" show to me each one who finds the first module of each course? Software Programming • php mysql sql • • Rossere

Where is the cache for the MySQL caching_sha2_password auth plugin stored? SQL, Database Testing • mysql authentication mysql 8.0 • • fbio

Apache does not start Software Programming • apache mac languageos xampp • • simrah

GeoJSON MultiLineString import to MySQL with SRID/CRS 27700, 'out of range' SQL, Database Testing • mysql geometry geojson srid • • Alberto

How do you get a different color from the database? Software Programming • javascript php mysql jquery css • • kalyn

What better and faster than compare int or string?
Software Programming • mysql if data base data streams • • Oba22

How does mysql work?
Software Programming • mysql sql • • Demir

Docker - Mysql + PHP error on time to connect with mysql
Software Programming • doc languageker doc languageker c languag • • Analeea

update mysql attribute according to a day (12/12/2019) cakephp, mysql
Software Programming • mysql mysqli cakephp c languageakephp 2 c languageakephp 3 • • Kadir

How to make a python program start from the start of the raspberry SO?
Software Programming • python tkinter raspberry pi • • emmalee

MySQL : Are hash indices useless?
SQL, Database Testing • mysql database rec languageomme database agnostic languag • • Saumya

Why is a full-text search of mySQL putting the processor up?
Software Programming • mysql mysqli • • derk

I started studying Java Script, and I'm having a problem with my code (from an exercise). And I have no idea how to solve the problem
Software Programming • javascript node.js • • emmalee

compare dates within the sql query
Software Programming • mysql sql pdo • • Duquan

MYSQL No
Software Programming • mysql linux c languageents • • carriann

How do I make a "yes" show to me each one who finds the first module of each course?
Software Programming • php mysql sql • • Rossere

Where is the cache for the MySQL caching_sha2_password auth plugin stored?
SQL, Database Testing • mysql authentication mysql 8.0 • • fbio

Apache does not start
Software Programming • apache mac languageos xampp • • simrah

GeoJSON MultiLineString import to MySQL with SRID/CRS 27700, 'out of range'
SQL, Database Testing • mysql geometry geojson srid • • Alberto

How do you get a different color from the database?
Software Programming • javascript php mysql jquery css • • kalyn