NULL or NOT NULL in relational design

Hi, I am often running into this type of design, but would it be a good design. Normally you design tables related to each other and having e.g. parameter tables like a country-table holding country names with their country-id's; and you will find these country-ids back in other tables,

Re: doc for beginner admin

How about a start in the dev.mysql.com and browse for documentation. Start with the differences of all kinds of installations ;-) and using the [.]my.cnf file[s]. Cheers, Danny Bayrouni wrote: Hello, I would like to understand the mysql administration, is there any good doc for beginners.

Re: Table Lock issue on insert

Hi john, When did you start getting this error message? There aren't any trouble with MyIsam tables? Danny Brittingham, John wrote: They are InnoDB and max_write_lock_count=4294967295. The same thing happens when I create a copy of the table. -Original Message- From: Danny Stolle

Re: Table Lock issue on insert

Message- From: Danny Stolle [mailto:[EMAIL PROTECTED] Sent: Saturday, December 31, 2005 2:59 AM To: Brittingham, John; mysql@lists.mysql.com Subject: Re: Table Lock issue on insert Hi John, What kind of engine are you using on your table? MyIsam or InnoDB or are you using merged tables? If you

Re: Table Lock issue on insert

Hi John, What kind of engine are you using on your table? MyIsam or InnoDB or are you using merged tables? If you query your system variables what is your max_write_lock_count? If you create a copy of the table: mysqlcreate table cp1 like USERS_PER_HOUR; and you try the insert again; is the

Re: How to insert CURDATE() as default

Marc, In MySql (I am using 4.1.9 and 4.1.15; so i am not sure about 5) it is not possible to use functions as default values; you could create: create table tester (f_date date default curdate()); But this doesn;t work. You have to struggle through your knoda how to present the current date.

Re: backslash and Update

Hi, What you perhaps could use is the REGEXP usage in your where clause. Try this: update name set first_name=replace(first_name, '\\', '') where first_name regexp ''; The fun thing is that when you put '\\' instead of the '' after the regexp function it doesn't work. But this sure

Re: STOPPING server from pid file

Hi, Did you check your error log file? Is there allready a pid file in the directory? You have to delete this one first. Hope this helps :-) Danny ali asghar torabi parizy wrote: hi to all i have mysql5.1 installed on fedoracore3 it was worked sucsessfully since yesterday. but when i

Re: Foreign Key with constant?

Hi jesse, You can only set the reference in your constraint: ... ADD FOREIGN KEY (id) references table(id) ... In this case you will get an inconsistent database. Dont reference the two tables Campers and Counselers with the ActivitySelections table, but use two tables in which you put the

Re: MySqld wll not start on Whitebox linux

Hi Charles, Did you create the MySql system tables by running the script mysql_install_db which is located in the scripts folder? This script will create the system tables for your mysql database. After creation you can run the mysqld_safe as root Login using mysql as user root , leave the

Re: MySQL hangs each relative poor time

Well Roberto, it could be anything... analyzing your my.cnf file and variables would be looking through spagetti (i like spagetti ... but not in this flavour). the time your database hangs, are the intervals random minutes/seconds/hours? or is there a constant interval like precise on 30

connect with myODBC to mysql through proxy

Hi all, I have a windows computer in my network which needs an odbc connection through proxy. the only thing is that i don't know how to do this on a windows machine. i have installed the myodbc driver and it works for connecting on a mysql server in my local network. but i have an isp

Re: Recover from plain text log

Hi, I was wondering if you have solved your problem. I am quite interested excually. Best regards, Danny Todd Ellison wrote: OK, I am ready to get flamed. I have done so much stuff wrong on this MySQL server that it finally came back to bite me. I've learned my lesson and hopefully

Re: insert into... select... duplicate key

Hi, I am hoping you meen this: You have to use the fields in your into -statement and select statement, not including the field having the auto-numbering so if e.g. field1 has autonumbering - insert into table1 (field2, field3) select (field2, field3) from table1; autonumbering will

Re: insert into... select... duplicate key

