Thread View: cn.comp.database.mysql
4 messages
4 total messages
Started by xiaotiger666
Mon, 27 Nov 2006 07:19
���һ��Mysql�����⡣
Author: xiaotiger666
Date: Mon, 27 Nov 2006 07:19
Date: Mon, 27 Nov 2006 07:19
56 lines
3902 bytes
3902 bytes
��Һã�
���õ���MySql 5.1�İ汾������VCд��һ��ADO������������MySql�������ڲ������ĵ�ʱ�����DZ��?
��������ǣ�
1064 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 '' at line 1
��д�IJ��������� Insert into
T_AddressGroup(F_Owner,F_GroupName,F_Desc) values('admin','������','������');
����һ���Ӣ�ľ���ִ�гɹ���Insert into
T_AddressGroup(F_Owner,F_GroupName,F_Desc) values('admin','aaa','aaa');
���ʴ������ʲôԭ���ַ�Ҳ����İ� �Ұ�����Ϊ��
Insert into T_AddressGroup(F_Owner,F_GroupName,F_Desc)
values('admin',_gbk'������',_gbk'������');
Ҳ���С�
����һ�£������������ִ�������䶼��û������ģ������һ��ܲ�ѯ������
mysql> show variables like '%char%';
+--------------------------+--------------------------+
| Variable_name | Value |
+--------------------------+--------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | gbk |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | D:\MySql\share\charsets\ |
+--------------------------+--------------------------+
8 rows in set (0.00 sec)
mysql> Insert into T_AddressGroup(F_Owner,F_GroupName,F_Desc)
values('admin',_gb
k'������',_gbk'������');
Query OK, 1 row affected (0.05 sec)
mysql> select * from T_addressGroup;
+------+---------+-------------+--------+
| F_Id | F_Owner | F_GroupName | F_Desc |
+------+---------+-------------+--------+
| 1 | admin | ������ | ������ |
+------+---------+-------------+--------+
1 row in set (0.00 sec)
mysql> Insert into T_AddressGroup(F_Owner,F_GroupName,F_Desc)
values('admin','��
����','������');
Query OK, 1 row affected (0.05 sec)
mysql> select * from T_addressGroup;
+------+---------+-------------+--------+
| F_Id | F_Owner | F_GroupName | F_Desc |
+------+---------+-------------+--------+
| 1 | admin | ������ | ������ |
| 2 | admin | ������ | ������ |
+------+---------+-------------+--------+
2 rows in set (0.00 sec)
Re: ���һ��Mysql�����⡣
Author: ��
Date: Sat, 23 Dec 2006 12:56
Date: Sat, 23 Dec 2006 12:56
2 lines
1078 bytes
1078 bytes
�ȼ���һ�䣺
mysql_query("SET NAMES 'GBK'");
Re: 请教一个Mysql的问题。
Author: yong
Date: Mon, 15 Jan 2007 09:49
Date: Mon, 15 Jan 2007 09:49
66 lines
4427 bytes
4427 bytes
�����������
check the manual that corresponds to your MySQL server version for
the right syntax to use near '' at line 1
д����˫��ţ�"���ĵط����Ĵ��������³�������û�мӴ��˫��š�
xiaotiger666@hotmail.com wrote:
> ��Һã�
> ���õ���MySql 5.1�İ汾������VCд��һ��ADO������������MySql�������ڲ������ĵ�ʱ�����DZ��?
> ��������ǣ�
> 1064 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 '' at line 1
>
> ��д�IJ��������� Insert into
> T_AddressGroup(F_Owner,F_GroupName,F_Desc) values('admin','������','������');
> ����һ���Ӣ�ľ���ִ�гɹ���Insert into
> T_AddressGroup(F_Owner,F_GroupName,F_Desc) values('admin','aaa','aaa');
>
> ���ʴ������ʲôԭ���ַ�Ҳ����İ� �Ұ�����Ϊ��
> Insert into T_AddressGroup(F_Owner,F_GroupName,F_Desc)
> values('admin',_gbk'������',_gbk'������');
> Ҳ���С�
>
> ����һ�£������������ִ�������䶼��û������ģ������һ��ܲ�ѯ������
>
> mysql> show variables like '%char%';
> +--------------------------+--------------------------+
> | Variable_name | Value |
> +--------------------------+--------------------------+
> | character_set_client | gbk |
> | character_set_connection | gbk |
> | character_set_database | gbk |
> | character_set_filesystem | binary |
> | character_set_results | gbk |
> | character_set_server | gbk |
> | character_set_system | utf8 |
> | character_sets_dir | D:\MySql\share\charsets\ |
> +--------------------------+--------------------------+
> 8 rows in set (0.00 sec)
> mysql> Insert into T_AddressGroup(F_Owner,F_GroupName,F_Desc)
> values('admin',_gb
> k'������',_gbk'������');
> Query OK, 1 row affected (0.05 sec)
> mysql> select * from T_addressGroup;
> +------+---------+-------------+--------+
> | F_Id | F_Owner | F_GroupName | F_Desc |
> +------+---------+-------------+--------+
> | 1 | admin | ������ | ������ |
> +------+---------+-------------+--------+
> 1 row in set (0.00 sec)
> mysql> Insert into T_AddressGroup(F_Owner,F_GroupName,F_Desc)
> values('admin','��
> ����','������');
> Query OK, 1 row affected (0.05 sec)
> mysql> select * from T_addressGroup;
> +------+---------+-------------+--------+
> | F_Id | F_Owner | F_GroupName | F_Desc |
> +------+---------+-------------+--------+
> | 1 | admin | ������ | ������ |
> | 2 | admin | ������ | ������ |
> +------+---------+-------------+--------+
> 2 rows in set (0.00 sec)
>
>
Re: ���һ��Mysql�����⡣
Author: paladinxu
Date: Wed, 07 Feb 2007 08:59
Date: Wed, 07 Feb 2007 08:59
68 lines
4539 bytes
4539 bytes
ò��ÿ�����ӵ��ַ���Ҫ��������
"yong" <cyberblue.yong@gmail.com> д����Ϣ����:eofimp$pj7$1@news.yaako.com...
> �����������
>
> check the manual that corresponds to your MySQL server version for
> the right syntax to use near '' at line 1
>
> д����˫��ţ�"���ĵط����Ĵ��������³�������û�мӴ��˫��š�
>
> xiaotiger666@hotmail.com wrote:
>> ��Һã�
>> ���õ���MySql 5.1�İ汾������VCд��һ��ADO������������MySql�������ڲ������ĵ�ʱ�����DZ��?
>> ��������ǣ�
>> 1064 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 '' at line 1
>>
>> ��д�IJ��������� Insert into
>> T_AddressGroup(F_Owner,F_GroupName,F_Desc) values('admin','������','������');
>> ����һ���Ӣ�ľ���ִ�гɹ���Insert into
>> T_AddressGroup(F_Owner,F_GroupName,F_Desc) values('admin','aaa','aaa');
>>
>> ���ʴ������ʲôԭ���ַ�Ҳ����İ� �Ұ�����Ϊ��
>> Insert into T_AddressGroup(F_Owner,F_GroupName,F_Desc)
>> values('admin',_gbk'������',_gbk'������');
>> Ҳ���С�
>>
>> ����һ�£������������ִ�������䶼��û������ģ������һ��ܲ�ѯ������
>>
>> mysql> show variables like '%char%';
>> +--------------------------+--------------------------+
>> | Variable_name | Value |
>> +--------------------------+--------------------------+
>> | character_set_client | gbk |
>> | character_set_connection | gbk |
>> | character_set_database | gbk |
>> | character_set_filesystem | binary |
>> | character_set_results | gbk |
>> | character_set_server | gbk |
>> | character_set_system | utf8 |
>> | character_sets_dir | D:\MySql\share\charsets\ |
>> +--------------------------+--------------------------+
>> 8 rows in set (0.00 sec)
>> mysql> Insert into T_AddressGroup(F_Owner,F_GroupName,F_Desc)
>> values('admin',_gb
>> k'������',_gbk'������');
>> Query OK, 1 row affected (0.05 sec)
>> mysql> select * from T_addressGroup;
>> +------+---------+-------------+--------+
>> | F_Id | F_Owner | F_GroupName | F_Desc |
>> +------+---------+-------------+--------+
>> | 1 | admin | ������ | ������ |
>> +------+---------+-------------+--------+
>> 1 row in set (0.00 sec)
>> mysql> Insert into T_AddressGroup(F_Owner,F_GroupName,F_Desc)
>> values('admin','��
>> ����','������');
>> Query OK, 1 row affected (0.05 sec)
>> mysql> select * from T_addressGroup;
>> +------+---------+-------------+--------+
>> | F_Id | F_Owner | F_GroupName | F_Desc |
>> +------+---------+-------------+--------+
>> | 1 | admin | ������ | ������ |
>> | 2 | admin | ������ | ������ |
>> +------+---------+-------------+--------+
>> 2 rows in set (0.00 sec)
>>
>>
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads