pra não esquecer…

agosto 7th, 2018

SQL – extraindo domínio do e-mail

Posted by Felipe Olivaes in MySQL

SUBSTR(Email, Locate(‘@’, Email)+1) as Provedor

agosto 6th, 2014

group by x distinct

Posted by Felipe Olivaes in MySQL

Group by

=) com aspira e caramujo

março 29th, 2011

Mysql performance – MaatKit

Posted by Felipe Olivaes in MySQL

http://www.petefreitag.com/item/724.cfm

included in Maatkit:

* mk-archiver Archive rows from a MySQL table into another table or a file.
* mk-audit Analyze, summarize and report on MySQL config, schema and operation
* mk-checksum-filter Filter checksums from mk-table-checksum.
* mk-deadlock-logger Extract and log MySQL deadlock information.
* mk-duplicate-key-checker Find duplicate indexes and foreign keys on MySQL tables.
* mk-fifo-split Split files and pipe lines to a fifo without really splitting.
* mk-find Find MySQL tables and execute actions, like GNU find.
* mk-heartbeat Monitor MySQL replication delay.
* mk-kill Kill MySQL queries that match certain criteria.
* mk-loadavg Watch MySQL load and take action when it gets too high.
* mk-log-player Split and play MySQL slow logs.
* mk-parallel-dump Dump sets of MySQL tables in parallel.
* mk-parallel-restore Load files into MySQL in parallel.
* mk-profile-compact Compact the output from mk-query-profiler.
* mk-query-digest Parses logs and more. Analyze, transform, filter, review and report on queries.
* mk-query-profiler Execute SQL statements and print statistics, or measure activity caused by other processes.
* mk-show-grants Canonicalize and print MySQL grants so you can effectively replicate, compare and version-control them.
* mk-slave-delay Make a MySQL slave server lag behind its master.
* mk-slave-find Find and print replication hierarchy tree of MySQL slaves.
* mk-slave-move Move a MySQL slave around in the replication hierarchy.
* mk-slave-prefetch Pipeline relay logs on a MySQL slave to pre-warm caches.
* mk-slave-restart Watch and restart MySQL replication after errors.
* mk-table-checksum Perform an online replication consistency check, or checksum MySQL tables efficiently on one or many servers.
* mk-table-sync Synchronize MySQL tables efficiently.
* mk-upgrade Execute SQL statements against two MySQL servers and compare the results.
* mk-visual-explain Format EXPLAIN output as a tree.

agosto 20th, 2009

database hacks

Posted by Felipe Olivaes in Firebird, MS SQL Server, MySQL, Postgre SQL

realmente muito bom, dica do ara”ú”jo! =)

http://pentestmonkey.net/blog/mysql-sql-injection-cheat-sheet/
http://pentestmonkey.net/blog/postgres-sql-injection-cheat-sheet/
http://pentestmonkey.net/blog/oracle-sql-injection-cheat-sheet/
http://pentestmonkey.net/blog/mssql-sql-injection-cheat-sheet/
http://pentestmonkey.net/blog/ingres-sql-injection-cheat-sheet/
http://pentestmonkey.net/blog/db2-sql-injection-cheat-sheet/
http://pentestmonkey.net/blog/informix-sql-injection-cheat-sheet/

crack mysql hash password:
http://www.openwall.com/john/

agosto 6th, 2009

erro foreign key mysql

Posted by Felipe Olivaes in MySQL

Cannot add or update a child row: a foreign key constraint fails

Só adicionar isso no início do arquivo SQL:

set foreign_key_checks = 0;

fevereiro 25th, 2009

