🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: cn.comp.database.mysql
4 messages
4 total messages Started by xiaotiger666 Mon, 27 Nov 2006 07:19
���һ��Mysql�����⡣
#17
Author: xiaotiger666
Date: Mon, 27 Nov 2006 07:19
56 lines
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�����⡣
#18
Author: ��
Date: Sat, 23 Dec 2006 12:56
2 lines
1078 bytes
�ȼ���һ�䣺
mysql_query("SET NAMES 'GBK'"); 
Re: 请教一个Mysql的问题。
#19
Author: yong
Date: Mon, 15 Jan 2007 09:49
66 lines
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�����⡣
#20
Author: paladinxu
Date: Wed, 07 Feb 2007 08:59
68 lines
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