by kirk , 3 pages, modified on

Frequently used commands of the open source database.

1. Find out warnings and errors

   show errors
   
   show warnings
   

   1
2. Transaction

   set autocommit = 0;
   
   begin;
   
   -- do stuff
   
   commit;
   
   -- or
   
   rollback;

   2
3. Find out internally generated fk_symbol

   
   show create table <table name>;

   3

Most Viewed Notebooks
  (last 7 days)

Latest Notebooks

More notebooks...