Re: Table and indexes

A PRIMARY KEY is a unique KEY where all key columns must be defined as NOT NULL. If they are not explicitly declared as NOT NULL, MySQL will declare them so implicitly (and silently). A table can have only one PRIMARY KEY. If you don't have a PRIMARY KEY and an application asks for the PRIMARY KEY

confused about character sets in mysql 4.1.3b

Hello list, I have already installed mysql 4.1.3 beta to my windows xp. I set default-caharacter-set to latin5 and default-collation to latin5_turkish_ci in my.ini configuration file. Because I want latin5 my default character set. Then I restarted mysql service and looked up character set and

formatted text

Hello list, What is the best way to store and search formatted text? Thanks in advance. __ New! Unlimited Netscape Internet Service. Only $9.95 a month -- Sign up today at http://isp.netscape.com/register Act now to get a

off-topic but need help : [FWD: ezmlm warning]

Hello, Today i have received the attached message from mysql-ezmlm. But I could not understand what is going on. Is there anyone who will be able to explain what the ezmlm tries to tell me and what I have to do? Thanks in advance.

select distinct from two columns

Hello, The two columns of my table are name and city. I am trying to do a list which contains only the different names. This can be done this by distinct keyword. But all the same names which have different cities also have to be included in my list. So I can not do this with a distinct

RE: select distinct from two columns - solved

:) I have solved the problem. Thanks. [EMAIL PROTECTED] (Veysel Harun Sahin) wrote: Hello, The two columns of my table are name and city. I am trying to do a list which contains only the different names. This can be done this by distinct keyword. But all the same names which have different

Re: Fw: Server-Client

by using VB 6.0 I will use this program on network(nearly 12 user). is it necessary to code two different program for both of server and client. Or, Can I solve this problem by MYSQL Control Center. Hseyin DEMRA stikbal Furniture nt. -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL

Re: joining two columns from two different tables in a query - solved

