MySQL Database Forum

I want to alter the datatype of a column in a table. The query i used: ALTER TABLE my_persons alter COLUMN City int but it is showing an error: Error Code : 1064 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 'int' at line 1 Execution Time :...

i try to create a system that if there are 50 records in my database, the 10 with the lowest id's get deleted. How can i do that? Edit: Title wrong, not delteting but deleting

I got this error message. phpBB : Critical Error Error creating new session DEBUG MODE SQL Error : 1016 Can't open file: 'phpbb_sessions.MYI'. (errno: 145)

Recently I downloaded the latest version of MySQL for 32-bit, installed it. No errors installing it. When I go to run it though, all it does is flash a DOS-like window for a fraction of a second and that's it. Okay, here is what I am doing and the operating system info... I am running XP Home Addition with SP3. In the windows explorer, i...

Hello, I am using python to run mysql commands, however I don't think that should be a problem. When I am trying to select vales from a mysql talbe, I am having some trouble with the where clause. The vales DATETIME are all integer values around 38947. When I use the actual value 38947 it selects all 26 rows perfectly. however if I use a...

Hello everybody, I'm trying to find a way to order by relevancy the result of my simple search engine... I've found on the web different solutions, but I'm not able to adapt them to my case. $querystr = "SELECT img,link,numclick,description,order FROM table1 WHERE 1=1 "; for ($x = 0; $x < count($keys); $x++) { $querystr .= "and...

So I have this table: ------------------ Time --- Result - - - - - - 11am - Yes 13pm - No 17pm - Yes -------------------

A normal MySQL UPDATE is written: UPDATE table SET user='Username', pass='Password' WHERE id='Userid' I have about 150+ columns of data that need updated. Hoping for some shorthand. Is there a way to send the update with out labeling all the column names? For example: UPDATE table SET 'Username', 'Password' WHERE id = 'Userid' i know...

Hi all, I'm a french guy, I have 18 years and I don't speak very well english, so excuse me in advance. My matter is : I have a database with some people register, I would create a sql request to group by 5 minutes interval the number of registration since 10 years.

Hi I am trying to run this code in order to fill the reasults in the column update test set activate = (select distinct count(sigmessages.messagetype) from sigmessages WHERE

Hi all, I m having trouble in importing a sql file. I m using MySql 5.1.36. Using WAMP Server Version 2 phpMyAdmin version 3.2.0.1 Following error was displayed by phpMyAdmin #1064 - 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 'U' at line 1

mysql_query("select * from member_details where name='".$name."' or wife_name='".$name."' and ( hus_dob='".$date."' or wife_dob='".$date."' or wedding_day='".$date."'")) or die(mysql_error()); is my query syntax right? if not please tell me the correct syntax.

Hi i am trying to design a social networking site for my project. i have to design the database for the social networking with user profile and friends contact list as like facebook and orkut. can anyone help me to implement the database design with fast and accuracy retrieval of data from the database using the Index and Hash table...

Hi, I installed "mysql-connector-net-5.2.3" and "mysql-gui-tools-5.0-r12-win32". The install seems ok. When I start the "Administrator" or "Query Browser", the login asks for connection/user/password values. I don't know what these should be because the installation procedure didn't ask me for an user/password to begin with. I have tried...

is their any other way to connect php to mysql database other than enabling the ;extension=php_mysql.dll

WHEN I AM TRYING TO RUN AQL COMMAND IM AM GETTING THE FOLLOWING ERROR # mysql ERROR 1045 (28000): Access denied for user 'root'@'loc

I have set my log in index.php page so that it can access data in d mysql. However the log in function does not function as how it should be. Let me explain. 1. I created one member with ID = boboy and password = boboy too. When ever I log in I should get into the back office of this system. Unfortunately now whenever I tried to log in,...

I'm getting a foreign key constraint error when I use MySQL running under Windows 7. When I run the same MySQL and Hybernate code on Mac it works just fine. Here are the details of the error: 09:48:40,765 ERROR JDBCExceptionReporter:101 - Cannot add or update a child row: a foreign key constraint fails (`ff`.`contingency`, CONSTRAINT...

I am using a query to search a ticket no with eigther tickettype is like "EMER" or "Short Notice", but iam getting multiple values. Its not searching with the ticket no. Please let me know what the issue is in my query. Below is the query SELECT T.Ticketsid, T.TicketType, T.TicketNo FROM Tickets T INNER JOIN TicketCustomers TC ON...

Hi All, Here is the scenario i want a solution for. i have two columns col1 and col2 which needs to access the result of same table whose col(say time col) is required for fetching the result. while i want the output of col1 when time col value is equal to some value say 30 and col2 to be when time col <=30. Please let me know if this can...

hi...... ple give me the correct answer

I have a table called news. The table is some like that: - id -- title -- article -- date - - - - - - - - - - - - - - - - - - - - What I want to do is SELECT the most recent entry (not sure if Date field is necessary for that) and also the one before it. So if I have this:

Please see the attached picture. When I try to create my MySQL table using the below commands I get the attached error, why? mysql> CREATE TABLE grocery_inventory ( -> id int not null primary key auto_increment, -> item_name varchar (50) not null, -> item_desc text, -> item_price float not null, -> curr_qty int not null -> );

Hello everyone, I'm trying to do a little search engine for my website. Like often, I've the problem to operate on multiple tables. This is the part of code that interests my problem. It works but I need to search in more tables than one: for ($x = 0; $x < count($keys); $x++) { $querystr = "SELECT img,link,numclick,description,ordine...

Mysql - How to use UPDATE with SELECT??? I have two tables: 1) products_category -cat_id -cat_name 2) related_category -rel_cat_id (exaclty same as products_category.cat_id==related_category.rel_cat_id) -rel_cat_name