MySQL Database Forum

Hi I want to specify a search criteria but not know is it possible or not. My table has following fields and data. Table name : tablename fields : category languageid Data Data 1 IS Yes 1 EN * 2 IS ...

I have a table "services_detail". id order_id URL keywords22 Description Keyword53 1 4468 --- ---- --- df 2 3571 U1 pqrs dfgdfg 3 9163 --- wxyz --- Then how to get column names based on following value 1)pqrs (I want - Keyword22(As query Answer)) - Query?

I have a table `city` that contains four cities (a,b,c,d) I am trying to concatenate the city with a string. It is important that the city must come first: CONCAT(`city`, ' text') should do the trick, but I am getting the following: a b c d text

please help because i got a problem on how to access my MySQL Database from Online using Navicat for MySQL.. because i got a problem connecting my Database from Online.. please help me guys to resolve this problem. thanks! here is the info provided by my domain.

We have some batch proceeses running.In which we have some driver queries one of the queries is listed below.I am working on the performance improvement of these queries .I have done proper indexing in which performance has been incresed.But we need to furtehr impriove the performance.Can you please suggest me how can i further modify the below...

Hello, I am getting the error "Warning: mysql_connect() : php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\wamp\www\jlearning\index.php on line 78" My connection script is $hostname = "localhost"; $dbuser = "root"; $dbpassword = "xxxxxxxx"; $base = "image"; $link =...

I am working in Talend Open Profiler software, and checking tables in Navicat Lite. A few days ago, one of the created MySQL servers gave the message error 2003 - Can't connect to MySQL server localhost (10061). Now all three of the created servers say the same thing. The last error message showed today when I opened a table and clicked...

I have an application which uses MySQL as its database. It runs in a hosted environment to which I have PHP access. I'd like to be able to run an Access database with linked tables so I can enhance the application with local tables and reports. I am not an experienced programmer - can anyone help me with how to set up a link from Access (I presume...

Hi, I am having trouble with getting rows from a MySQL table using the like statement. I have a table which contains information relating to 5 cities. eg. table_name City COLUMN_2 COLUMN_3 Bali ... ... Vegas ... ... my sql query is currently:

Hello. I'm programming a website in which we have sport clubs listed in a DB, structure is as follows: club (id_club, club_name, club_city) court (id_court, court_name, club_id_club (FK), court_type) court_has_sport (court_id_court, sport_id_sport) sport (id_sport, sport_name) So as you can imagine, a court may allow more than one...

Hi, I want to represent a timetable on a mysql database. I had the idea that i should have three tables: 1.a classdetails table- containing class capacity, classroom name e.t.c 2.a class_sessions table with: start_time and end_time of session, 3.a class_unit table with: the name of the course (MAT003. et.c) there would also be...

Here is sample pseudocode to capture the logic. Attached is the sql export. if ( lab_sessiontime.Start_time > NOW()) then lab is free for Start_time - NOW() minutes ________________________________________________________________ else if (lab_sessiontime.Start_time < NOW() ) then check if ( NOW() > lab_sessiotime.End_time if true...

Hello! A rather complicated sql query that I might be makign much more difficult that it should be: I have two tables: News: newsid, datetime, newstext Picture: pictureid, datetime, imgPath Ideally I want a query to return the following kind of table:

how to list the tables that we have created ?

I have Following Table Input OutPut ---------------------------------------------- 12.22 2.22

Hi everybody, I have a problem and now idea how can be solved. The MySQL timestamp is frozen. Each time I run a command that should return the current date and time, it doesn't. For instance, I log in my system (Solaris) and run root@mypc# date I receive the correct date and time. Then I log into the mysql console and run: mysql>...

I have to change one table value with the date.If the date is passed away then lets say it would contain inactive else active. And the problem is that I have to do it automatically in my project.Not on any action. can anyone help me???? Thanks in advance.

hi,All thanks in advance. i need a help. i am working with a sql server 2005 database. where a table contains data like INTNO, name, dateofpurchase , item now i want to search the value based on name and dateofpurchase fields. but not value is retrieving. i don't know what is happening. here is the code i am using. <code> select INTNO...

hello i have 3 tables : parent, children, childrenPictures Table parent parentId | name Table children childId | parentId | pictureId | age Table childrenPictures pictureId | imgUrl

hi i need to store the date in the format date('YmdGis') the problem is that locally it is working perfect but when i go live it stops storing the date in this format , although it does store the date('YmdHis') MYSQL Server version: 5.0.41-community-nt MySQL client version: 5.0.41 Server version: 5.0.91-community

Good evening, I am trying compare a value from one table to another, and have an new field populate. I am using a Case Statement in order to try to accomplish this task. The error is: Msg 156, Level 15, State 1, Line 9 Incorrect syntax near the keyword 'SELECT'. Msg 102, Level 15, State 1, Line 9 Incorrect syntax near ')'. Msg 156, Level...

I use mysql db with many tables. i also update a table with an xls sheet!! is it possible?? then give me a solution! Also i interact my db thorugh php.. give me a sample code for that... Thank u Mani.

I have a 600 record mysql db. It has a timestamp field, auto incr id field, several varchar fields and several smallint fields. The id field is set as primary key. The access03 has a form displaying most of the fields. It is the only table in the db. If I try to delete a record I get the msg "The doMenuItem was canceled" with no other...

Hi, guys! I've created a java servlet where I can upload video with limited size. The video uploaded is being saved in the mySQL database as BLOB. How can I retrieve that BLOB and display it as the video in my webpage? I'm new to this so I'll need all the help and guidelines you guys can give me. Thank you very much in advance. Below is my servlet...

Please give me the exact query i will used to undo my last statement in sql. thanks