MySQL Database Forum

I have the following SQL which gives me the row Im after SELECT * FROM staff, staffemails WHERE staff.users_username='$user' and staff.staff_id = staffemails.staff_id thing is I now want to perform an update on the result of this query. Ive tried UPDATE staffemails

Is it possible to create Dynamic SQL queries in MySQL, like in SQL Server? i.e., the EXECUTE command or sp_executesql stored procedure in SQL Server. TIA

Hi, I'm quite new to MySQL and quite impressed by its feature set. I've also been looking at Interbase and it has a feature that allows a multidimensional array to be stored in a single field. Does MySQL also have this feature? I was thinking about using MySQLs GIS data types but it only supports a two dimensional point, where as I need...

Hi I am new to Trigger. I write trigger to insert total no.of row of a table to another table in this way CREATE TRIGGER count_row AFTER INSERT ON main_table FOR EACH ROW BEGIN INSERT INTO row_count_table (after_insert) (SELECT COUNT(*) FROM main_table); I don't know what is the wrong in this statement while I tried to end this...

Please help with the following issue. I am trying to dump a table. My mysqldump command is: mysqldump.exe -u xx -P xx --add-drop-table --quick --extended-insert --result-file=xx "--where=cdrdate > CURDATE() - INTERVAL 1 MONTH" mydb calldetailrecords It consistenly crashes the database with the error (as seen in the error log):

Hi, I've done this before so I don't see what I could doing wrong here. I'm running mysql 5x on freebsd. I'm using the default data directory of "/var/db/mysql" In there I have several dozen mysql datasbases that are functioning perfectly. I am trying to add a database which will be stored on a different drive, therefore the entry in...

I am using a MySql database for chat application. Every 3 seconds the database is searched for various details. I would like to know How many individual can it handle at a time. Say there are 6 users each making a call in 3 second So every second 2 connections are made to database.

hey, i'm new to mySQL...this meaning that i have tried ~10000 times to install it and get it working over the past few weeks...and it always gives me the same error (scroll further down to see it) despite following the manual's windows installation exactly i have version 4.0.13 for windows and i used the installer once i was done, i...

Hello grp! i'm using INNODB tables which are using frequently . if i fire a SELECT query which fetch major part of table it usually take 10-20 seconds to complete. in mean time if any UPDATE qry comes for a perticular row which is part of SELECT qry i want to know that whether UPDATE will wait for completing SELECT qry or not, or it...

plz help me solving the problem. i am using a table named XYZ in MYSQL i have columns A B C D E now i want 2 concatenate the values of column A & B and store this value in column A, such that new values in column A is concatenation of values of A + values of B. plz sumone help me in writing query

Hi, I have just installed the MySQL ODBC driver 3.51 on an XP machine which is behind a proxy. When I configure my DSN, I can't access the MySQL server which is in the "outside" world. I get this error: Unknown MySQL Server Host 'mysqlserver.com'

What is the purpose of OFFSET in mysql ? mysql>select * from info oFFSET 3 ; 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 use near '3' at line 1

I am trying to get the id number of a row in my table using the $_GET function... but i cant figure out how to retreive it. This is what i have now but it is coming up with an error. $result = mysql_query("SELECT * FROM net WHERE `id`=".$_GET); what is the problem with that? please reply

My tired old eyes may be failing me, but the following insert statements look correct to me, but I can't seem to get a clean insert from a fairly large text file database into mysql. I was wondering if maybe I'm hitting a limit on character length per line on some insert statements that I'm trying. Here's the error messages: execute...

OS XP Pro SP2 MYSQL Ver: 5.0.0-alpha nt Whenever I view a table or run a query in the Control Center (0.9.4-beta) I get the following error: ERROR 1146: Table 'shipnet.1' doesn't exist table shipnet.1 indeed does not exist but I can't understand why it's looking for it. Any ideas?

James Cod took the wrong path to learn SQL and even after two years of his graduation; he is still searching for a job in the IT industry. You must be wondering what is the best way to learn SQL to become a database pro. Sometimes, learning technology is not enough, but you should know how to implement knowledge in the workplace. If you know how...

Hello, I have two tables "contact_tbl" and "address_tbl". I have a query that compares the email addresses between the two. If a match is found I need to update a specific field in "contact_tbl" with a value of 'yes'. My query is: SELECT * FROM contact_tbl INNER JOIN address_tbl ON contact_tbl.email = address_tbl.email;

I have a problem that can be summarized with a simple table having the following 3 columns: timestamp userid status The table is constantly being updated. I'd like to get the most recent row for each userid present in the table? What pray tell is the trick?

Hi, What is the real difference between LEFT JOIN and RIGHT JOIN? Are there situations where a query with RIGHT JOIN cannot be rewritten with LEFT JOIN and tables reversed? (and vice versa). In MySQL documentation there is stated explicitly: "RIGHT JOIN is implemented analogously to LEFT JOIN, with the roles of the tables reversed."

Why this not working ? Our SQL table. username email tommy tommy@example.com jane jane@example.com jack jack@example.com

Hi, I have a procedure like this CREATE PROCEDURE `get_employee_details`( employeeid int) BEGIN select * from employee_master where emp_id = employeeid ; END; Here i may get confused with the local variables and database objects. So it gives poor readability.

Hello, I'm trying to port the use of postgresql db to mysql. I'm using Java and having the following problem - I can't seem to write more than 1 query per execution. Easier to explain with an example that worked under postgresql and does not using mysql: aStatement.executeQuery("BEGIN; DELETE FROM table1; DELETE FROM table1; DELETE...

How do you write a query which will stop ans wait for user input? Stan

i've got mysql 5.0 and I have 50 million records in a text file on an external USB 2.0 hard drive. I can import the file into a mySQL database on my laptop - but I don't want the database on my laptop. I want that database to be physically located on that usb connected hard drive instead of my laptop. Can anyone tell me how to set up the...

I have an application that was developed in Clipper. 70 dbf files and aroud 100 ntx , I plan to move the data to Access and Mysql *.frm *.MYD and *.MYI, But I don't know how to convert the .dbf files and .ntx. files ? Thanks you help.....