Thanks Michale. The problem is solved.:) Michael Satterwhite [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sunday 20 July 2003 14:18, Veysel Harun Sahin wrote: Hello, I have to join two columns from different tables in a query. Assume that I have two tables

joining two columns from two different tables in a query

like this: joined_column FirstName MyOwnerName SecondName Any comments? Thanks in advance. [sql, query, mysql] -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Newbie question -- user accounts

Protection This Email Was Scanned by Apollo Systems MailServer. For More Services Please Visit http://www.apollosystems.net -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

Re: Question: using Visual Studio.NET

Messenger to chat with friends and family. http://go.msnserver.com/HK/25382.asp -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Managing big tables

productive server (MySQL 3.23) and with a test server (MySQL 4.0.12). thanks in advance, alex -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Managing big tables

- From: Veysel Harun Sahin [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 15:22 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Managing big tables http://www.mysql.com/doc/en/Data_size.html [EMAIL PROTECTED] wrote: Hello, i've got a little problem, we're

Re: Access denied, simple task

I have tried variations of the upper grant command with no succes either: ...to 'abc'@'localhost' ... Any help is appreciated. Andreas -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: the number of Rows (records)

information? Thanks -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select by weekly SUM

for that week week 3: sum of tips for that week week 4: sum of tips for that week week 5: sum of tips for that week I can do them one week per query (obviously) but would like one query that will spit them all out, one after the other. -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing

Re: query: if exists UPDATE else INSERT?

think it will be a performace problem if I have thousends of datasets a day - If I'm wrong let me know. Any hints how to manage this?? Alexander Newald -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: select by weekly SUM

and time functions in mysql. [EMAIL PROTECTED] wrote: On Sun, 13 Jul 2003 11:03:21 +0300, Veysel Harun Sahin wrote: SELECT week, sum(tips) FROM mytable GROUP BY week; Sorry, I wasn't clear. I have ONLY daily data, not weekly, but I want to output weekly data. These are the fields I have

Re: problems with farsi sorting!!

) with this new charset. 3---) please help me if there is any other solution like writing a functioin (how should I write a functioin). thanx for your helps... - Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! -- Veysel Harun Sahin [EMAIL PROTECTED

Re: HAI SIR

problem , my problem is , while loding large amount oF data FILE ( more then 16MB ) to LONGBLOB i am getting exception , i am using Mysql with INNODB , please can you provide solution bhanuprakash www.smartifacts.com -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list

Re: mysql.sock problem - solved

Problem solved. Thanks victoria.:) [EMAIL PROTECTED] wrote: Veysel Harun Sahin [EMAIL PROTECTED] wrote: I am using mysql 3.23.49 on openbsd3.2 with php4.2.3. Formerly I was connecting to mysql with php without any problem but now (I don't know what I have changed) when I try to connect

mysql.sock problem

comments? Thanks in advance. [sql, query] -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Delphi 7 and MySQL 4.1.0 alpha

Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Maximum table size

Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: OpenBSD

/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Veysel Harun Sahin [EMAIL PROTECTED

Re: [help] with browsing table?

://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Veysel Harun Sahin [EMAIL PROTECTED

Re: Using 3.23 and Delphi 6

] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Veysel Harun Sahin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

sql select from question

to select all the columns except col35 I have to write a query like SELECT col1, col2, , col34, col36, col50 FROM table1. Is there a simpler way to do this for example using not operator with the column name col35? Thanks. sql, query, select vb. -- Veysel Harun Sahin [EMAIL PROTECTED

Re: sql select from question

Thanks dread. Yes it can be done programmatically. But i try to do only with sql. I don't want to hardcode it. [EMAIL PROTECTED] wrote: On 24-Feb-2003 Veysel Harun Sahin wrote: Hello list, I want to select all the columns in a table except one column. Can I do this without writing all

Re: MySQL on Mandrake 9 with EXT3 File system... Max Size?

, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Veysel Harun

Re: Need Help With MySQL Query

-- Veysel Harun Sahin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Re: NEWBIE to mysql

mysql CREATE TABLE info - ( - name varchar(50), - message varchar(255) - ) - ; [EMAIL PROTECTED] wrote: Can anyone tell me why I keep getting an ERROR 1064 with this command ? I just would like to create a table with two fields, name and messages for a Simple guestbook but I

Re: sort problem

Store town numbers in another column. [EMAIL PROTECTED] wrote: Hi, How can I fix an order by using numbers and letters ? Id Town 56 Paris 1 60 Paris 10 7 Paris 11 262 Paris 12 8 Paris 13 16 Paris 14 22 Paris 15 6 Paris 3 57 Paris 4 51 Paris 6 5 Paris 7 61 Paris 8 59 Paris 9 I'd like to get :

Re: Not sure my other email got through!

select table1.name, table2.id2+table2.col1+table2.col2+table2.col3 as mysumresult from table1 left join reference using (id1) left join table2 using (id2); [EMAIL PROTECTED] wrote: Not sure my other email got through, so here it is again, with an updated description of the problem. Hi, I

Re: converting MS SQL to MySQL

Take look at http://www.mysql.com/doc/en/CREATE_TABLE.html [EMAIL PROTECTED] wrote: Hi, I am new to SQL. I am attempting to create a database that was created in MS SQL to MySQL. The below SQL statements works with MS SQL. I am executing the following: CREATE TABLE 'Accounting'(

Re: encrypted password

Try this: insert into tablename values ('myusername', password('mypassword')); [EMAIL PROTECTED] wrote: On Tue, Feb 04, 2003 at 02:58:28PM -0500, Jianping Zhu wrote: I have mysql in a redhat machine. I need to use mysql do user authentication to a website. I have a table like following.

Re: MySQL 3.23.55-nt on Windows 2000: Trying to Create InnoDB Tables

Take a look at http://www.mysql.com/doc/en/NT_start.html. And about innodb tables you can read http://www.innodb.com/ibman.html. [EMAIL PROTECTED] wrote: I've got a beginner's question: I've installed SQL Server, and begun building tables; when I create a new table, the table type is defaulting

4G file limit

Hello, I am using mysql3.23.49 on openbsd3.2. I have a myisam table with 4G file size and now I can no longer insert records into table. My mysql data partition is not full (%24 used). I have read that mysql 3.23 supports up to 2 terabytes table size. Not so sure but I know openbsd's file

Re: 4G file limit - solved

/CREATE_TABLE.html You can just alter the table with this option. Hope this helps, - Original Message - From: Veysel Harun Sahin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 03, 2003 4:49 AM Subject: 4G file limit Hello, I am using mysql3.23.49 on openbsd3.2. I have

Re: mysql_install_db doesn't install grant tables

have look at http://www.mysql.com/doc/en/mysql_install_db.html [EMAIL PROTECTED] wrote: Description: When I tried to start MySQL server with shell/usr/bin/safe_mysqld it gave me the error: - Starting

RE: Mysql and Openbsd 3.2

I have never tried to compile sources on openbsd. So I don't know if it is possible or not. Generally I prefer the standart openbsd packages. You can download and use mysql-server3.23.49 package from openbsd: http://www.openbsd.org/3.2_packages/ Also if you have problems installing openbsd

RE: sql delete question

Hello Adolfo, Yes I have tried it too but it did not work. Anyway i have done it programatically in my app. Thanks. Adolfo Bello [EMAIL PROTECTED] wrote: I have two tables whose structures are below. - Table1 - table1id int not null auto_increment data varchar(30) - Table2 - table2id

sql delete question

Hello, I have two tables whose structures are below. - Table1 - table1id int not null auto_increment data varchar(30) - Table2 - table2id int not null auto_increment table1id int not null data varchar(30) These two tables are connected to each other with the table1id column. I need to

Re: sql delete question - solved

: At 7:27 -0500 1/8/03, Veysel Harun Sahin wrote: Hello, I have two tables whose structures are below. - Table1 - table1id int not null auto_increment data varchar(30) - Table2 - table2id int not null auto_increment table1id int not null data varchar(30) These two tables are connected to each other

RE: Using files stored as blob

If you can give more info about your development environment and explain a little what you want to do, some of us may help. Tim Best [EMAIL PROTECTED] wrote: OK I got files to upload to my MySQL server but now how do I retreive them for distribution by email for instance. When I do a query

Re: No my.cnf - why?

http://www.mysql.com/doc/en/Option_files.html http://www.mysql.com/doc/en/Automatic_start.html If you have not my.cnf file you can create a new one with a text editor. Just write your options and then save it to the required place with the name my.cnf. If you enter a password for user root try

order by clause with latin5 character set on binary fields

Hello, I use mySQL 3.23.49 with latin5 character set. At some of my tables I use binary fields. At normal fields order by clause returns true sorting but at binary fields I get wrong results. Is there any way to correct this problem or have to I use normal fields instead of binary and use

Re: MySQL Delphi 6

I think the standart tsqlconnection in delphi6 have some problems. Instead you can use ado or tmysqlconnection from http://www.productivity.org/projects/mysql/;. Hope it helps. Patricio Díaz G. wrote: Can somebody help me with Delphi 6 and MySQL? I'm using Delphi en a WinXP box and the MySQL

Re: select from multiple tables - solved

Thanks Joseph and Kelly. I think merge tables will be a good solution for me. Veysel Harun Sahin wrote: Hello, I have a problem with select statetement. I need to query and select records from multiple tables which have the same column types. I have done this with left join but my query

select from multiple tables

Hello, I have a problem with select statetement. I need to query and select records from multiple tables which have the same column types. I have done this with left join but my query became so complex. Because i have written left join between all of my tables and also if i need to query

query question

Hello list, I am using mysql 3.23.52. I have to query one of my tables which has two columns with the type of date and time. For example i have to get the records whose date are 2002-10-12 and time is bigger than 11:30:00 and also the records whose date are 2002-10-13 and time is smaller

Re: query question - solved

Thank you Egor. These queries meet my needs. Egor Egorov wrote: Veysel, Monday, October 14, 2002, 12:48:58 PM, you wrote: VHS I am using mysql 3.23.52. I have to query one of my tables which has two VHS columns with the type of date and time. For example i have to get VHS the records whose

Re: Network access?

look at the grant syntax in the manual. Steve Dickey wrote: I am a MySQL newbie and can not seem to find the documentation that explains how to allow network or remote access to a running MySQL server. It does not seem to be in the my.cnf file or in the manual??? I am sure this is a

Re: CREATE FUNCTION

http://www.mysql.com/doc/P/r/Privileges.html Sameh Attia wrote: Hi, Can anybody help me figuring how to control granting users permissions to created functions in MySQL like we do for SELECT, INSERT, ...etc or it is not possible and every one logged in to MySQL could simply use them

Re: CREATE FUNCTION

ahh sorry for misunderstand. the truth is that i have no idea about the solution of your problem but i would like to hear from you if you find a solution. Sameh Attia wrote: Veysel Harun Sahin wrote: http://www.mysql.com/doc/P/r/Privileges.html Sameh Attia wrote: Hi, Can anybody

Re: Unions

Take a look at http://www.mysql.com/doc/;. If you search the keyword union you can get an answer. Arul wrote: Hi Can i use Unions in MySQL. If not could anyone comeout with some alternates.. Regards, -Arul sql, -

Re: ERROR 1030: Got error 127 from table handler

It seems that your table has been crashed. Try to check and repair your table. tl wrote: Hello MySQL, I do select: select SUM(IF((@a:=(( ( ((@data:= DATE_FORMAT(data,'%Y-%m-%d')) IN ('2001-11-10','2001-12-22','2001-12-29')) OR (WEEKDAY(data) IN ('0','1','2','3','4')) ) AND

database modelling tool

Hello, Is there any database modelling tool for mysql? -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ -