Albert Lukaszewski

  • DDaudalagidцитирует2 года назад
    The point of a cursor is to mark your place and to allow you to issue commands to the computer.
  • DDaudalagidцитирует2 года назад
    A cursor in MySQL for Python serves as a Python-based proxy for the cursor in a MySQL shell session, where MySQL would create the real cursor for us if we logged into a MySQL database.
  • DDaudalagidцитирует2 года назад
    By default, MySQL has autocommit switched on. Your database administrator will be able to confirm whether auto-commit is switched on. If it is not, you will need to commit any changes you have made.
  • DDaudalagidцитирует2 года назад
    (the \G is the same command as \g, but it tells MySQL to display the results vertically):
  • DDaudalagidцитирует2 года назад
    Where the semicolon is the statement delimiter in the MySQL shell, the backslash (\) is used to delimit lines within a statement.
  • DDaudalagidцитирует2 года назад
    The HAVING clause is used for aggregate functions. It can be used to replace WHERE, but to do so is generally viewed as poor coding because it violates the SQL standard.
  • DDaudalagidцитирует2 года назад
    The LIMIT clause is used to restrict the number of rows that are returned in the result set. It takes two positive integers as arguments. The first number indicates the point at which to start counting and counts from zero for that process. The second number indicates how many times to increment the first number by one in order to determine the desired limit.
  • DDaudalagidцитирует2 года назад
    If you are programming for a web application and your database and web server are located on a single machine, you need to conserve your server resources.
  • DDaudalagidцитирует2 года назад
    Therefore, you almost certainly want to use HAVING instead of LIMIT.
  • DDaudalagidцитирует2 года назад
    The execute() method, as the name implies, expects an argument of what is to be executed by Python. In other words, it takes the MySQL sentence or statement as its argument. Its basic syntax is as follows:
    results_variable = cursor_handle.execute('MySQL statement')
fb2epub
Перетащите файлы сюда, не более 5 за один раз