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 col

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 personaliz

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. ___

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 n

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 keyword

Re: Fw: Server-Client

ql - MySql Subject: Server-Client Hello, I coded a program 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. Hüseyin DEMİRAĞ İstikbal Furniture İnt.

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 tabl

Re: Newbie question -- user accounts

* For Your 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 M

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: 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

al Message----- 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

Re: Managing big tables

viour could be reproduced with our 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: 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: Access denied, simple task

e buffer. mysql> use myFineDb; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'myfinedb' mysql> I have tried variations of the upper grant command with no succes either: ...to 'abc'@'localhost' ... Any help is appreciated. Andreas

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 fie

Re: query: if exists UPDATE else INSERT?

ne but I think that $w = part isn't working with mysql ;-) Its no solution to simply make the table accept duplicate entries for id and make a "sum(value) group by id" because I think it will be a performace problem if I have thousends of datasets a day - If I'm wrong let me know.

Re: select by weekly SUM

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: problems with farsi sorting!!

set of mysql (latin1) 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 Sa

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

mysql.sock problem

sql server is up and running. Any 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

oforakis. -- 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: Maximum table size

-- 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: OpenBSD

.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: [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

Re: Using 3.23 and Delphi 6

PROTECTED]> 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://lis

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 al

sql select from question

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

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

: 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/ (the list archiv

Re: Need Help With MySQL Query

scribing? 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/ (the list archiv

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 have

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: 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 bu

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

Re: 4G file limit - solved

ww.mysql.com/doc/C/R/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,

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 size

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 m

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 packa

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) >> >> - Ta

Re: sql delete question - solved

ECTED]> wrote: >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 n

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 dele

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 que

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 tr

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 "BIN

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: Hello all :-)

I don't know why but the message "Query OK. 0 rows affected (some time)" after grant and revoke syntax shows that your commands have been executed successfully. Take a look at grant and revoke syntax more carefully. lizard wrote: Hi all. My name is Mike. I have a Linux RedHat 7.3 with Mysql v

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 > don

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 so

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 re

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: 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

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 >> >>

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 t

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')

how and when mysql writes indexes and records

Hello, Does anybody know how and when mysql writes records and indexes to harddrive? The main purpose of this question is below. I am using mysql 4.0.1 on win98 for test purposes. During the tests my computer halted suddenly because of a hardware problem. After restarting my computer i have s

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/ - Be