MySQL Database Forum

hello, would the experts please help. this script works with no errors: ------------------------------- drop table if exists degree; create table degree (id int unsigned not null auto_increment, primary key (id)) type=MyISAM; drop table if exists t;

I hope this question is appropriate for this group. My server provides a MySQL database. Do I need a third-party interface to add tables and records to it, or is their another way? Thank you. Jim

I would like to know why am I getting an error when assigning the result of a query to a user variable? SET @newClientID = SELECT clientID FROM tblClients WHERE clientClave = @clientClave; The code above doesn't work on a Windows server running MySQL 4.0.12-nt. It does work on a workstation with Windows XP running MySQL 4.1.3b-beta-nt

I'm trying to dump a bugzilla installation to a file, then restore it to a different database name (so as to test my db backup system). I use mysqldump to dump it to a file: # mysqldump -u root -p<passwd> (misc. options) bugs > bugs.sql Then try to restore it to an empty DB, "foobar" with this command # mysql -u root -p<passwd> foobar <...

Hi Everyone, I´m asked to "speed up" a keyword search based on MySQL. The material i´m given to work with is a quite large MySQL table with 1.5 mio rows, defined something like: CREATE TABLE datarecords ( id BIGINT(20) NOT NULL auto_increment, , keywords TEXT NOT NULL,

Hi all I'm running version 4.0.16 on solaris 8 as the backend for a web site serving around 12 million pages impressions a month. The performance of the server is monitored using orcollator. I'm finding that the memory usage on the server remains pretty constant for weeks at a time at around 300 Meg but then every once in a while the...

Hello, we're using InnoDB. After defining a table with "ON UPDATE CASCADE" and _without_ "ON DELETE" constraint, we deleted an entry in the parent table. The referenced tuple in the child table was deleted as well. Can anyone tell us why and if this behaviour is sql standard? Thx in advance!

I have this working fine in Access and MSSQL. While trying to convert to MySQL the result is not what I'm looking for to get.. Two tables: T1 ---------------- ID1|cName | ---------------- 10 |Electronics|

Hi, I've converted the tables from an old Access application to MySql format. I then linked the tables into access using MyODBC and everything works great (on my computer). For now, I want to keep Access as a front end, and move the tables to the Internet. I feel like I'm lost in a maze or something with some really basic questions. What...

When I installed MYSQL 4.0.22 by RPM? I want to install PHP now, bud it gives some errors

I made a table this way: mysql>create table tblCourses (courseCode char(30) primary key, courseDescription char(50)); Now I realize that I forgot to enforce that both fields will not be null. So I tried this: mysql> alter table tblCourses (courseCode not null, courseDescription not null);

Hi there, I've been searching for about 6 hours to get a problem solved. I installed MySQL 4.1.7 on the Debian web-server. Normally this worked: insert into logbook...

After installing MySQL4.1, I created a test account and then I could login without providing a password. When using MySQL4.0, I had to provide a password for the same test account. Any clue? I need to inforce the usage of passwords. Thank you. /***************************************************/ mysql> GRANT ALL PRIVILEGES ON *.* TO...

Hi All, My team is looking for a MySQL DBA (we run on Linux) and data modeler--all in one--to join our team to help us build this: http://skribe.noumenaut.com:8080 We need your help! We've been working hard on a high-end journaling

Hi, I appologise if I'm not posting this to the correct group, but I'm having problems starting MySQL server. I need it in order to post a websurvey for a research project I'm doing for a college computer ethics class. Well here is the output several commands, from netstat -a I can see that MySQL is listening, but when I try to start the...

Can someone please give me a push into the right direction to find the query I need for MySQL? I've ben strugling with it all night with no success.. I have two tables: Table P (Persons) NR NAME 1 Bill 2 Eva 3 John

Hi My queries need to search for 1600 higher, and 1600 lower than a given integer. One integer is a 'northing' and another an 'easting' - map grid references. I would like the results returned to be ordered with the numbers 'closest' to the given northing and easting combing first. my query is

While converting SQL statements for a database change, I discovered a big performance hit in MYSQL with subqueries vices Sybase. I'm hoping that someone might be able to help me understand why? I have two tables USERS (2200 records) and JOB Decriptions (163 records). I wanted to retrieve all the job description not in the USER table. (No...

I have two tables, one is Student, which has studentid, personid, grade, fees as its columns. The other one is Person, which has personid, firstname, lastname, address as its columns. When given a studentid, I need to get the student' info, such as lastname from the db tables. I can do it with two queries as the following: 1. mysql> select...

On a freshly installed Fedora C3 (incl. webserver apache php mysql) i get the following problem when connecting to mysql through a browser (phpMyAdmin): : #2002 Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock On the website of MySQL this error is mentioned but I found no solution. In /var/log/messages the...

i have 2 tables forumMsg forumTopic id idTopic Text idUser Views id Topic TopOrder -------------------------------------- ---------------------- 1 1 Hello 1 4 1 General 2 2 1 More 2 1 2 Other ...

Is it possible to somehow alter a field in a mysql database by sending an email to the server? I have a script that sends out notification emails to an individual. He wants to receive them continuously until he decides he has seen enough of them. Then to stop receiving the emails he has to use his browser and go to the web page that is...

Hi, I use Windows XP, Apache2 and MySQL 4.1. I changed my default charset by adding in my php.ini: default-character-set=utf8 Some row inserts now went wrong, so I did remove it again. How can I remove a default charset from a table?

We have a complex statement created from a web application which does not work correctly. During analysis, we could reduce this statement to the following: SELECT * FROM table WHERE ((row1>=0 AND row1<=2 AND 1) OR 0) AND row2=1; "row2=1" is not being computed, we also get results with row2<>1; When we swap the values of our last "AND"...

We have a complex statement created from a web application which does not work correctly. During analysis, we could reduce this statement to the following: SELECT * FROM table WHERE ((row1>=0 AND row1<=2 AND 1) OR 0) AND row2=1; "row2=1" is not being computed, we also get results with row2<>1; When we swap the values of our last "AND"...