mysql

MySQL amri ya mstari wa chombo

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

maelezo |

nakala
428
86
ALTER TABLE tbl AUTO_INCREMENT = 100;

maelezo |

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

maelezo |

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

maelezo |

nakala
250
21
ALTER TABLE CountryLanguage ENGINE=NDBCLUSTER;

maelezo |

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

maelezo |

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

maelezo |

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

maelezo |

nakala
209
18
ALTER TABLE orig_name RENAME new_name;

maelezo |

nakala
197
21
ALTER TABLE City ENGINE=NDBCLUSTER;

maelezo |

nakala
197
21
ALTER TABLE Country ENGINE=NDBCLUSTER;

maelezo |

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

maelezo |

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

maelezo |

nakala
185
17
ALTER TABLE t1 MODIFY b CHAR;

maelezo |

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

maelezo |

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

maelezo |

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

maelezo |

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

maelezo |