racl101 + sql   100

Backup (mysql dump) all your MySQL databases in separate files - Running with Ruby
Really good, simple to understand Bash shell script demonstrating how to backup all the databases in a given mysql server installation into a single file or into separate files (one for each database).
blog  tutorial  howto  example  guide  reference  backup  export  database  dump  sql  files  shell  script  single  separate  mysql  bash 
november 2018 by racl101
mysql - Getting percentage of "Count(*)" to the number of all items in "GROUP BY" - Stack Overflow
Shows how to group rows by a certain column and calculate the percentage of rows containing a certain value out of all the rows in the table. This particular example even has a where clause that filters the rows. So to generalize it for your purposes remove the WHERE clause.
query  Howto  Stackoverflow  groupby  Grouping  Guide  Mysql  SQL  example  percentage  ReferencE  Database 
october 2016 by racl101
mysql - Copy values from one column to another in the same table - Stack Overflow
Shows how to set a column to the values of another column within the same table for every row.
Mysql  Stackoverflow  query  copy  value  column  SQL  Howto  example  update 
july 2015 by racl101
SQL Joins
Simple tutorial explaining the basics of MySQL join
Mysql  Database  Howto  Guide  Reference  SQL  JOIN  example 
july 2015 by racl101
php - MySQL Inner Join Update - Stack Overflow
Shows how to update a column with values from another colunn on another table using an inner join clause. Using this in 091 - LTR Mechanical Ltd website.
example  query  update  SQL  table  column  Howto  inner  Mysql  Stackoverflow  Database  JOIN 
july 2015 by racl101
jv2222/ezSQL · GitHub
Still the greatest PHP MySQL library I've ever used that is not stand alone (not part of any CMS) and not pear or PECL.
github  justinvincent  SQL  mysql  library  PHP  ezsql  Database 
march 2013 by racl101
« earlier      
per page:    204080120160

related tags

accounts  actionscript  administration  advanced  aggregate  all  alter  ansible  antipatterns  api  application  apply  articles  artisan  average  backup  bash  bestpractices  bigint  blog  builder  by  calculate  changes  class  clause  cli  cms  code  codex  column  command  commandline  configuration  connect  constraint  convert  converter  copy  count  counter  create  created  css  custom  data  database  databases  datatypes  date  dates  datetime  db  dba.stackexchange  delete  deployment  design  dev  development  diff  distinct  doctrine  documentation  download  drop  dump  duplicate  duplicates  dzone  each  eloquent  environment  ess  example  execute  explanation  export  expression  ezsql  Fiddle  field  file  filemaker  filemakerpro  files  find  fix  for  foreign  format  foundationdb  framework  fulltext  function  functions  generator  gettingstarted  github  greater  grouby  group  groupby  Grouping  gui  guide  having  homestead  howto  import  injection  inner  innodb  install  int  integer  interface  interview  into  is  java  javascript  join  js  json  justinvincent  key  language  laravel  laravel4  laravel5  learning  left  library  like  limit  line  linux  list  local  log  logging  mac  management  manual  max  mediumint  min  mistakes  modeling  mssql  mysql  mysql5  mysqldump  nettuts  newest  null  number  numeric  nvarchar  occurrences  odbc  oldest  operator  optimization  Oracle  order  orm  osx  overview  paging  pain  password  path  pdo  percentage  performance  php  Plugin  plugins  postgres  postgresql  prefix  procedure  programming  queries  query  rackspacecloud  raw  record  reference  Remove  restore  Rlike  rollbacks  root  row  rows  script  scripts  search  searching  security  select  Selectable  separate  server  Set  shell  single  slideshow  software  sources  sql  sqlbuddy  SQLfiddle  sqlite  sqlite3  sqlserver  stackexchange  stackoverflow  statement  Store  string  SUBSTRINg  sum  syntax  table  tables  templates  than  theme  time  times  timestamp  tips  tolearn  tool  tools  toread  totry  tounderstand  tricks  trigger  troubleshoot  tutorial  tutorials  type  types  under  unicode  unique  unit  unix  update  user  value  values  varchar  versioning  views  w3c  w3chools  w3schools  web  webdesign  webdev  where  whEREin  wordpress  work  workbench  wpdb  wptuts 

Copy this bookmark: