Search found 40 matches: refman

Return to advanced search

Re: adduser mysql how?

... ON 'database.*' TO newuser@'%' IDENTIFIED BY 'password'"   oCn:Execute( cSql )  Also see https://dev.mysql.com/doc/refman/8.0/en/create-user.html for full syntax
by nageswaragunupudi
Wed Jun 29, 2022 2:01 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: adduser mysql how?
Replies: 2
Views: 375

Re: Nueva versión de HDO

... puedo conectarme a Mysql mediante ssh? Saludos Hola Horacio, quizás los siguientes enlaces te sirvan: https://dev.mysql.com/doc/refman/8.0/en/windows-and-ssh.html https://juncotic.com/mysql-tunelizando-la-conexion-medio-ssh/ https://linuxize.com/post/mysql-ssh-tunnel/ ...
by Baxajaun
Sun Nov 14, 2021 12:03 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Nueva versión de HDO
Replies: 5
Views: 737

Re: TRIGGER MYSQL

You can do with MySql Event Scheduler.

https://dev.mysql.com/doc/refman/5.7/en ... duler.html

Hope this will help you.

If you still find it difficult, let us know.
by nageswaragunupudi
Thu Nov 11, 2021 8:48 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: TRIGGER MYSQL
Replies: 3
Views: 505

Re: New lLock parameter problem in EditBaseRecord() for MariaDB

https://dev.mysql.com/doc/refman/8.0/en/set-transaction.html https://docs.microsoft.com/pt-br/sql/t-sql/statements/set-transaction-isolation-level-transact-sql?view=sql-server-ver15 https://mariadb.com/kb/pt-br/isolation/ ...
by karinha
Thu Apr 02, 2020 7:38 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: lLock par. problem in EditBaseRecord() for MariaDB - SOLVED
Replies: 38
Views: 4330

Re: libmariadb.dll vs. libmysql.dll

... with MySql server or MariaDB server without any problems. They are fully compatible with each other. Documentation https://dev.mysql.com/doc/refman/5.6/en/c-api-functions.html FWH provided wrappers to all and it is desirable to use FWH connection methods which are fully documented in the ...
by nageswaragunupudi
Tue May 07, 2019 5:49 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: libmariadb.dll vs. libmysql.dll
Replies: 6
Views: 1402

Re: MySQL VS MariaDB

... El siguiente enlace también te puede interesar https://dev.mysql.com/doc/refman/8.0/en/multiple-servers.html Saludos
by Baxajaun
Wed Jun 20, 2018 6:11 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: MySQL VS MariaDB
Replies: 12
Views: 2026

Re: MERGE function/method in MariaDB

Marc Vanzegbroeck wrote:Frances,

Do you mean the update query?
https://dev.mysql.com/doc/refman/8.0/en/update.html



Hi Marc,

In ADS there is MERGE where it insert a record if not exist then update it if exists.
by fraxzi
Wed May 16, 2018 6:08 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: MERGE function/method in MariaDB (SOLVED)
Replies: 5
Views: 716

Re: error al eliminar con tdolphin y mysql

Hola, No existe DELETE con ORDER BY... Kleyber, refuto tu afirmacion...saludos... :shock: https://dev.mysql.com/doc/refman/5.7/en/delete.html Single-Table Syntax DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name [PARTITION (partition_name [, partition_name] ...)] [WHERE where_condition] ...
by joseluisysturiz
Sun Jan 14, 2018 6:16 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: error al eliminar con tdolphin y mysql
Replies: 4
Views: 1118

Re: Saber si es AMP o PM

... es lo que se me ocurre por los momentos, saludos, gracias... :shock: http://mysql.conclase.net/curso/?sqlfun=DATE_FORMAT https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_date-format
by joseluisysturiz
Mon Sep 25, 2017 9:51 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Saber si es AM o PM * SOLUCIONADO *
Replies: 11
Views: 2184

Re: CALCULAR MESES ENTRE 2 PERIODOS

... el año y el mes, concatenarlos antes y se lo pasas a esta funcion...saludos... :shock: Manejadores de fechas en mysql https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_period-diff
by joseluisysturiz
Fri Aug 04, 2017 3:17 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: CALCULAR MESES ENTRE 2 PERIODOS- SOLUCIONADO
Replies: 10
Views: 1609

Re: CALCULAR MESES ENTRE 2 PERIODOS

... PERIOD_DIFF(200905,200811); http://www.w3resource.com/mysql/date-and-time-functions/mysql-period_diff-function.php https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_period-diff
by joseluisysturiz
Thu Aug 03, 2017 7:04 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: CALCULAR MESES ENTRE 2 PERIODOS- SOLUCIONADO
Replies: 10
Views: 1609

Re: FWH 17.03 Work with Remote + Embedded using ADO

Hmpaquito, Maybe you can use FEDERATED Storage Engine -> https://dev.mysql.com/doc/refman/5.7/en/federated-storage-engine.html One way is to use synchronization between servers. That is the best. This is what we do in large organisations. My experience was with ...
by nageswaragunupudi
Mon Mar 20, 2017 1:27 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWH 17.03 Work with Remote + Embedded using ADO
Replies: 7
Views: 1092
Next

Return to advanced search