a1iraxa

MySQL Cheat Sheet

TOC

• General
• Users, privileges
• Table structure
• Relations
• Misc
• Resources

a1iraxa

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

• Mac /usr/local/mysql/bin
• Windows /Program Files/MySQL/MySQL version/bin
• Xampp /xampp/mysql/bin

Add mysql to your PATH

a1iraxa

class App extends React.Component {
  render() {
    return (
     bla
    )
  }
}

const element = <App />

a1iraxa

import React, { Component } from 'react';

import TextField from 'components/base/TextField';

const WAIT_INTERVAL = 1000;
const ENTER_KEY = 13;

export default class TextSearch extends Component {
    constructor(props) {
        super();

a1iraxa

macOS High Sierra Setup: Homebrew + Apache + PHP + MariaDB + SSL

Homebrew Installation

First let's install Homebrew.

$ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

a1iraxa

Homebrew build logs for php on macOS 10.15.3
Build date: 2020-03-28 02:36:40

a1iraxa

Homebrew build logs for exolnet/deprecated/[email protected] on macOS 10.15.3
Build date: 2020-03-28 02:56:40

a1iraxa

Remove MySQL completely

1. Open the Terminal

2. Use mysqldump to backup your databases

3. Check for MySQL processes with: ps -ax | grep mysql

4. Stop and kill any MySQL processes

5. Analyze MySQL on HomeBrew:

brew remove mysql

a1iraxa

/******************************************
 * get latest post
 * use in loop if ( is_latest() ) { stuff; }
 ******************************************/	
function is_latest() {
    global $post;
    $loop = get_posts( 'numberposts=1' );
    $latest = $loop[0]->ID; 
    return ( $post->ID == $latest ) ? true : false;
}	

a1iraxa

<?php # -*- coding: utf-8 -*-
/*
Plugin Name: All Actions List
Description: Lists all actions run during one request.
Version:     1.0
Required:    3.1
Author:      Thomas Scholz
Author URI:  http://toscho.de
License:     GPL
*/