mysql

the MySQL command-line tool

copy
486
66
SHOW GRANTS FOR 'root'@'localhost';

details |

copy
186
14
GRANT SHUTDOWN ON *.* TO 'multi_admin'@'localhost' IDENTIFIED BY 'multipass';

details |

copy
270
30
select * from siteExampleCmds where parentID=1 and example like '%alter%'

details |

copy
324
57
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

details |

copy
172
14
GRANT SELECT,UPDATE,INSERT on database.* to 'user'@'localhost' IDENTIFIED BY 'password';

details |

copy
241
30
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

details |

copy
239
19
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON customer.* TO 'custom'@'server.domain' IDENTIFIED BY 'obscure';

details |

copy
226
50
ALTER TABLE tt MODIFY ActualPC VARCHAR(15);

details |

copy
209
18
ALTER TABLE orig_name RENAME new_name;

details |

copy
197
21
ALTER TABLE City ENGINE=NDBCLUSTER;

details |

copy
197
21
ALTER TABLE Country ENGINE=NDBCLUSTER;

details |

copy
194
11
GRANT USAGE ON *.* TO 'francis'@'localhost' WITH MAX_CONNECTIONS_PER_HOUR 0;

details |

copy
428
86
ALTER TABLE tbl AUTO_INCREMENT = 100;

details |

copy
185
17
ALTER TABLE t1 MODIFY b CHAR;Modify the table t1 set the column b to type CHAR

details |

copy
183
14
SELECT * FROM TBL_NAME WHERE KEY_COL LIKE 'Pat%_ck%';

details |

copy
172
18
ALTER VIEW v AS SELECT * FROM t;

details |

copy
250
21
ALTER TABLE CountryLanguage ENGINE=NDBCLUSTER;Set the Engine type to NDBCLUSTER on table CountryLanguage

details |

copy
171
12
GRANT USAGE ON *.* TO 'francis'@'localhost' WITH MAX_QUERIES_PER_HOUR 100;

details |