the column names into my INSERT... SELECT and someone later adds a column to the table, I would have to go back into my program and update the statement. I am looking for a way to do it dynamically in order to avoid maintenance of the statement in my program later. Rob Danny Stolle [mailto:[EMAIL

Re: insert into... select... duplicate key

the column names from a table in MySQL 4. Rob Danny Stolle [mailto:[EMAIL PROTECTED] wrote: Well I haven't realy found a select method in which you can isolate a field. Like a complementary method, in which you select like one field, but shows the fields except the field which you have used

mysql_hex_string() c-api

i use the values which are used in the insert-string and convert them into hex using this function? the example provided in the documentation is not realy helpfull though. hopefully i am clear, otherwise please let me know. Thank you. Danny Stolle Netherlands. -- MySQL General Mailing List

Re: mysql_hex_string() c-api

I thought it was something like that ... I just found it strange allready. I'll give it a try, thanx. Danny Paul DuBois wrote: At 19:43 +0200 8/16/05, Danny Stolle wrote: Hello all, can somebody explain to me the c-api mysql_hex_string(). when i debug my example in DDD i get the full sql

Re: Good Oracle Forum

Daniel Cummings wrote: This forum has been very helpful. There is always somebody that is willing to respond to queries. Does anybody know of a good Oracle forum? TIA Dan Dan, You could try http://www.lazydba.com/ Best regards, Danny Stolle Netherlands. -- MySQL

Re: Create an Innodb database ?

by setting the mysqld-option: --default-storage-engine=type similair to --default-table-type=type in your .my.cnf file. So now also my question: When to use innodb instead of myisam? What performace advantages does this engine have? Danny Stolle Netherlands -- MySQL General Mailing List

Re: mysql forgets user passwords

' (using password: YES) Yet, when I go in as root and re-grant permissions with the user password, access is restored. When I reboot, I get the error again. What could possibly be causing this? Thanks, Chris Fonnesbeck Sorry again ... forgot the mailing group ... Did you 'flush privileges'? Danny

Re: mysql forgets user passwords

Michael Stassen wrote: Danny Stolle wrote: Chris Fonnesbeck wrote: I have mysql 4.1.12 installed on OSX 10.4, and have run into the curious problem that mysql forgets my user password (but not my root password) when I restart the server. When I attempt to log in, I get: ERROR 1045 (28000

General-list comment

Is there a problem with the mysql-general list? I haven't had any messages? Danny Stolle Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Doubt on MySQL for Linux...

and tutorials to help you get through MySql If you are new to Linux, then perhaps reading some stuff about linux first. Good luck and enjoy :^) Best Regards, Danny Stolle Netherlands EmoeSoft (http://www.emoesoft.nl) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: mysqlshow question

going to investigate more closely. My mysql command hangs, too. But, I have not done complete research on all its variations and has not done complete investigation on remote security. Best, Mikhail Berman -Original Message- From: Danny Stolle [mailto:[EMAIL PROTECTED] Sent: Wednesday

Re: strange database grant to mysql database

, Danny Stolle Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqlshow question

- mysqladmin -u username -ppassword -h host flush-tables are you granted for a remote logon? does your mysql-client tools hang as well? the statement show a no-space between '--host=xxx--user=xxx' it should be '--host=xxx --user=xxx' or are you aware of that? Best Regards, Danny Stolle Netherlands

Re: help joining tables in a query

James M. Gonzalez wrote: -Original Message- From: Danny Stolle [mailto:[EMAIL PROTECTED] Sent: 15 June 2005 21:09 To: James M. Gonzalez Subject: Re: help joining tables in a query James M. Gonzalez wrote: Greetings, I'm facing a difficult query at the moment. I have tried many

Re: Newbie mysql.sock question

Paul Mitchell wrote: On Tue, 14 Jun 2005, Danny Stolle wrote: if i start my mysqld it creates a mysql.sock because of an option in my.cnf: socket=/tmp/mysql.sock when i `mysqladmin -u root shutdown` the database, the mysql.sock is removed. does your system errors when starting mysqld

Re: CREATE TABLE and specifying DEFAULT

after ID_streettype_spec_hosp. he is working with version 5.0 mysql server. this has got to be a bug, or there must be something else going on. Danny Stolle -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: discuss: user management: conclusion

Danny Stolle wrote: hi, i would like to discuss 'user management' in mysql. Working with Oracle you can assign users to roles giving them privileges provided by that role. MySql doesn't have Roles. I have read (Managing and Using MySql, O'Reilly) 3 options on managing users having multiple

discuss: user management

(or stupid) what are your experiences on user management in a MySql environment. Best regards, Danny Stolle Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: discuss: user management

other privileges? he will get a new or already created role userID, but would still be able to logon using the previous user id. why wouldn't you choose for the 3th option or 1st option? what disadvantages do you think would option 1 and 3 have? Best regards, Danny Stolle EmoeSoft, Netherlands

Re: discuss: user management

?' is an interesting question. i have no direct answer to this question. the only thing i would come up with is: when you have a lot of tables and you have to change a privilege on several tables. you have the choice for changing that for 40 users each or 5 roles each. Best Regards, Danny Stolle EmoeSoft

Re: discuss: user management

George, from a MySql point of view, how would you deal with security on a site? would you than create individual users? Best Regards, Danny Stolle EmoeSoft, Netherlands [EMAIL PROTECTED] wrote: Danny, My 2 cents (American dollars): From a security standpoint (if you are a financial

Re: discuss: user management

Peter, that is an interesting formulation which you gave. can you please comment that with an example? would you create roles for users who are assigned the same privileges and individual users who have multiple roles? Best Regards, Danny Stolle Netherlands Peter Brawley wrote: Danny /1

Re: Newbie mysql.sock question

` the database, the mysql.sock is removed. does your system errors when starting mysqld? Best Regards, Danny Stolle EmoeSoft, Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CREATE TABLE and specifying DEFAULT

Les Schaffer wrote: Gordon Bruce wrote: I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows i was running 5.0.4 on Windows: mysql \s -- mysql Ver 14.9 Distrib 5.0.4-beta, for Win32 (ia32) switching to 5.0.6 now. anyone wanna make a bet ;-) les schaffer

Re: CREATE TABLE and specifying DEFAULT

Les Schaffer wrote: Gordon Bruce wrote: I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows i was running 5.0.4 on Windows: mysql \s -- mysql Ver 14.9 Distrib 5.0.4-beta, for Win32 (ia32) switching to 5.0.6 now. anyone wanna make a bet ;-) les schaffer