Db Info
I have just encountered the weirdest thing ever that I have no idea why it is happening. I had a site one 1 server switched it over without changing the db username and password and all the stuff worked on the new server even though the db info was wrong. Is there a way to fix this because I feel like thiscan be a major problem later on.
View Complete Forum Thread with Replies
Related Forum Messages:
Getting Info
I'm going to select all articles from ~10 databases (on the same server) all with equal table structure. Lets call the db's for db1, db2 etc. And the table for 'article', the condition is that the column 'location' in article is equal to start(eq. WHERE location = 'start').
View Replies !
Looking For Info
I'm doing a University paper on MySQL and haven't been able to find any information on the minimum and recommended hardware requirements needed to run MySQL.
View Replies !
Getting Processlist Info
I have a need to get a list of currently connected users in a query for use in a view. I know the syntax for show processlist, but as of yet I cannot find a way of joining that information in a view. I also can't find any accessible table that lists the currently logged in users. The reason that show processlist isn't sufficient for my needs is that I need to display this information in a vb.net application, which as is currently designed uses one view. I would like to modify the view to include a boolean value based on whether or not they show up in the processlist. I don't care what process they are using, nor do I care about the state of the connection.
View Replies !
MySQL Info?
for a long time I have been using Postgresql as my application target database, and while I'm really pleased with it I miss many proffesional features availables in other databases (say Oracle or DB2), specially those points concerning High Availability, Clustering, monitoring, ... Now that CA has realeased Ingres under opensource I thought it was time to change to such database since Ingres has all the proffesional features one can spect and is a very alive project. I studied time ago to change to MaxDB/SAPDB when it was opensourced and asked in a lot of forums through the internet but what people told me (SAPDB administrators mainly) was discoraging and MaxDB looked to be "dead". My doubt comes now. What about MySQL? Last time I cheked it (ver 3.x) it was far away for suiting my needs (no ACID, no triggers, no clustering, ...) but I have read in the news many things are changing in the upcomming ver 5.0. How much true is that? Can I hope MySQL v5 to be able to compete with Ingres, Oracle or DB2 in features?. - Is it well documented ? (I was asthonised with Ingres that has been opensourced with more than 20 pdfs manuals covering every small detail about administration, development, monitoring, clustering, ... even with documents explaining the C-source and architecture internals). - Any good reasons you can imagine to choose MySQL instead of Ingres to update Postgresql?
View Replies !
Displaying Info
I'm working on my picture section, i was wondering if there is a way to order how things are layed out using mysql. I want something like this PIC 1 PIC 2 PIC 3 PIC 4 PIC 5 PIC 6 Ect ect. Is there a way to do this and what would it be called?
View Replies !
Sales Tax Info
where I can get sales tax info that I can integrate with a MySQL DB to calculate what tax to charge for each shipping location in my ecommerce app?
View Replies !
Info From Mysql
Are there any way to get info from mysql of the fulltext query passed to it?(ex num_optional_words). ex: for the query: 'car apple +store', one would have: num_optional_words = 2 num_compulsory_words = 1
View Replies !
Compatibity Info
Where can I find information on the compatibility of MySQL 5.x? More specifically, is it backward compatible with MySQL 4.1?
View Replies !
Info From 2 Tables
I'm struggling with mysql, I have 2 tables, ones called pmsys and the other is called user. I was reading about aliases so I thought I'd try it, but when I put in the following information it says the ON statement is wrong. This must have really gone over my head because I don't see what is wrong. how to get this right? SELECT t1.id, t1.to_id, t1.from_id, t1.time_sent, t1.subject, t1.message, t1.opened, t1.time_opened, t2.user FROM `pmsys` AS t1, user AS t2 LEFT JOIN user u ON t1.from_id = t1.id WHERE t1.to_id = '1' order by time_sent DESC; I need the info from the pmsys and the username of the person who sent the message by matching their id in the user table to the to_id in the pmsys table.
View Replies !
Info Into Table
I have made this site http://www.tinemuller.dk/folkebiblioteker/ and used mysql and have a lot of columns but what I need help to is "hjemmeside" which at the moment is empty for all the libraries (name). I have now found a excel-file where I have deleted all the columns that I shouldn't use and only left "name" and "hjemmeside" and name is identically with name in the database online. How do I get my database updated with the informations in "hjemmeside" from the excel-file and at the right place in the row of the right "name".
View Replies !
Can I Get Info About What Is In A Resultset?
I have a php class function that builds a query (on a single table) and invokes it to produce a resultset. Another function, would like to discover what is in that resultset so that it can display it nicely (ie appropriate name and widths for columns). I found the the SHOW command is able to give this sort of information for tables, but I could not find a way of getting the same infor for resultset's.
View Replies !
Getting Info From 3 Tables
I have 3 tables with 6 different date fields: - "problems" with creation_date - "funding_requests" with request_date and 3 different approval dates - "purchase_orders" with po_date I would like to select the list of all problem names where at least one of the 6 dates fall within a particular range. Should I: ....
View Replies !
Getting Info From More Than One Table
ok so Ive normalised my database, and all is good, ro repeating data anywhere. Now.....I'm a bit stuck I have an invoices table, a jobs table, and a customers table. invoices ===== invoiceref - integer primary key autoincrement etc jobref - this leads to the job details invtotal - the total for the invoice jobs ==== jobref - integer primary key etc customerid - the customers id number other - misc colums of job details not relevant to this question customers ========= customerid -primarykeyetc custname -customers name other - other fields , address tel etc ok so i need to display invoice details like this Invoice Number Customer Name Job Number Invoice Total Three of the columns are no problem, just select * from invoices But how do i write a query that will look up the job for the invoice, check the customer, and bring me the customers name too? A cheap shot solution would be to have the customerid field on the invoices table too, but then that would not be fully normalized as we already can get that information from the job the invoice is linked to.
View Replies !
Pulling Info In From A Db
I already have a bunch of tables in a database created by someone else, in which there is one table that I manually change the week number each week from 1 to 2 to 3 and so. This database is justed called week_index Now I just made another table called pictures. In this table, I've included a field labeled week, as well as a field indicating where I have placed the picture on my website. What I want to is just be able to change my week_index file from week 1 to week 2, and my sites pictures will automatically change as well.
View Replies !
Selecting Info From Db
I'm making a small game script, and when I get information from my database, how do I do set it up so that it displays first by the level the user got to, and then by the points he achieved?
View Replies !
Choose Info From Two Tables
Code: SELECT last_name, sales_agent, date_added FROM report_1, report_2 WHERE date_added <= '$start_date' AND date_added >= '$end_date' ORDER BY $sortby $sortorder";
View Replies !
Cannot Fetch User Info
I have a strange mysql problem. The ver. i'm using is 3.23. When I connect it with mysql-administrator, & try t fetch the informatin for any of the users, i get an error. I unistalled it using yumex & then reinstalled it & now i cant get the service mysqld to startup. Can anyone plz tell me how to completely remove mysql from the system & then reinstall the 4.1 version of it.I had a lot of trouble doing so & still couldnt find the sol.
View Replies !
Rename Table Info
i have a table that is built like so... id,game,score,genre,system,year,reviewer,console_id 125,'Aztec','','Puzzle','Neo Geo Pocket Color,1998,'',1 i want to make all entries of "Neo Geo Pocket Color" to be "NGPC"... what kind of command could i exacute to do this... i know how to rename a column... but not table info...
View Replies !
Double Table Info
I'm a newbie setting up a PHP-MySQL database and I'm just at the table creation stage. I'm worried because I have two tables that are showing the same info so I wonder if my database is truly normalized... Here are the tables I am worred about... so far: -Instructor- InstructorID iFirstname iLastname iEmail -Student- StudentID sFirstname sLastname sEmail -Instructor_useraccount- Instructor_useraccountID InstructorID iPassword iPriviledge iActivationDate iExpiryDate iLastaccess -Student_useraccount- Student_useraccountID studentID sPassword sPriviledge sActivationDate sExpiryDate sLastaccess I'm wondering if I can one "USERAccount table" and add a foreign key of USERID to both the Student table and the Instruction rather than the way I've done it.
View Replies !
Dynamically Column Info
I just recently started re-creating some of my spreadsheet databases to real database format using mySQL on Linux & OOo as a front-end (sort of... to create the forms for entering data). Everything looks great but I haven't read or been able to figure out how to create dynamic data fields that can keep running calculations of data from other columns in the same table (or better yet in other tables of the same db). For example, I have an expense report database set-up where I enter all of my weekly receipts & I want pre-tax, tax total & grand total columns that can keep running total of all receipts entered & or changed & keep that data in their respective columns. I hope that makes sense, I know I can do this with a select query command & get the totals I want but I can't sem to save them in the database.
View Replies !
Varchar Info Stored As %nn
One small thing that bugs me - when I store data into a varchar column, if the data has a comma or a space, the data is stored with an HTML-looking % sign. For example, a space is stored as %20. I am using the default encoding. I tried ASCII, and it replaced the spaces with plus signs (i.e. "Hello+there"). I have looked in the documentation, especially at the encoding sections, but have not found a way to have MySQL just store the data "as is", using commas as commas and not as escaped characters.
View Replies !
Change Table Info
does enyone know if this is possible in some way without first get the information UPDATE test SET `bbbb`=`aaaa`, `aaaa`=`bbbb` i don't want to select the information first in issue of server load!!
View Replies !
MS Excel Doesn't Return All Info
I have a simple MYSQL database that I use an Excel front end as an input form / query tool. It all works fine except for a simple query. The syntax is: "Select manufacturerID, manufacturer, mfr_address as Address, mfr_phone from tblManufacturer" When I run this in MYSQL, either at command line or using the Query Browser tool, it returns all data. When I run the same SQL within MS Excel, only the manufacturerID and manufacturer fields are returned although all 4 field names are returned. I don't know how to explain this, the table set up is as follows: manufacturerID - Integer, autoinc manufacturer - character(250) mfr_address - character(20) mfr_phone - text
View Replies !
Fetching And Posting Info
I am having some issues using the mysql_numrows function and I am getting this error Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource I have also tried mysql_fetch_row and some otehr functions but get this warning pertaining to it. Is this a server problem? Does my server not hold these resources. It is PHP enabled, and MYSQL.
View Replies !
Updating Mysql Info
When a logged in user clicks a button on my site i want it to automatically update certain data within the database.I have no problems retrieving the data and assigning variables to it. The data i want it to update is numeric, and whenever they click the button, i want the data within the cell to be increased by a certain amount every time they click it. At the moment it updates it the first time they click, but then stays on that value and never changes no matter how many times the button is clicked.
View Replies !
Adding Info To Table
I have a current list of names in a table and I am trying to add another list to it without duplicating the names. is there a way to do something like this?: "INSERT INTO master_list VALUES ($namefromnewlist) if $namefromnewlist IS NOT IN master_list"
View Replies !
Getting Info Out Of A Table, And Formatting It.
i have a table containing a bunch of rows. Format of the table is id name and in the table i have things like: 1 Photoshop 2 Flash 3 PHP 4 CSS 5 HTML etc, what i want to do, is get them out of the table, and format them to be like this: <li class="brdmenulinks">Photoshop</li> <li class="brdmenulinks">Flash</li> etc... in the order of there id.
View Replies !
Combining Info From 2 Tables...
I am trying to combine info from 2 tables, I have managed to output rep_Firstname & rep_Lastname, in the output but since I did this I have now lost all the other info from 'tblmembers'... Any ideas? PHP $results = mysql_query("SELECT tblrepresentatives.rep_Firstname,tblrepresentatives.rep_Lastname FROM tblmembers LEFT JOIN tblrepresentatives ON tblmembers.rep_NBR = tblrepresentatives.rep_NBR WHERE tblmembers.memberApproved = 'P'"); if (mysql_num_rows($results) < 1) { die('No members were approved last month'); } else { while ($qry = mysql_fetch_array($results)) { if (strtotime($qry['loginDateTime']) <= (time() + 86400*31)) { $login .= 'Name: '.$qry["FirstName"].' '.$qry["LastName"].' ('.date("d/m/Y", strtotime($qry["JoinDate"])).') '.$qry["Email"].' '.$qry["rep_Firstname"].' '.$qry["rep_Lastname"].' ('.$qry["State"].') ' } }
View Replies !
Performance Info In Linux Top Command
I cannot find MySQl performance info at linux "top" command. I already tested on slow MySQL query that took more than 5 minutes (create fulltext index), but during the 5 minutes, i cannot find any mysql process at top command. Below is the system information: Linux version: 2.6.9-1.667smp (Red Hat 3.4.2-6.fc3) MySQL version: 4.1.11 (source installation)
View Replies !
Pull Related Info Using Subqueries
I'm creating a tool to browse a database of movie listings. The browser pulls up 25 results at a time, and you can page through them using 'Next' and 'Prev' tools. Pretty basic stuff. Here are my tables: movies directors comments movies_directors movies_comments etc... (primary key is movies.id) But here's where I'm stuck: for each film, I need to pull the movie info in 'movies', plus any related data from other tables, like this: The Lord of the Rings | Peter Jackson | 3 comments Episode II | George Lucas | 0 comments Indiana Jones | Steven Spielberg | 15 comments I seem to run into problems when I try to join info from all of these related tables. If there's a match, great. But, if not (like a movie with no comments), the movie is excluded from the result set. I've tried all sorts of SQL queries to make this work, but nothing seems to do the trick. SO, HERE'S MY QUESTION, IS THERE ANY WAY TO DO THIS QUERY WITHOUT SUBQUERIES/MYSQL 4.0? Or would the best approach be to use PHP to do all the subquery lookups?
View Replies !
Download To Excel Certain Info From Mysql
I run an oscommerce site, and want to download all the invoice details into a csv excel file. the details that I need are in different tables, so i want to define exactly what I need example name, address, delivery name, order, vat ect I have looked at various scripts on the internet, but cant seem to get anything to run. Has anyone got a script, so I can just download the info that I need for my accounts.
View Replies !
Form Submission Info To Go Into A Database
I am a web designer, but have minimal training in database. I have several clients who have submission forms on their sites. I would not only like to have an email going to them with the submitted info, but be able to capture the info into a database at the same time. My webspaces are "mysql" ready. Can anyone give me step by step to create the above or tell me where I might go to obtain the information?
View Replies !
Insert New Column With Info From Two Other Columns
In my table I have fields for first name and last name. I would like to merge these two fields together to create one "full name" field, and add this to the table. Right now I can only SELECT CONCAT(First_name,' ', Last_name) as full_name from table1; It shows the query result and that works, but it doesn't insert this column into the database. I was trying to figure out how to use insert or update but no such luck.
View Replies !
Extracting Info From A Text Column
I have a table with one of the columns being ldap info. Example value would be: ou=FOO,ou=BAR,o=XYZ,dc=WORLD From this I would like to extract the first string, in this case FOO. My last atmysqlt was:...
View Replies !
Mass Replacing Info In Tables
fairly new to mysql and wondering is there any way to mass replace info in one of my fields. I have a town based member website and they enter their town which goes into the town field of my member table. Problem is the town has officially changed it's name and I am looking for a way to just mass replace everyone's town name in the field. For example all users are from Billington and I want to mass replace every members town field with New Billington the new town name. I understand that I can open up each members profile and type in the new town but I have about 1000 members and was looking for an easier way.
View Replies !
MYSQL Input Meta Tag Info
how can i get the meta tag information code 2 gets for you into the mysql database that you would normally manually put your website information into? Code:
View Replies !
Upload Mp3 File And Info Into Database
I decided to create a directory on my server to store the mp3 files instead and then to store the files path in the mysql so I would first create the table like this $sql = CREATE TABLE mp3_files ( id int NOT NULL AUTO_INCREMENT Primary Key, Song Name VARCHAR, Artist Artist VARCHAR , Release_Date date, Additional Notes VARCHAR, Path ?? ); where "Path" would it me VARCHAR type?? and how would I store the absolute path of the file using PHP Lets say I had a folder called MP3_Files on my server that would contain all my mp3 files and I uploaded an mp3 song called big poppa? How would I store this location so that when
View Replies !
Selecting Info Depending On Another Table
I have a web page where users enter their email address to be added into a table (for a future newsletter) however, if they become a member (which is another table) i don't need the email anymore. Now to make it more simple, I don't need to do an UPDATE query. What i'm going to do is create another page that'll show the list of emails from the newsletter table, except the duplicates from the members table. i guess something like this SELECT newsletter,member WHERE newsletter.email != member.email Does it make sense?
View Replies !
Setting Up A Page In Php Pulling Db Info
What would be the best way for me to pull this table information to a single page in php. Ive tried in many different ways and still cant get it to pull i can add the admin verify function afterwards. but mainly need help with setting up a single page to pull all users and there information to one page. Code:
View Replies !
Detecting If User Has Already Entered Info
I have a simple checking system I want to use. However I am stuck on saying if they have or have not entered information or not. Here's why. I want to use code that basically says... $result= mysql_query("SELECT * FROM table WHERE $row['userid']= $_SESSION['id']") or die(mysql_error()) if ($result == "false"){ Do this; } else if ($result == "true"){ Do this; } Basically I want to say if a user hasn't got any information in that table then do something else if they haven't do this. Will my way work?
View Replies !
Return Info On Last Record With One Query
Lets call the table: comics Lets call the fields I am looking for: ID filename I want to get the maximum ID from the table and the filename field corresponding to that maximum id. I can do it easy in two queries: select max(ID) as max_id from comics then in php send select filename from comics where ID=$id (where $id is the number returned from the first query) I would like to do ONE query like: Code: select max(ID) as max_id, and filename from comics where ID=max_id
View Replies !
Lookup FK Info On MyISAM And InnoDB Table
I'm wondering if there is a way to retrieve Foreign Key declaration information on both MyISAM and InnoDB tables. Of course, I understand that MyISAM doesn't support Foreign Keys, however, it does still parse FK declarations within a CREATE TABLE statement, and moreover, it even creates an index on the column that is the Foreign Key. So my question is for this sample CREATE TABLE declaration: CREATE TABLE table_name ( id INT NOT NULL AUTO_INCREMENT, other_id INT NOT NULL, PRIMARY KEY (id), FOREIGN KEY (other_id) REFERENCES other_table (id)) TYPE = InnoDB --- OR --- TYPE = MyISAM ; Can I get the Foreign Key information (meaing, the table and the column that a FK is keyed to) from MySQL? Doing a "DESC table_name" or "SHOW KEYS FROM table_name" indicates that the FK column is Indexed, but doesn't really give much more information other than that. The only way I seem to be able to get *some* sort of FK info is if i do a "SHOW CREATE TABLE table_name" (and even so, this only works on InnoDB tables. For MySQL tables, it will show my foreign key declaration as just a simple index).
View Replies !
|
TRACKER