corrigindo o error 150 (#10005) no MySQL

Posted by Felipe Olivaes in MySQL

– Todas as tabelas do tipo InnoDB;
– Deve haver um indíce na tabela de origem e destino corresponde a nova chave estrangeira;
– Não são suportados para este tipo de relacionamento, campos text e blob;
– Os campos devem ter o mesmo tipo (em todas as características);
– Atenção, até UNSIGNED faz diferença;

abril 24th, 2008

erros do mysql

Posted by Felipe Olivaes in MySQL

mysql error?
ta aí a lista pra ref

OS error code 1: Operation not permitted
OS error code 2: No such file or directory
OS error code 3: No such process
OS error code 4: Interrupted system call
OS error code 5: Input/output error
OS error code 6: No such device or address
OS error code 7: Argument list too long
OS error code 8: Exec format error
OS error code 9: Bad file descriptor
OS error code 10: No child processes
OS error code 11: Resource temporarily unavailable
OS error code 12: Cannot allocate memory
OS error code 13: Permission denied
OS error code 14: Bad address
OS error code 15: Block device required
OS error code 16: Device or resource busy
OS error code 17: File exists
OS error code 18: Invalid cross-device link
OS error code 19: No such device
OS error code 20: Not a directory
OS error code 21: Is a directory
OS error code 22: Invalid argument
OS error code 23: Too many open files in system
OS error code 24: Too many open files
OS error code 25: Inappropriate ioctl for device
OS error code 26: Text file busy
OS error code 27: File too large
OS error code 28: No space left on device
OS error code 30: Read-only file system
OS error code 31: Too many links
OS error code 32: Broken pipe
OS error code 33: Numerical argument out of domain
OS error code 34: Numerical result out of range
OS error code 35: Resource deadlock avoided
OS error code 36: File name too long
OS error code 37: No locks available
OS error code 38: Function not implemented
OS error code 39: Directory not empty
OS error code 40: Too many levels of symbolic links
OS error code 42: No message of desired type
OS error code 43: Identifier removed
OS error code 44: Channel number out of range
OS error code 45: Level 2 not synchronized
OS error code 46: Level 3 halted
OS error code 47: Level 3 reset
OS error code 48: Link number out of range
OS error code 49: Protocol driver not attached
OS error code 50: No CSI structure available
OS error code 51: Level 2 halted
OS error code 52: Invalid exchange
OS error code 53: Invalid request descriptor
OS error code 54: Exchange full
OS error code 55: No anode
OS error code 56: Invalid request code
OS error code 57: Invalid slot
OS error code 59: Bad font file format
OS error code 60: Device not a stream
OS error code 61: No data available
OS error code 62: Timer expired
OS error code 63: Out of streams resources
OS error code 64: Machine is not on the network
OS error code 65: Package not installed
OS error code 66: Object is remote
OS error code 67: Link has been severed
OS error code 68: Advertise error
OS error code 69: Srmount error
OS error code 70: Communication error on send
OS error code 71: Protocol error
OS error code 72: Multihop attempted
OS error code 73: RFS specific error
OS error code 74: Bad message
OS error code 75: Value too large for defined data type
OS error code 76: Name not unique on network
OS error code 77: File descriptor in bad state
OS error code 78: Remote address changed
OS error code 79: Can not access a needed shared library
OS error code 80: Accessing a corrupted shared library
OS error code 81: .lib section in a.out corrupted
OS error code 82: Attempting to link in too many shared libraries
OS error code 83: Cannot exec a shared library directly
OS error code 84: Invalid or incomplete multibyte or wide character
OS error code 85: Interrupted system call should be restarted
OS error code 86: Streams pipe error
OS error code 87: Too many users
OS error code 88: Socket operation on non-socket
OS error code 89: Destination address required
OS error code 90: Message too long
OS error code 91: Protocol wrong type for socket
OS error code 92: Protocol not available
OS error code 93: Protocol not supported
OS error code 94: Socket type not supported
OS error code 95: Operation not supported
OS error code 96: Protocol family not supported
OS error code 97: Address family not supported by protocol
OS error code 98: Address already in use
OS error code 99: Cannot assign requested address
OS error code 100: Network is down
OS error code 101: Network is unreachable
OS error code 102: Network dropped connection on reset
OS error code 103: Software caused connection abort
OS error code 104: Connection reset by peer
OS error code 105: No buffer space available
OS error code 106: Transport endpoint is already connected
OS error code 107: Transport endpoint is not connected
OS error code 108: Cannot send after transport endpoint shutdown
OS error code 109: Too many references: cannot splice
OS error code 110: Connection timed out
OS error code 111: Connection refused
OS error code 112: Host is down
OS error code 113: No route to host
OS error code 114: Operation already in progress
OS error code 115: Operation now in progress
OS error code 116: Stale NFS file handle
OS error code 117: Structure needs cleaning
OS error code 118: Not a XENIX named type file
OS error code 119: No XENIX semaphores available
OS error code 120: Is a named type file
OS error code 121: Remote I/O error
OS error code 122: Disk quota exceeded
OS error code 123: No medium found
OS error code 124: Wrong medium type
OS error code 125: Operation canceled
MySQL error code 126: Index file is crashed
MySQL error code 127: Record-file is crashed
MySQL error code 128: Out of memory
MySQL error code 130: Incorrect file format
MySQL error code 131: Command not supported by database
MySQL error code 132: Old database file
MySQL error code 133: No record read before update
MySQL error code 134: Record was already deleted (or record file crashed)
MySQL error code 135: No more room in record file
MySQL error code 136: No more room in index file
MySQL error code 137: No more records (read after end of file)
MySQL error code 138: Unsupported extension used for table
MySQL error code 139: Too big row
MySQL error code 140: Wrong create options
MySQL error code 141: Duplicate unique key or constraint on write or update
MySQL error code 142: Unknown character set used
MySQL error code 143: Conflicting table definitions in sub-tables of MERGE table
MySQL error code 144: Table is crashed and last repair failed
MySQL error code 145: Table was marked as crashed and should be repaired
MySQL error code 146: Lock timed out; Retry transaction
MySQL error code 147: Lock table is full; Restart program with a larger locktable
MySQL error code 148: Updates are not allowed under a read only transactions
MySQL error code 149: Lock deadlock; Retry transaction
MySQL error code 150: Foreign key constraint is incorrectly formed
MySQL error code 151: Cannot add a child row
MySQL error code 152: Cannot delete a parent row

setembro 26th, 2007

desconto kinghost

Código promocional Kinghost!

Ganhe 15% de desconto nas 3 primeiras mensalidades na melhor empresa de hospedagem do brasil com toda certeza…

Acesse o link abaixo
http://www.kinghost.com.br/promo/BIGDESCONTO.html
ou digite o código promocional BIGDESCONTO no cadastro

setembro 20th, 2007

Código promocional Kinghost

Código promocional Kinghost!

Ganhe 15% de desconto nas 3 primeiras mensalidades na melhor empresa de hospedagem do brasil com toda certeza…

Acesse o link abaixo
http://www.kinghost.com.br/promo/BIGDESCONTO.html
ou digite o código promocional BIGDESCONTO no cadastro

setembro 18th, 2007

vulnerabilidade PHP <= 4.4.7 / 5.2.3 MySQL/MySQLi, até em safe_mode

Posted by Felipe Olivaes in Apache, MySQL, PHP

resumido rapidinho que estou com pressa…

a vulnerabilidade afeta PHP’s com extensão MySQL e MySQLi….

o erro está utilizando a lib do mysql (que não é monitorada pelo safe_mode), consegue ler um arquivo do servidor…
exemplo:
[php]

[/php]

várias empresas de host estão vulneráveis, mas como eu sempre digo, a melhor hospedagem do brasil é a kinghost, o pessoal já corrigiu essa falha de segurança….

hospede seu site na kinghost e ganhe um desconto:
Ganhe 15% de desconto nas 3 primeiras mensalidades na melhor empresa de hospedagem do brasil com toda certeza…

Acesse o link abaixo
http://www.kinghost.com.br/promo/BIGDESCONTO.html
ou digite o código promocional BIGDESCONTO no cadastro

setembro 14th, 2007

Desconto Hospedagem Kinghost

Posted by Felipe Olivaes in Apache, MS SQL Server, MySQL, PHP, Postfix, Postgre SQL

Código promocional Kinghost!

Ganhe 15% de desconto nas 3 primeiras mensalidades na melhor empresa de hospedagem do brasil com toda certeza…

Acesse o link abaixo
http://www.kinghost.com.br/promo/BIGDESCONTO.html
ou digite o código promocional BIGDESCONTO no cadastro




nuvem de tags:

24 horas acentuação Apache bash benchmark bios boot celular centos charset comando console Download esxi Firebird firefox http importação intel ipod kinghost legenda Linux lost mod_deflate msn mssql MySQL owner Padel PHP placa mãe portabilidade Postgre SQL recovery root password rewrite shell sinuca sql server svn temporada completa veronica mars vmware Windows ícones