OpenForum RSS: MySQL:��

MySQL:�� (angra)

Wed, 16 Jul 2008 18:16:47 GMT

� �� . �� , � �� . �� , �� , � �� :)

MySQL:�� (andrystepa)

Wed, 16 Jul 2008 08:26:51 GMT

��! ��-�� ! �� , � ��
(field list). � �� , � ��
�� . � �� , ��-��, ��
�� .

MySQL:�� (andrystepa)

Wed, 16 Jul 2008 07:30:34 GMT

>�� LOAD DATA? ��
>�� ? ��
>��, ��, �� . �� .

��:
[code]LOAD DATA INFILE

��:

LOAD DATA INFILE syntax

��:

��, �� .

��:

LOAD DATA INFILE 'customer.tab' [REPLACE | IGNORE] INTO TABLE Customer [fields [terminated by ',' [optionally] enclosed by '"' escaped by '\\' ]] [lines terminated by '\n'] [(field list)]

�� :
SELECT ... INTO OUTFILE 'customer.tab' fields terminated by ',' enclosed by '"' escaped by '\\' lines terminated by '\n' .

"fields terminated by" �� \t.
"fields [optionally] enclosed by" �� ".
"fields escaped by" �� '\\'.
"lines terminated by" �� '\n'.

"fields terminated by" � "lines terminated b

MySQL:�� (angra)

Tue, 15 Jul 2008 19:34:35 GMT

�� LOAD DATA? �� ? �� , ��, �� . �� .

MySQL:�� (alex_hunt)

Tue, 15 Jul 2008 17:02:59 GMT

>[�� ]
>id INT(11) NOT NULL auto_increment PRIMARY KEY,
>firstname VARCHAR(15),
>lastname VARCHAR(15),
>email VARCHAR(25),
>phone VARCHAR(15)
>);
>[/code]
>�� , � ��
>��, �� MySQL �� . ��
>��.

�� id.
�� , �� . �� :

[code]
-- ��
DROP TABLE IF EXISTS `phonelist`;
CREATE TABLE `phonelist` (
`id` int(11) NOT NULL auto_increment,
`firstname` VARCHAR(15),
`lastname` VARCHAR(15),
`email` VARCHAR(20),
`phone` VARCHAR(15),
PRIMARY KEY (`id`)
);
-- �� ţ:
INSERT INTO `phonelist` (firstname,lastname,email,phone) VALUES('Petrov','Sergey','netuti@rambler.ru','84996969936');
INSERT INTO `phonelist` (firstname,lastname,email,phone) VALUES('Sidorov','Nikolay','nic@hotmail.ru',

MySQL:�� (andrystepa)

Tue, 15 Jul 2008 12:17:44 GMT

>[�� ]
> PRIMARY KEY (`id`)
>);
>-- �� ţ:
>INSERT INTO `phonelist` (id,firstname,lastname,email,phone) VALUES('1','Petrov','Sergey','netuti@rambler.ru','84996969936');
>INSERT INTO `phonelist` (id,firstname,lastname,email,phone) VALUES('2','Sidorov','Nikolay','nic@hotmail.ru','4824870');
>INSERT INTO `phonelist` (id,firstname,lastname,email,phone) VALUES('3','Rjevsky','Victor','poruchik@rambler.ru','6240432');
>[/code]
>�� id � �� auto_increment (� ��
>�� id (�� ))
>�� /�� id (mysql �� )

�� :
[code]
RROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('id')
)' at line 7
[/code]
�� :
[code]
DROP TABLE IF EXISTS phonelist;
CREATE TABLE phonelist (
id INT(11) NOT NULL auto_increment PR

MySQL:�� (��)

Mon, 14 Jul 2008 17:27:25 GMT

� �� , �� phonelis.sql:
[code]-- ��
DROP TABLE IF EXISTS `phonelist`;
CREATE TABLE `phonelist` (
`id` int(11) NOT NULL auto_increment,
`firstname` VARCHAR(15),
`lastname` VARCHAR(15),
`email` VARCHAR(20),
`phone` VARCHAR(15)
PRIMARY KEY (`id`)
);
-- �� ţ:
INSERT INTO `phonelist` (id,firstname,lastname,email,phone) VALUES('1','Petrov','Sergey','netuti@rambler.ru','84996969936');
INSERT INTO `phonelist` (id,firstname,lastname,email,phone) VALUES('2','Sidorov','Nikolay','nic@hotmail.ru','4824870');
INSERT INTO `phonelist` (id,firstname,lastname,email,phone) VALUES('3','Rjevsky','Victor','poruchik@rambler.ru','6240432');
[/code]
�� id � �� auto_increment (� �� id (�� ))
�� /�� id (mysql �� )

MySQL:�� (andrystepa)

Mon, 14 Jul 2008 16:23:13 GMT

>�� , �� . ��
>�� .
>�� :
>1. � �� 4 ��, � � �� , �� ,
>� �� .
>2. �� , ��
>�� , � �� .
>

� �� , �� ? � Access �� : ��. � �� MySQL, �� .

MySQL:�� (angra)

Mon, 14 Jul 2008 10:20:38 GMT

�� , �� . �� .
�� :
1. � �� 4 ��, � � �� , �� , � �� .
2. �� , �� , � �� .

OpenForum RSS: MySQL:�� ����������� ������ � ���� �� �����

MySQL:�� ����������� ������ � ���� �� ����� (angra)

MySQL:�� ����������� ������ � ���� �� ����� (andrystepa)

MySQL:�� ����������� ������ � ���� �� ����� (andrystepa)

MySQL:�� ����������� ������ � ���� �� ����� (angra)

MySQL:�� ����������� ������ � ���� �� ����� (alex_hunt)

MySQL:�� ����������� ������ � ���� �� ����� (andrystepa)

MySQL:�� ����������� ������ � ���� �� ����� (��������)

MySQL:�� ����������� ������ � ���� �� ����� (andrystepa)

MySQL:�� ����������� ������ � ���� �� ����� (angra)

OpenForum RSS: MySQL:��

MySQL:�� (angra)

MySQL:�� (andrystepa)

MySQL:�� (andrystepa)

MySQL:�� (angra)

MySQL:�� (alex_hunt)

MySQL:�� (andrystepa)

MySQL:�� (��)

MySQL:�� (andrystepa)

MySQL:�� (angra)