MySQL Database Forum

Hello! I have been busting my head with a problem, that goes like this: 1. with a first ajax call to the server(apache 2.0 + php), I create a temporary table like this: create temporary table peter select * from some_table limit 0,0; That creates an empty temporary table with the same structure as some_table. I use mysql 4.023. I use php...

i have a table with objects in categories and their positions. there will be several rows with category 400, and they will have various positions, i want to delete only the row with the lowest position. i can select the row i want to delete, but don't know how to delete just this row. here's my select:

Hi, I am trying to set up my mySQL server on FreeBSD to log every query a user runs. I understand I must edit the my.cnf file. But one does not exist for my install. I installed mySQL from the FreeBSD packages and for some reason, it did not create a my.cnf file in /etc or anywhere. Where can I set it up to log every query a user runs?

Today I began preparations for upgrading MySQL. I downloaded the binary RPMs for Red Hat Enterprise 4 (we're running CentOS, a clone) for MySQL 5.0.13 from the MySQL AB web site. Running a test, I got this: rpm -hUv MySQL* --test warning: MySQL-client-standard-5.0.13-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed...

Hi where can I get a free copy of My SQL. I'm running Redhat 9.0 on my laptop. I looked at www.mysql.com but was a bit confused as to which package I need to download. Martin

Sorry guys. The spam stuff was not my intent. I do oppoligies and won't happen again. I have never been on newsgroups before and not sure how to work them. I hope you guys can forgive a bad choice. Murphey

Man I have found this site that has the cheapest ink for any printer. You can compare prices and then review the companies on service and quality. <http://www.imagraphix.com> Let me know what you think

Is MySQL able to expose data to anyone with an XMLHttp request object, similar to Microsoft's SQL Server (using IIS vitual directories, or more recently native xml web services). Many thanks, Duncan.

I am having error trying to run some mysql script (back from 2001). It gives me the error like : ERROR 1067 (42000) at line 48: Invalid default value for 'log_id' in the statement : CREATE TABLE Log ( log_id int(11) DEFAULT '0' NOT NULL auto_increment, source_id smallint(6) DEFAULT '0' NOT NULL,

Hi there, Just run a query that has a column that has a result of more then 1024 characters( quite a lot more actually) when I display full text in phpMyAdmin, it only seems to show up to 1024 characters. I was really hoping this was not the case. does anyone know how I can get round this. Sorry for probably not the best presented...

Dear mysql-ians, I am performing a query that takes ages before showing a result. I suppose it is very time consuming because of the JOIN I perform. My question therefore is if you have any suggestions to optimize my query? What I want to do is divide a value of a cell (NDVI) by the median of its neighbours based on geographical...

$sql = "SELECT IF((SHOW TABLES LIKE '$subselectTableName'), count(*), NULL) AS numRows FROM $subselectTableName"; I am trying to write a SQL statement that will tell me if a table exists or not, this is because PHP will throw Fatal Errors and halt all programming if the table does not exist that I attempt to query. How do you write an...

Hi everyone, I'm trying to build a Thesaurus. In my thesaurus i've created the following tables: terms, btnt (broader terms/narrower terms), rt (related terms) The structures of the tables are like this: -------------------------------- | table: terms |

Hi there, From a customer database table, I need to get a list of all the customers that have the same birthdays and their names. While I can get a count of this and the name of one of the customers of the group sharing the same birthday by using the following code: SELECT ALL count(dob) AS DOBcount, dob, firstname, lastname FROM...

Hi, Has anyone had this problem ? I am using MySQL ODBC 3.51 Driver, with MS Access 2003 and MySQL 4.1.11 standard log. I created my tables in MS Access, then exported them via ODBC to an externally hosted MySQL database (fasthosts) . I then import-linked

Hi All, I was hoping someone has experienced this before, I'm having trouble googling this. I'm working with a poorly writtend database that has some fields named as such: MTIC_PROD_VEND I do not have the option to rename this field but I do need to retreive data from it with SQL. I've tried a suggestion of ]] and that doesn't seem to...

mysql> update student set uuid = concat(UUID(), '_', 'asdfasdfasdfasdf') where uuid is null or uuid = '' limit 1; ERROR 1270 (HY000): Illegal mix of collations (utf8_general_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation 'concat' I have no idea what any of this means, what on earth did I do...

Hi I'm looking for the easy way to enter a lot of information to Mysql Db for me the best way is like in access you just paste the buffer (from excel) to the table you selected and it does it. Please help. Thanks, Alexander

What I am trying to do is to take the contents of a very large text file and place it into a LONGTEXT field in a database. I am looking for a solution using the C API to help me handle this. The code I use right now is very ineffecient. I basically use a VERY large character array that is like 600,000 characters long and store an UPDATE...

I have a table of daily information (tips, # of deliveries, etc.). Does anyone know of an easy way using SQL to extract all weekly sums of a field? Like: week 1: sum of tips for that week week 2: sum of tips for that week week 3: sum of tips for that week

Given the following table: CREATE table1 (a INTEGER PRIMARY KEY) TYPE=INNODB; It is possible to create a relation between table1 i table2 using the following syntax: CREATE table2 (a INTEGER PRIMARY KEY, b INTEGER, c INTEGER, FOREIGN KEY(b) REFERENCES table1(a)) TYPE=INNODB; How can I make that relation within the column definition? This...

I've imported a ms access database into a table in a mysql database. The access database contains a field that holds date/time values in 'general date' format. These all show up at 01/01/1970 in the mysql database. I believe the field in mysql is wanting UTC and shows numbers when looked at from the sql command line (i.e. March 13, 2006,...

Hi, Suppose many users will issue SELECT statement to the server, e.g. 1. UserA issued a SELECT statement 2. UserA issued FOUND_ROWS() and get the correct result The above is okay, but problems might occur when there is more than one users

We're in the middle of upgrading from MySQL 3.23 to MySQL4.1. I'm trying to import all of the info in the mysql database (ya know the db that keeps track of all the users and what they can and cannot do). I tried just a standard mysqldump from the old box. Copy the file over to the new box. And do a mysql -uroot -p < /tmp/mysqldb.sql. Lo...