MySQL Database Forum

I have an Windows .exe that I need to pass flags to that would be data pulled from a mysql DB. This exe file with args will be automatically run via the task scheduler. That part I can do. :) Example: someapp.exe -pid -cid -sid pid, cid, and sid are arguments that are currently stored in a mysql DB. I expect a shell script would be the...

Hi, Can anybody tell me how I can get the backup ( just a file copy of the directory with .frm, .MYI and .MYD files) back into a newly created database. I am failry new to MySQL. Due to a crash of my Windows 2003 server I was in a hurry creating a very quick backup so I didn't tokk the time to find out what a correct backup mechanisme...

This is a copy from http://forums.mysql.com/read.php?10,73797,73797#msg-73797. Perhaps someone on this group will know the answer. Given the following table: CREATE TABLE foo(field VARCHAR(20) NOT NULL); The following query *can not* be executed: INSERT INTO foo VALUES(NULL);

Help! We are getting the following errors on a slave server: 060304 7:42:03 Error reading packet from server: Could not find first log (server_errno=65535) 060304 7:43:03 Slave: Failed reading log event, reconnecting to retry, log 'wcassp801.2514' position 76 060304 7:43:03 Slave: reconnected to master 'repl@10.20.10.10:3306',replication...

SELECT s.id, s.student_first_name, s.student_last_name, IF(s.student_ethnicity_interest_other IS NOT NULL AND s.student_ethnicity_interest_other != '', CONCAT(s.student_ethnicity_interest_other, ', ', e.ethnicity_name), GROUP_CONCAT(DISTINCT e.ethnicity_name ORDER BY upper(e.ethnicity_name)) ) AS ethnicity_name FROM student s, ethnicity...

SELECT id, student_first_name, student_last_name, major, minor , MATCH(major, minor) AGAINST ('"mechanical engineering"') AS score FROM students WHERE MATCH(major, minor) AGAINST ('"mechanical engineering"' IN BOOLEAN MODE) GROUP BY id, student_first_name, student_last_name, major, minor, score ORDER BY score DESC This query in MySQL...

mysql> select id, student_first_name, student_last_name, email, application_date, modification_date, unique_key from student where id in (7268, 862); +------+--------------------+-------------------+----------------------------+---------------------+---------------------+------------------+ | id | student_first_name | student_last_name |...

I m currently working on a Unix server with a fedora 3 as an os My current version of mysql is 3.23.58. I'd like to upgrade the version to 5.0.18. After downloading from MYSQL.COM the package on the site, I made : rpm -i MySQL-server-5.0.18-0.i386.rpm then i have errors that relate to many conflicts. I cannot figure out why -and- cannot...

Hi All, I'd like to have indexed search capability on column A, column B, or columns (A,B) for a given table. According to the MySQL manual, a multi-column index of (A,B) will provide "leftmost prefix" indexing, so that I can search on column A uniquely or columns (A,B) together, but not on column B uniquely. Therefore, I would need a...

Are there any tricks in updaitng a JOINed recordset? I joned to tables and when I try to change a field on the recordset and update it, I get this error: "Unknown column 'CCDE' in 'where clause'. CCDE is a field from one of the table and is not a field I am updating. I uses MyODBC with VB6 and MySQL 5.

Hi, I am using a MySQL database and have email address as the Primary Key. I also store a username of which there should not be duplicates. I am trying to check for this by doing the following: $query5 = "SELECT username FROM member WHERE username='$username';"; $result5 = mysql_query($query5) or die('Error during subscription process,...

Hi, I want to store particular algorithms written in Java into a database (preferably MySQL) and then be able to accept values such as algorithm type and parameters from a user (via JDBC) which will select the algorithm from the database, excecute it and return the result. I understand that MySQL does not support Java object types, so does...

select id from school_year where lower(school_year_name) = select lower(i.enrollment_status) from interns.interns i, interns.student s where i.unique_key = s.unique_key group by i.id; produces ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to...

update student s set school_year_id = (select distinct s.id from school_year s, interns i where lower(s.school_year_name) = lower(i.enrollment_year)and s.unique_key = i.unique_key group by s.id); ERROR 1242 (21000): Subquery returns more than 1 row I am trying to replace a column in interns.student.school_year_id to read an ID from the...

Hello, I am using mysql 5 and trying to import a database from version 4. But it keeps on giving me erros about invalid dates (e.g 2004-04-31) and Error 1265 (data truncated for Column X at row 1) I know it is some settings problem but don't know where to make changes. Any help would be much appreciated. Thanks. Usman

I have the following query I wrote in MySQL 5.0 Select eq_employees.empid, eq_sigreturns.returnid From eq_employees Left Join eq_sigreturns ON eq_employees.empid = eq_sigreturns.empid

Hi all! I seem to still have problems with MySQL. I wanted to create a new instance in order to run some tests of DB sizes. I want to create a new db, user etc... using teh command line client I removed the old instance, and created a new one. Could not login as root. Simply crashes. Service cannot start. Dont know why.

Hello group, I want to delete the content of a single column on a MySQL 3.23 database. Tried DELETE column_name FROM table_name; and other varieties with e.g. WHERE clause. No luck until now. The above statement gives the error msg: ERROR 1066: Not unique table/alias: column_name

Is this how it's done? INSERT INTO student ( (SELECT DISTINCT a.* FROM student_spring a, student_summer b WHERE a.unique_key != b.unique_key)\ UNION (SELECT DISTINCT b.* FROM student_summer b, student_spring a WHERE b.unique_key != a.unique_key)

Environment: Windows XP - german settings. MySQL: 5.0.18-nt Database charsets have been changed from 'latin1' (where 'LOAD DATA' worked fine) to utf-8 to resolve some charset issues with Perl/Tk. When loading a csv-file to the data base in the new utf-8 environment and an 'Umlaut' appears within a field the rest of the field including the...

Hello, I am very new to MySQL and just got done reading the replication chapter in my reference manual. I kinda understand but I still don't know if my scenario is going to work out. Here is my scenario. I have 2 servers, A and B. A is the primary server and master in mysql. B is the redundant server and the slave in mysql. A is...

I hope someone can help with this. If so then I'd really appreciate it. I have this sql statement: SELECT * FROM affiliates_referrals, applications WHERE affiliates_referrals.application_id = applications.application_id AND applications.status =2

hi.. I need to select records ordered by a string column. But when I order by with data containing an underscore, the result is not as expected. Following probably will make the problem clearer: When I try this on Oracle: SELECT LEAST('aa','ab','a_') FROM DUAL; The results is 'a_'

Can anyone tell me if mysql and sqldatasource work together? I'm assuming it does not since I can't get any hits with a search on the MySQL website.

When I read in dates, to ADO.Net datasets, the date gets converted from the yyyy-mm-dd format to a short date and time field. It's easy enough to reformat for output using the format function, but even if I just read a dataset and write it right back, I get null values in the date field. MySQL will write the record, but once I read it back...