Hi there, I am just confused in building a SQL query. I tried to run it in pieces successfully but just not able to build it as a whole. This is the case: In table 'userseaches', user Rushi has been searched three times with different searchID's(primary key in 'searchtable') 10, 11, 12 . When searched with searchID 10 got 110 results,...
Hi I occasionally run into a problem with my application which results in a what I guess is an unfinished transaction that is not committed nor rolled back. I first notice the problem the next time my application tries to start a transaction to the database. My question is how to find out what queries have been executed within the tran...
I have a table name category with following cols cat_id | name | parent 1 | item 1 | 0 2 | item 2 | 1 3 | item 3 | 0 4 | item 4 | 1 5 | item 5 | 3 How i can display it in a menu like this Item 1 > Item 2 > Item 4 Item 3...
OK that probably sounded a bit confusing but what I have is a table that spits out courses locations and dates depending on what the user chooses. I than want the user to go through the fields and than on the 3rd submit button I have the course information displayed to them. I'm asking how in php i can take the echo from the first query...
Hello, I want to know if there is any difference in LEFT JOIN and LEFT OUTER JOIN in mySQL. And if there is no difference then why two different ways are there? Thanks in advance... ...
I'm trying to set up a development environment on my aging Macbook Pro that matches my Linux EC2 production environment. I'm on the home stretch now, need only to get the mod_auth_mysql plugin for apache working. After a few hours of googling and patching and scratching my head, I think I'm almost there, but I've hit something that nothi...
Let say I have a file with 20 lines, the first 3 lines are useless instruction for using the table, the 4th line is the header, the 5th to 17th lines are tab-delimited data, and the 18th to 20th lines are some useless remarks. And I want to import the table from the 4th line to the 17th line. How can I do it in MySQL? Something to work w...
Hi all, I would want your opinion about building the Entity Framework 4.0 from a database which is on a (remote) MySQL server. Is there anyone who has experienced this "combination". Perhaps some MYSQL server configuration... anything. Thanks! ...
I am having to restore a mysql database from .myd and .frm files. And Ii have no idea where to begin, I tried just copying them over while preserving file permisssions but to no avail what other steps do i need to take? I have a feeling its got something to do with the ib_logfile0, ib_logfile1 and ib_data files. But dont know what to do...
Hey! Does anybody have experiences about the mass compatibility (commercial hosts) of relations like FOREIGN KEY ( `car` ) REFERENCES `vehicles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE I noticed that other wide spread PHP / MySQL applications do not make use of them while they seem to be very useful. Any know negative side effec...
I have a table that contains a list of the starting letters in a post code e.g. LS for Leeds and SO for Southampton. I want to match these against a user entered full postcode e.g. LS19 1AB. I've looked into using LIKE and some regexp stuff in my query but I'm struggling to find a way to do this the right way round. Any ideas? ...
I have a site which contains around 3000 static and dynamic pages. I think 2900 of the pages are based on 3 different php pages which create all the 2900 pages based on database content, and it has about 100 static pages. How difficult would it be to integrate a CMS into the website so our Marketing department can make changes to the w...
I have a join using mysql in php and want to turn that into a pdo query how do i do that? Also how do I get the results of this query and display it. Code is below: $query = "SELECT * FROM pages LEFT JOIN templates ON pages.template_id = templates.template_id WHERE pages.page_Title = '".$getVars['page']."'"; I am new to PDO so thi...
How can I search for a user even if I don't know the exact spelling with regards to case, like SELECT * FROM USER WHERE U.NAME = 'STEVEN'; Meaning: if a user has the name "Steven" or "sTEVEN" how can I search all persons who have this name? I tried it, but it does not work. WHERE email LIKE '%GMAIL%' It did not not work when case...
My SQL query is ALTER TABLE `USERS` MODIFY `UUID` SERIAL UNSIGNED NOT NULL AUTO_INCREMENT but I keep on getting #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 'UNSIGNED NOT NULL AUTO_INCREMENT' at line 1 from MySQL (version 5.1). :-( An...
When I create (using JPA - java persistence api) a persistence unit and then persistence entities they auto create the corresponding tables and fields in the database. Can I also make it to auto create the database (if it doesn't exist)? My objectif is : I mean it creates inside the database the tables and fields, but not the databas...
I have a varchar field with the following data: Interface Gig1/0/1 Gig1/0/3 Gig1/0/5 Gig1/0/10 Gig1/1/11 I am trying to do a search (BETWEEN). Select * from test1 where Interface Between "Gig1/0/1" and "Gig1/0/5" Returns all the records except for Gig1/1/11 ...
i has two ubuntu server,and installed Mysql 4.0, ServerA and ServerB i want to synchronize ServerA's mysql table to ServerB (copy ServerATable to ServerBTable, keep ServerATable and ServerBTable equals) how to do it? (shell script,or java, or linux mysql tools) thanks :) ...
I have a method that loops through all the rows of a table where a certain condition is met, and then checks if one of the columns in the row appears in a text. The method is below: public function isRecipeType($ingredients, $type) { $rows = $this->fetchAll($this->select()->where("type = ?", $type)); foreach($rows as $row) ...
What could be causing this error when I try to insert a foreign character into the database? >>UnicodeEncodeError: 'latin-1' codec can't encode character u'\u201c' in position 0: ordinal not in range(256) And how do I resolve it? Thanks! ...