MySQL Database Forum

Hi I need to write some queries for a collage assignment but I am really struggling.I am very new to any form of SQL. I have the following tables. Sorry about the formatting. +-----+-------------+------------------+---------+--------+------------+ | CNO | CNAME | STREET | TOWN | BROKER | DOJ |...

Hello! I'm trying to set up replication between two servers and even though I did everything according to the documentation, the slave keeps failing to connect to the master like this: | 050119 0:23:43 Slave SQL thread initialized, starting replication in | log 'zwart-bin.001' at position 79, relay log './blauw-relay-bin.001' |...

I'm trying to understand MySQL better. I can't seem to figure out why the second query takes 2 minutes and the first query takes 12 seconds. It should be noted that the table, KBM, has 250 million records. I'm using MySQL 5.0.2. I guess I'm trying to get a better understanding of what "using index" means in the "extra" column. Here's...

Hi, I Redim An array based on the value of (.RecordCount - 1) When I .AddNew & ..Update it increments the value of .RecordCount Which screws up the logic of the application (it assumes the max value of the subscript was the original value of (.RecordCount - 1). Question: It seems the other Db (Connx ODBC for Dataflex DB) worked differently...

I want to insert a carriage return into a text field. I am using insert into and /n for newline. The MYSQL database is accessed by a MS Access front end and the text field appears with a small square where the new line should be. It appears that the /n is interpreted in Access differently. Is there a way of putting a carriage return into the...

Hi, I have a field: Ship_To defined Varchar 6 Length. When I create the record (.AddNew) I don't put any value in the field. When I read the field: lblShipTo(intX).Caption = .Fields("Ship_To") I get an error "Invalid use of Null". What am I doing wrong?

I have a "userstuff" table like this: | uid | user_id | typedb | dbid | ----------------------------------- | 1 | 12 | boards | 3 | | 2 | 13 | boards | 3 | | 3 | 12 | trick | 1 | Then I have other tables with the same name as typedb. boards(uid, board)

I have written a service that is depending on mysqld. The service startup just fine, but I would like to have my service *always* shutdown first before mysqld does. That way I can add some log into my table before the service shutdown. As I search online, I haven't found any way to do so. Since the "service dependencies" setting of...

Hi there, I'm not sure if SQL is capable of this so I would like your ideas and comments. I have over a thousand text files with in the below format. ComputerName=computerHostName OSName=Microsoft Windows XP Professional

I've the following problem: Table1 serie | dir Table2 serie | user I am making a webpage in php to administrate the values in the db. What I want is that I select all series from table 1 with an checkbox and

Hi, I'd like to initialize a table. This is the code: With rstArtrprt If .State = 1 Then .Close .Open "Delete * From Artrprt", cnnOdbc, adOpenKeyset, adLockOptimistic End With

Hi all, I want to create an sql script and one of the table that will be created is a 'country' table. The question is how do I populate the country tables? Should there be individual INSERT statements for each country or is it possible to use a loop somehow? Thank you in advance.

Hi know anybody a successfuel working gui which working with mysql5.0.2. I'm getting allways a crash with query-browser and others. many thanks & regards, christian

I have date values in mm/dd/yy format in a text file. How can use the LOAD command or mysqlimport command and load those date values. Currently I just load the date values as text into MySQL tables and manipulate the text in applications. There must be a better way? can I use DATE_FORMAT or something like that? Thanks, Yasaswi

Or, at least, I find it complicated :-) Hopefully it is not that hard but here goes: I have two tables: Persons and Relations Persons contain personal data such as person_ID, name, adresse, etc. and a special-status-code (a person with this code set = 1 is a VIP)

I have these 2 queries. SELECT count(*) gifts FROM gift g WHERE g.this and g.that SELECT count(*) events FROM events e WHERE e.this and e.the other thing

Hi There, I done a little bit of sql a while back and now I need to start up again. I have got to grip with most of the commands again and managed to create tables etc. One thing I can't remember how to do or find on the web is how to read from a text file.

Greetings, Several months ago my friends were rolling on the floor laughing when I told them I was going to build a profitable Internet business. "Yeah fat chance" they all said since I had absolutely very little computer skills and zero marketing experience! (Hint, I still don't!) Their laughter quickly turned to amazement after I

I have query that I export into a file using the "outfile" syntax. I can use the following lines of code to create a delimited file but I want to know if I can create a fixed length file? Any ideas? delimited file: Select GivenName, Surname, Address, City, State, ZipCode into outfile 'xx.csv' fields terminated by ',' lines terminated by...

If we have a date/time field and are doing frequent queries WHERE {date/time field} BETWEEN TimeA AND TimeB Does it make sense, query speed wise, to create an index on the date/time field? The reason I ask is that TimeA and TimeB are significant down to seconds. My *assumption* is that with a large amount of data scatter very few records...

Helo, I'm using 4.1.8-standard on linux and get this: CREATE TABLE test (field1 CHAR(20) BINARY NOT NULL, field2 CHAR(20) NOT NULL) TYPE=MyISAM; INSERT INTO test VALUES('xxx','yyy') SELECT * FROM test WHERE field1=field2 ERROR 1267 (HY000): Illegal mix of collations (latin1_bin,IMPLICIT)

Hello all, I'm relatively new to mysql and I'm having some trouble creating a user that can access a database that I've created. Here's what I've done: 1. As root, created a database called "tool_competence". 2. As root, created a couple of tables in the tool_competence db. 3. As root, created a user "called tool_comp_user" and flushed

I work with MySQL/PHP/Apache many years. I am Greek so, in many pages, I use Greek language. the problem is this: I have 2 group of programs with different interaction: group 1: PHP, MySQL Command Center group 2: MySQL Query Browser, MySQL Administrator

Gestalt Corporation announces the release of the production version of Scribe. Scribe is a report generator that can: - produce reports from one or more relational databases, - e-mail the reports as PDF attachments or HTML-formatted content, - publish them over the Web in PDF or HTML format, - schedule them for periodic execution in the...

I have MySQL 4.1.3a and when I run this query, server crash with CPU using: 99%. WinXP SP1, 32 bit CPU I have no other problems with server ALTER TABLE `history`.`anniversaries` MODIFY COLUMN `event` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; before `event` was greek