摘要(Abstract)
MySQL是一个关系型数据库管理系统,由瑞典MySQL AB 公司开发,目前属于 Oracle 旗下产品。MySQL 是最流行的关系型数据库管理系统之一,在 WEB 应用方面,MySQL是最好的 RDBMS (Relational Database Management System,关系数据库管理系统) 应用软件。
1. [2] 使用 C和 C++编写,并使用了多种编译器进行测试,保证了源代码的可移植性。
2.支持 AIX、FreeBSD、HP-UX、Linux、Mac OS、NovellNetware、OpenBSD、OS/2 Wrap、Solaris、Windows等多种操作系统。
3.为多种编程语言提供了 API。这些编程语言包括 C、C++、Python、Java、Perl、PHP、Eiffel、Ruby,.NET和 Tcl 等。
4.支持多线程,充分利用 CPU 资源。
5.优化的 SQL查询算法,有效地提高查询速度。
6.既能够作为一个单独的应用程序应用在客户端服务器网络环境中,也能够作为一个库而嵌入到其他的软件中。
7.提供多语言支持,常见的编码如中文的 GB 2312、BIG5,日文的 Shift_JIS等都可以用作数据表名和数据列名。
8.提供 TCP/IP、ODBC 和 JDBC等多种数据库连接途径。
9.提供用于管理、检查、优化数据库操作的管理工具。
主题(Topic)
项目(Project)
dengliangshi/MySQLdb-Wrapper
MiniORM-MySQL
dayan2222/Flask-MySQL-Connectivity
xinyiZzz/MiniORM-MySQL
shawon922/flask-blog-api
alexferl/flask-mysqldb
tanersekmen/flask_mysqldb
liqq1228/163spider
BADRKAC/storePIC-mysqlDB-JS
zhiephie/mysqldb-python-class
ojasiiitd/Databasing-Flask-MySQLDB
MySQLdb_into_Chinese
lincanbin/PHP-PDO-MySQL-Class
zyq001/pycrawler
itexia/ansible.role.create-mysqldb-and-user-using-plesk-api
TrustMe5/The-operation-of-MySQLdb-under-ubuntu-system
Apache/2.2.22 (Ubuntu) Server at chiport.mysqool.com Port 80\n' REQUEST_METHOD 'POST' PATH_INFO u'/classes/169/' HTTP_ORIGIN 'http://chiport.mysqool.com' SERVER_PROTOCOL 'HTTP/1.1' QUERY_STRING '' CONTENT_LENGTH '86' HTTP_USER_AGENT 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_5) AppleWebKit/536.25 (KHTML, like Gecko) Version/6.0 Safari/536.25' HTTP_CONNECTION 'keep-alive' HTTP_COOKIE 'csrftoken=EY4XM6MqG0yE6afiqZtGwFh2v511Y4TT; sessionid=ddb59a24417d9786170978a5346e3c9b' SERVER_NAME 'chiport.mysqool.com' REMOTE_ADDR '71.201.52.157' mod_wsgi.request_handler 'wsgi-script' wsgi.url_scheme 'http' PATH_TRANSLATED '/home/ubuntu/sites/mysqool/mysqool.wsgi/classes/169/' SERVER_PORT '80' wsgi.multiprocess True mod_wsgi.input_chunked '0' SERVER_ADDR '10.39.97.132' DOCUMENT_ROOT '/etc/apache2/htdocs' mod_wsgi.process_group '' SCRIPT_FILENAME '/home/ubuntu/sites/mysqool/mysqool.wsgi' SERVER_ADMIN 'info@mysqool.com' wsgi.input HTTP_HOST 'chiport.mysqool.com' wsgi.multithread True mod_wsgi.callable_object 'application' REQUEST_URI '/classes/169/' HTTP_ACCEPT 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' wsgi.version (1, 1) GATEWAY_INTERFACE 'CGI/1.1' wsgi.run_once False wsgi.errors REMOTE_PORT '57290' HTTP_ACCEPT_LANGUAGE 'en-us' mod_wsgi.version (3, 3) CONTENT_TYPE 'application/x-www-form-urlencoded' mod_wsgi.application_group 'staging.mysqool.com|' mod_wsgi.script_reloading '1' wsgi.file_wrapper '' CSRF_COOKIE 'EY4XM6MqG0yE6afiqZtGwFh2v511Y4TT' HTTP_ACCEPT_ENCODING 'gzip, deflate' Settings Using settings module mysqool.settings Setting Value USE_L10N False USE_THOUSAND_SEPARATOR False CSRF_COOKIE_SECURE False LANGUAGE_CODE 'en-us' ROOT_URLCONF 'mysqool.urls' MANAGERS (('', ''),) DEFAULT_CHARSET 'utf-8' STATIC_ROOT '/home/ubuntu/sites/mysqool/mysqool/static/' MESSAGE_STORAGE 'django.contrib.messages.storage.fallback.FallbackStorage' EMAIL_SUBJECT_PREFIX '[Django] ' SEND_BROKEN_LINK_EMAILS False URL_VALIDATOR_USER_AGENT 'Django/1.4 (https://www.djangoproject.com)' STATICFILES_FINDERS ('django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder') SESSION_COOKIE_DOMAIN None SESSION_COOKIE_NAME 'sessionid' ADMIN_FOR () TIME_INPUT_FORMATS ('%H:%M %p', '%P', '%H:%M%A', '%H:%M %A', '%H:%M%a', '%H:%M %a') DATABASES {'default': {'ENGINE': 'django.db.backends.mysql', 'HOST': '', 'NAME': 'mysqool', 'OPTIONS': {}, 'PASSWORD': u'********************', 'PORT': '', 'TEST_CHARSET': None, 'TEST_COLLATION': None, 'TEST_MIRROR': None, 'TEST_NAME': None, 'TIME_ZONE': 'America/Chicago', 'USER': 'mysqool'}} FILE_UPLOAD_PERMISSIONS None FILE_UPLOAD_HANDLERS ('django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler') DEFAULT_CONTENT_TYPE 'text/html' TEST_RUNNER 'django.test.simple.DjangoTestSuiteRunner' AJAX_SELECT_BOOTSTRAP True APPEND_SLASH True FIRST_DAY_OF_WEEK 0 DATABASE_ROUTERS [] YEAR_MONTH_FORMAT 'F Y' STATICFILES_STORAGE 'django.contrib.staticfiles.storage.StaticFilesStorage' CACHES {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache', 'LOCATION': ''}} SERVER_EMAIL 'noreply@mysqool.com' SESSION_COOKIE_PATH '/' USE_X_FORWARDED_HOST False MIDDLEWARE_CLASSES ('mediagenerator.middleware.MediaMiddleware', 'django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.contrib.flatpages.middleware.FlatpageFallbackMiddleware', 'debug_toolbar.middleware.DebugToolbarMiddleware', 'mysqool.middleware.authentication.EnforceLoginMiddleware') USE_I18N False THOUSAND_SEPARATOR ',' SECRET_KEY u'********************' LANGUAGE_COOKIE_NAME 'django_language' DEFAULT_INDEX_TABLESPACE '' TRANSACTIONS_MANAGED False LOGGING_CONFIG 'django.utils.log.dictConfig' TEMPLATE_LOADERS ('django.template.loaders.filesystem.Loader', 'django.template.loaders.app_directories.Loader') WSGI_APPLICATION 'mysqool.wsgi.application' TEMPLATE_DEBUG True X_FRAME_OPTIONS 'SAMEORIGIN' AUTHENTICATION_BACKENDS ('mysqool.backends.authentication.EmailOrUsernameModelBackend', 'django.contrib.auth.backends.ModelBackend') FORCE_SCRIPT_NAME None CACHE_BACKEND 'locmem://' SIGNING_BACKEND 'django.core.signing.TimestampSigner' SESSION_COOKIE_SECURE False CSRF_COOKIE_DOMAIN None FILE_CHARSET 'utf-8' DEBUG True SESSION_FILE_PATH None DEFAULT_FILE_STORAGE 'django.core.files.storage.FileSystemStorage' INSTALLED_APPS ('django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.humanize', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.flatpages', 'django.contrib.admin', 'django.contrib.webdesign', 'administration', 'attendance', 'calendars', 'classes', 'dashboard', 'enrollment', 'helper', 'people', 'schools', 'transactions', 'mediagenerator', 'widget_tweaks', 'crispy_forms', 'ajax_select', 'debug_toolbar', 'registration', 'profiles', 'oembed', 'south', 'tagging') LANGUAGES (('ar', 'Arabic'), ('az', 'Azerbaijani'), ('bg', 'Bulgarian'), ('bn', 'Bengali'), ('bs', 'Bosnian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('el', 'Greek'), ('en', 'English'), ('en-gb', 'British English'), ('eo', 'Esperanto'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-mx', 'Mexican Spanish'), ('es-ni', 'Nicaraguan Spanish'), ('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('fy-nl', 'Frisian'), ('ga', 'Irish'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hu', 'Hungarian'), ('id', 'Indonesian'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('ml', 'Malayalam'), ('mn', 'Mongolian'), ('nb', 'Norwegian Bokmal'), ('ne', 'Nepali'), ('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'), ('pa', 'Punjabi'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'), ('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'), ('tt', 'Tatar'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('vi', 'Vietnamese'), ('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional Chinese')) COMMENTS_ALLOW_PROFANITIES False STATICFILES_DIRS ('/home/ubuntu/sites/mysqool/mysqool/static-files/',) PREPEND_WWW False SECURE_PROXY_SSL_HEADER None AUTH_PROFILE_MODULE 'people.Profile' SESSION_COOKIE_HTTPONLY True DEBUG_PROPAGATE_EXCEPTIONS False CACHE_MIDDLEWARE_ALIAS 'default' MONTH_DAY_FORMAT 'F j' LOGIN_URL '/login/' SESSION_EXPIRE_AT_BROWSER_CLOSE False TIME_FORMAT ('%I:%M %p',) DATE_INPUT_FORMATS ('%Y-%m-%d', '%m/%d/%Y', '%m/%d/%y', '%b %d %Y', '%b %d, %Y', '%d %b %Y', '%d %b, %Y', '%B %d %Y', '%B %d, %Y', '%d %B %Y', '%d %B, %Y') CSRF_COOKIE_NAME 'csrftoken' EMAIL_HOST_PASSWORD u'********************' PASSWORD_RESET_TIMEOUT_DAYS u'********************' AJAX_LOOKUP_CHANNELS {'student_name': ('schools.lookups', 'UserLookup')} SESSION_SAVE_EVERY_REQUEST False ADMIN_MEDIA_PREFIX '/static//admin/' NUMBER_GROUPING 0 SESSION_ENGINE 'django.contrib.sessions.backends.db' CSRF_FAILURE_VIEW 'django.views.csrf.csrf_failure' CSRF_COOKIE_PATH '/' LOGIN_REDIRECT_URL '/' PUBLIC_URLS ('api/', 'login/', 'logout/', 'registration/password/reset/(.*)') PROJECT_ROOT '/home/ubuntu/sites/mysqool/mysqool' LOGGING {'disable_existing_loggers': False, 'filters': {'require_debug_false': {'()': 'django.utils.log.RequireDebugFalse'}}, 'handlers': {'mail_admins': {'class': 'django.utils.log.AdminEmailHandler', 'filters': ['require_debug_false'], 'level': 'ERROR'}}, 'loggers': {'django.request': {'handlers': ['mail_admins'], 'level': 'ERROR', 'propagate': True}}, 'version': 1} IGNORABLE_404_URLS () LOCALE_PATHS () TEMPLATE_STRING_IF_INVALID '' LOGOUT_URL '/accounts/logout/' EMAIL_USE_TLS True FIXTURE_DIRS () EMAIL_HOST 'smtp.sendgrid.net' DATE_FORMAT 'N j, Y' MEDIA_ROOT '/home/ubuntu/sites/mysqool/mysqool/media/' DEFAULT_EXCEPTION_REPORTER_FILTER 'django.views.debug.SafeExceptionReporterFilter' ADMINS (('', ''),) FORMAT_MODULE_PATH None DEFAULT_FROM_EMAIL 'noreply@mysqool.com' MEDIA_URL '/media/' DATETIME_FORMAT 'N j, Y, P' TEMPLATE_DIRS ('/home/ubuntu/sites/mysqool/mysqool/templates',) DIF ('%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M:%S.%f', '%Y-%m-%d %H:%M', '%Y-%m-%d', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M:%S.%f', '%m/%d/%Y %H:%M', '%m/%d/%Y', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M:%S.%f', '%m/%d/%y %H:%M', '%m/%d/%y') SITE_ID 1 DISALLOWED_USER_AGENTS () ALLOWED_INCLUDE_ROOTS () DECIMAL_SEPARATOR '.' SHORT_DATE_FORMAT 'm/d/Y' AJAX_SELECT_INLINES 'inline' CACHE_MIDDLEWARE_KEY_PREFIX u'********************' TIME_ZONE 'America/Chicago' FILE_UPLOAD_MAX_MEMORY_SIZE 2621440 EMAIL_BACKEND 'django.core.mail.backends.smtp.EmailBackend' DEFAULT_TABLESPACE '' TEMPLATE_CONTEXT_PROCESSORS ('django.contrib.auth.context_processors.auth', 'django.core.context_processors.debug', 'django.core.context_processors.i18n', 'django.core.context_processors.media', 'django.core.context_processors.static', 'django.core.context_processors.request', 'django.core.context_processors.tz', 'django.contrib.messages.context_processors.messages', 'mysqool.context_processors.school_info') SESSION_COOKIE_AGE 86400 SETTINGS_MODULE 'mysqool.settings' USE_ETAGS False LANGUAGES_BIDI ('he', 'ar', 'fa') FILE_UPLOAD_TEMP_DIR None INTERNAL_IPS ('127.0.0.1',) STATIC_URL '/static/' EMAIL_PORT 587 USE_TZ False SHORT_DATETIME_FORMAT 'm/d/Y P' PASSWORD_HASHERS u'********************' ABSOLUTE_URL_OVERRIDES {} CACHE_MIDDLEWARE_SECONDS 600 DEBUG_TOOLBAR_CONFIG {'INTERCEPT_REDIRECTS': False} DATETIME_INPUT_FORMATS ('%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M:%S.%f', '%Y-%m-%d %H:%M', '%Y-%m-%d', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M:%S.%f', '%m/%d/%Y %H:%M', '%m/%d/%Y', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M:%S.%f', '%m/%d/%y %H:%M', '%m/%d/%y', '%m/%d/%Y %I:%M %p', '%m/%d/%Y %I:%M%p') EMAIL_HOST_USER 'sandersnewmedia' PROFANITIES_LIST u'********************' You're seeing this error because you have DEBUG = True in your Django settings file. Change that to False, and Django will display a standard 500 page." class="topic-tag topic-tag-link">
elapotts/Adding-Jennifer-Smith---Carolyn-Reilley-to-class