MySQL

Preface: the so-called phpmyadmin is simply a MySQL management tool. through this program, you can directly from the web to manage MySQL, do not need to go to the system to perform. Installation steps: 1. Obtain Archives ftp://ohaha.ks.edu.

Js|mysql System configuration: Win2000 English version +jdk1.4.1+tomcat4.0.5+apache2.043Development cycle: Make every effort, and lasted nearly 15 days.Implementation features:1. Gallery:Pictures and related text submission, pagination display,

MySQL 5.1 's Chinese support for an improvement, starting from MySQL 4.1 does not support Chinese path, file name problem solved. See the following example Microsoft Windows XP [version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents

mysql| Counter | graphic /*** Hit_count table only one field Hit_count Page_visit_record table is used to control an IP one day and only produce a counter beat CREATE TABLE Page_visit_record ( Visit_time datetime DEFAULT ' 0000-00-00 00:00:00 ' not

Mysql|session session is usually placed in the/tmp directory, and the folder's permissions are everbody readable, this is very scary! School Forum once someone through the session to steal account! So then try to put the session into the database,

Let's Create a table first. CREATE TABLE EMP ( ID int NOT NULL PRIMARY key, Name varchar (10) ); CREATE TABLE Emp_dept ( dept_id varchar (4) NOT NULL, emp_id int NOT NULL, Emp_name varchar (10), Primary KEY (dept_id,emp_id)); INSERT into EMP ()

But if the Utf-8 code, a Chinese character is 3 characters long, such as String $str= "Hello!!"; If you use the Strlen function to determine that the length is 11, just over the length of the varchar, but actually it is not so, if you directly to

By default, MySQL processes "data out of bounds" and other unhealthy data according to the following rules 1. For numeric data or time data columns, values exceeding the legal range will be phased to the nearest value range boundary; 2. Strings

Recent database migration, research and development of Tomcat to other users to access the database, need to open remote access rights; And we know that there are two ways to remotely access MySQL, Authorization and change table method; Hehe,

MySQL database under Linux By default is case-sensitive table name, to ignore table name case, add a configuration can: Vi/etc/my.cnf Add under [mysqld] column: Lower_case_table_names = 0 You can ignore case, if you set the

MySQL Root forgot, now unable to manipulate the database Stop MySQL Services service MySQL stop Or the Ps-ef |grep Mysql|xargs kill-9 Then use the following parameters to start MySQL,--skip-grant-tables will skip the MySQL authorization

Environment MySQL 5.1 + command line tools Problem MySQL User creation and authorization Solve 1. Log in as root to create a new user C:\users\wentasy>mysql-uroot-p mysql> CREATE USER Music identified by ' music '; 2. Create

Environment: MySQL Server 5.1 Problem: MySQL gets the system's current time function Solve: The now () function returns the current date time with ' Yyyy-mm-dd HH:MM:SS ', and can be saved directly to the DateTime field. Curdate () returns today'

Environment: MySQL Sever 5.1 + MySQL command line tool First look at an example (the primary key is self-growing): mysql> INSERT INTO BankAccount (name,balance) VALUES (' 123 ', 1000); Query OK, 1 row affected (0.06 sec) mysql> INSERT into

We know that MySQL is the biggest feature of its pluggable plug-in storage engine, this article will introduce the current market mainstream storage engine. Here is a special point to mention: since MySQL is open source, if you are not satisfied

In the final analysis, MySQL is running on the operating system of a software, it needs to use the file system to store data, this article mainly introduces the MySQL data directory organization structure. Location of the Data directory You can

Test how to store the video file in MySQL data, of course, do not recommend direct storage, because the migration will be cumbersome and prone to problems, the following is just a test function, import jpg, PNG and other pictures similar. Create a

The following statement has the same permissions as the root user. We should have met when we were taking the station. Root user MySQL, can only be local to connect, external deny connection. The following methods can help you solve this problem,

said the management system, the scope is somewhat big, the individual in the spare time in the open Source Software Foundation has done a MySQL management system; For the game industry, uniform, open a new suit, bulk query, batch modification

In the game industry, often encounter the need to delete the "dead number", our user ID is generated, in the deletion program, you will encounter with the database disconnected, but still running SQL statements; For the increment of the field to