Setting All Instances Of A Value To Zero?
I am writing a basic CMS for a project and i need to be able to set every instance of a value to zero in a mysql database.
eg. there are 20 entries, each with the value '1' in the 'default' column. I want to change all of their 'default' values to 0 in one query.
How can i do this?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Multiple Instances
I'm install mySQL 4.1 on Windows XP and i want running 2 instances of mysql. How to do that?
Instances Automatically
I have 2 mysql servers happily running on the same box. The default server being on 3306 and socket mysql.sock. With a second server running on 3307 with socket mysql1.sock. I can start and stop these fine from the command line. However I can not figure out how to get both to run autmotically on machine start up / restart etc. The default mysql server starts up fine due to the mysql.server script. I have looked into mysqld_multi, which again i can use fine from the command line as a tool to get both running. However I can not work out how to integrate this or any other technique into the actual startup process.
Max_Connections On Multiple Instances
We have 3 instances on the same server, prod, test and dev. Is it possible to increase the max_connection limit just for one instance, or would changing the limit effect all 3 ? ** For great Emap magazine subscription & gift offers visit http://www.emapmagazines.co.uk ** -------------------------------------------------------------------------------- The information in this email is intended only for the addressee(s) named above. Access to this email by anyone else is unauthorised. If you are not the intended recipient of this message any disclosure, copying, distribution or any action taken in reliance on it is prohibited and may be unlawful. Emap plc and or its subsidiaries do not warrant that any attachments are free from viruses or other defects and accept no liability for any losses resulting from infected email transmissions. Please note that any views expressed in this email may be those of the originator and do not necessarily reflect those of this organisation. --------------------------------------------------------------------------------
Multiple Mysql Instances
I like to install two mysql instances using 4.0.24 in directory /usr/bin/mysql-4.0.24 (port 3306) and using 4.1.11 in directory /usr/bin/mysql-4.1.11 (port 3307). Both are running well, but only one at time. Both have different data directories and different directories for the immodb files. I am using mysqld_multi and have change /etc.my.cnf using a group [mysqld2], but it doesn't work. How has a configuration to look like and what is the best way to start the second instance?
Anyway To Run 2 Instances Of MySQL On The Same Machine?
I was wondering if there is anyway I can run 2 instances of MySQL Server on the same machine, the reason is I have one machine and I want to be able to simulate my program which really talks between 2 systems accessing their own MySQL server datas but I dont have 2 machines with me all the time to do this, it would be great If I could somehow manage this.
Counting Instances In An Array
I have no experience of designing, databases or using script or code but I now find I have to work with an existing database. I have a field in a table called outstanding objectives. It contains data such as Y,12,Y,Y,1,3,Y (Its is an array writen as text to the field by Flash) another field in the same row indicates the number of items in this array, in this case the entry would say 7. Id like to know how to count the number of Y's in the array, then express this number as a percentage of the value in the second field e.g. 4/7 and then write the percentage value into a new field.
Multiple Instances Of Mysqld
I've used mysql Ver 12.21 Distrib 4.0.15a, for slackware-linux (i486) on a Slackware 9.1 and when I ran a "ps ax", I got only something like : Code:
Manage MySQL Instances
I am using the version 4.1.12a Windows XP In one customer I found the same version as mine and the ini file has [mysqld] port=3306 server-id = 1 basedir="C:/MySQL/" datadir="C:/MySQL/Data/" and the service is mysqld-nt the question I want to have the same service (mysqld-nt) But different directory of my data datadir="C:/MyData/Data/" How can I do it in the configuration file??
One Value, Unknown Number Of Instances
Say I want to have a DB that keeps track of how many pints (of prune juice) I drink (okay, bad example) Each pint will have a size and the amount of time it took to drink, but I don't know how many pints I will have in each instance. Would I have a table for Pint that had pint_size and drink_time, and then a table DrinkingSession that had num_of_pints? But then how would I log the time for each pint? Could I write a DrinkingSession table that had pint1, pint2 pint3, etc?
Multiple MySQL Instances
If I have a static database (it will not get inserted or updated) is it okay to point multiple MySQL instances to it? We run Linux and would accomplish this through symbolic links.
Multiple MySQL Instances
I think I know the answer to this question, but is it possible and safe to have multiple instances of MySQL pointing to the same data files/the same database? I'm guessing that because only one instance can lock the files at any time that this won't work, but some confirmation would be good. I checked the MySQL documentation, but didn't see anything.
Multiple Instances In Another Table
I have 2 tables, and want to compare a field in the first table to multiple in the other I'll try to write it not in pseudo code, to try and explain what I would like to do table1-structure field_need_this | field1 | field2 | ... table2-structure field3 | field4 | field5| ... SELECT field_need_this FROM table1 WHERE field1 NOT EQUAL TO (SELECT field4 FROM table2 WHERE value 'something')*this could for example be 4 values. If field1 isn't the same as any of them I would like the field_need_this
Do I Have Multiple Instances Of Mysql Installed?
I'm running ubuntu 6.06, with a web application called Joomla. Right now our databases appear empty.. while i originally panicked, our web application is running smoothly. I cant figure out why this app would work while it needs mysql. Is it possible this is connecting to another instance of mysql on my server and how would i tell?
Update All Instances Of A Field To Default Value
Is there a statement or way in MySQL to update a several fields in a database to the default value? Basically reseting the value with out deleting it. I can go through an manually do that by looking at the number and manually setting it to that but it would be easier to just say: Update table set field=default That didn't work but that's what I'm trying to do. While at it is there any easy way to do it with PHPMYADMIN which is what I manage my DB's with.
Mysql Starts Multiple Php-instances
i have a little problem with a server, running mysql and php. I don't know which php-version i am working with, but the following is the answer for 'mysql --version' mysql Ver 11.18 Distrib 3.23.52, for suse-linux (i686) I know, that this version is not the newest one, but thats not my business. My problem is that i need to execute a script, which starts mysql with this command: mysql -hlocalhost -uuser -ppass db < $update > $update_log whenever this command is running and the 800k $update file is working on the db (a lot of delete and insert statements) there are several php-instances created. So many that they are slowing-down the server, that he is unusable.
Select Multiple Instances Of A Related Field
Is it possible to write an SQL statement to export mutliple instances of a related field in a single record? For example, ContactsTable is related to ContactHistoryTable. I want to select the contact record and export 3 columns from the ContactHistory records containing the most recent ContactHistory.Type = Phone, most recent ContactHistory.Type = Appointemnt and ContactHistory.Type = Action
Using Linux Symlinks W/Multiple MySQL Instances
We run multiple instances of MySQL on Linux. Each instance has its own directory structure. Along with other databases, each customer has a 5GB non-updating database that is used only for reference. Currently we have multiple copies of this database, which takes up a lot of disk storage. Since this particular database does not get updated, is it okay to have a single copy of it in a commonly accessible location and give the separate instances of MySQL access to it through symbolic links?
Setting Up
Im wanting to set mysql/php on my mac. Im wondering if installing mamp is the same as installing each component seprerately. Can i get away with mamp or should i go through and set it up manually?
Setting Up An ISP
I am trying to figure out how to setup an ISP. I have broadband in my shop and was thinking, I could setup the house to call into my network and connect to the Internet through my DSL. I have servers with Mandrake 10.1 for web/mail/ftp. Was wondering if this could be done and what needs to be done for it to work?
Setting Up
I need to setup on which directories on my hosted servers. I am a member of a volunteer organization, but would like to have a wiki posting to help promote some of the events that have lower turnouts. Also to get comments and perhaps media from some of the more successful events. I'm very new to this and am still reading up on some reference materials, but would like to have something tangible to work off of. Our budget is limited as well so I opted for the low budget plan for now, so I am still uncertain of the bandwidth I need.
Setting It Up
I need help on setting mySQL 4.0 on my windows 2000 small business edition server. how exactly do i do it? its downloaded, and set-up, now how do i use it?
Setting Value
I have a table (cont_id) with an auto_increment primary key, and I had deleted entries with much higher numbers than others.Those entries are no longer there, but auto_increment sets cont_id based on the high-number entry I deleted.Is there a way to re-set auto_increment so it adds +1 to the highest-number value for cont_id among the existing entries?
Setting A New Value
I'm trying to design an internet forum these days ... In my database i have got a field called (ID) which represents the id of the topics and i have assigned it an (auto_increment) attribute... My problem is that when i delete all the topics from the forum and after that add a new topic to the database the (ID) of that new topic continues to increment from the last deleted topic, so how can i set the (ID) of the new topic to 1 in case all the previous topics were deleted?
Setting Up Tables
I'm having trouble figuring out the table setup and normalization I'll need to accomplish my goal. Basically on my website I want students to register and from there they can log in and fill out what college they go to and create a list of courses they are taking and add/delete assignments for each course, and add grades they receive for each course. I need help determining what tables I'll need and how I want to link them. Let's say a STUDENT adds 6 COURSES and then 10 assignments in each course along with 8 grades he has received in the past week (to calculate GPA). How would I go about setting this up?
Setting Up Problemo
IM a database virgin and am wanting to get in to server side scripting. Ive been trying to set up mysql on my machine by following this tut: http://www.sitepoint.com/article/php...1-installation Now ive got the mysql downloaded and installed n my machine and ive got to the point where ive opened the command prompt (im on windows xp) to installing mysql as a system device ( right towards the end of the first page in the tut). Now ive got mysql in program files si im typing exactly this: c:programfilesmysqlin>mysql-nt --install but it doesnt work. Says the system cannot find the path specified but to get to the bin folder i literally go c rive then programfiles then the mysql folder then theres the bin folder right there. Any ideas what i could be doing wrong. I dont have apache installed or anythig yet becuase the tut hasnt told me to. Is it all case sensitive, should there be a space between program and files? any ideas?
Setting Font
I downloaded and installed mysql-essential-4.1.22-win32 somedays ago. I found it doesn't support my mother tougue. How can I set it support korean language? should I install it again for setting font(character)? or can I modify the setting?
Setting Up A Database
I have just installed mySQL v.5 on my Windows VPS Remote Desktop. In the past I've use shared hosting and simply followed the directions of the web host when creating a database. I simply need a single database created, a single user created for the database and password. And to grant permissions to that user. Rather than read the manual, I was hoping someone could instruct me on accomplishing this, please.
Setting Up MySQL On Mac OS X
I'm a novice Unix user, and I can't get MySQL set up properly on my Mac. It seems to have installed OK, but when I try to run the mysql_install_ db script, I get errors. I can't set the root password either that the documentation tells me to. As background, I just want to use MySQL to work with databases and PHP and HTML to set up web pages for database input and output. I'm running MySQL on my own machine at home, and have no use for passwords or any other administrative functions. I'm just looking to use the program to set up and query databases. Can anyone point me to a way to avoid all the UNIX admin stuff and run the database? I can get in, but the mysql database doesn't appear when I hit SHOW DATABASES as the tutuorial says, and I can't access or create new databases. I think all this may have something to do with my user account on my machine, but I'm not savvy enough to know how to override permissions, be root, or any of that stuff. Any hints?
Setting Up Defaults
Is there a way to set-up defaults to the fields using some SQL statment instead of going into each field and entering default values.
Setting Up Database
im going to use mysql for my database and then i will you asp for programming. im using windows xp pro in a lan. can the computer in the lan access my database thru webpages hosted on my computer using IIS.
Setting Up A MySQL Db
how's it done? I have only ventured as far a local Access type db up until now, but I now need a db "out there" that can store info submitted from a form on one of my websites. I have recently been experimenting with phpBB as a piece of open-source (free) software that taps into MySQL on my webspace, and seems to take almost all the hard work out of setting up a complex forum. It there some software that will do a similar job for me with a db? And can such a db download its data to a local db, like Access?
Setting Replication Up !
I am trying to set server replication up but am struggling to get binary logging enabled on the master - DB - mysql 3.23 OS - Win2k I have added the log-bin entry on the master - but if I do a SHOW MASTER STATUS they are all shown as NULL -
Setting The ORDER BY
ok say a field name in a table is called "type" and there are 4 possible values for the "type" field (car, boat, motor, rv). I dont want to order it by ascending or descending i want all the rows labled car under the "type" field to apear first. and the same for rv, boat, and motor. How would i acieve this??
Setting Up A Username
I am both the user and the admin. I am using winXP, and I am the root. This is all happening on one laptop since I am using Apache as a server. I have to ONLY provide mysql with my password to get into my database. My Q is how can I assign an actual username to myself, so MySQL connects my password that is already in use with the new username which I don't know how to create?
Setting Up MySQL
I set up MySQL, obviously not right. When I attempt to use the command: mysql -u root -p I am then asked to type in my password. I do that and then ERROR 2013 (HY000): Lost connection to MySQL server during query. I run Win XP and Norton Internet Security.
Setting Up MySQL
I tried removing MySQL But when asked for my password it would let me type it & Im log in as admin. Please Help ASAP I need a MySQL Project done. here is the terminal line: [flash-AlPB-1GHz:/usr/local] chadelso% [flash-AlPB-1GHz:/usr/local] chadelso% cd /usr/local/mysql [flash-AlPB-1GHz:/usr/local/mysql] chadelso% cd /usr/local sudo rm mysql sudo rm -rf mysql-3.23.47-apple-darwin5.1-p [flash-AlPB-1GHz:/usr/local] chadelso% sudo rm mysql Password:
Setting Up On Windows XP
1) I can run MySQL in a command prompt and create databases when I am logged into it at root happily. But then my application which hasnt got root access cannot see the database. How do I set up MySQL such that myApp can access a database created by root? At present if I log in to MySQL using MySQL -u MyAPP I cannot access the database that I created when I logged in as MYSQL -u root MS Visual Studio 6 question. 2) I have copied all the .h files into my include directory, and the lib files to the library directory. I have fixed the slight bug in the header files that means the system cant define SOCKET (#define __LCC__) If I just include the headers and compile it all works well. As soonas I try to use some of the C API commands I get linker errors which implies that the library is not loaded. I have added the library and I still get errors. What am I doing wrong here (or more likely, any suggestions for other things I can try?)
Setting Max_allowed_packet
I am having a problem with adding a large String to a mySQL field.. The size of the String is ~ 4MB and the datatype of the field to which I am inserting the string is - longtext. When I try to insert the String I get errors - i.e. "com.mysql.jdbc.PacketTooBigException" I have tried to set the max_allowed_packet value, in the my.ini file. i.e. set-variable =max_allowed_packet=16M although, when I try again to repeat the process once I have set the max_allowed_packet.. I still get the same error Message. It seems that even when I set the max_allowd_packet to 16M, the actual allowed maximum value is 1M.
Setting Up Users
I have a website and db where people can login get setup and then enter information into the db, everybody has a unique client number, can I create a user for the db when they set themselves up as a user and restrict them from changing anything except data that is connected to their client number?
Setting Variables In My.cnf
how can I issue these client commands from inside the my.cnf file? tep_db_query('set collation_connection=euckr_korean_ci', $link); tep_db_query('set character_set_results=euckr', $link); tep_db_query('set character_set_connection=euckr', $link); tep_db_query('set character_set_client=euckr', $link);
Setting Value Of Row_count()
i have a stored procedure consisting of several delete statements and i want to be able to return the "Query OK, 0 rows affected" such that the total number of rows deleted are summed up rather than returning the number of affected rows of the last statement. the number of rows deleted can be obtained through the ROW_COUNT() and i can add it up. but how do i set the value of the "Query OK, XXX rows affected"?
Setting Password
I am using MySQL 4.1 on Win XP.I forgot my root password and I am trying to reset it. I am using the SQLyog GUI to manipulate my DB.I have a guest password stored in SQLyog and can access all of my databases.But I can't use SQLyog to change the password b/c it uses the new password alogorithm which is hashed to 32 characters opposed to 16 in the old alogorithm.I was wondering a way to reset my root password.I only have minimal privileges on this account such as SELECT. Just in case anyone missed it,I can't log into my MySQL command line client since I don't know my root password.I would normally use OLD_PASSWORD('password') from there.
Setting Password
i've created my database and now i want to access it through php so im using: mysql_connect('localhost:3306', "username", "password") or die(mysql_error()); but i haven't yet set a password and don't know how to, so when i run the file it comes up with the error: mysql_connect() [function.mysql-connect]: Access denied for user...... is this because i need to set a password and username,if so then how? or is it maybe another different problem?
Using And Setting Up My First Database
1. how do I being in setting up my mySQL database which will be storing files consisting of TXT, SWF and images. 2. I want to be able to call these items from the database using PHP links and MySQL/PHP integration. Any tutorials on the web available for that that anyone knows of? 3. Easability. Where can I go to learn how to optimize all my code?
Setting Up New Item
I use myphpadmin and I am a beginner with it. I have this text based game and for items it's weapon, armor and shield. I went to insert and did the fields and added a new item called "Herb" which heals your character 10 health. So now I go to the game to the admin control panel and its there but it can only be a weapon, armor or shield. I need to add a new class for "items" which is a healing item.
Setting Up A Relation
Is there any reason why two tables created with a relation in MySQL wouldn't adhere to what you would think is a property of the relation? Case in point: I have a 1:n 'relation' where I can insert values into the dependent table while making up an entry for the foreign key from the independent table (whether it exists or not). I shouldn't be able to do that, but MySQL doesn't complain.
Setting Value For All Records
How would i go about populating a new column based on an existing column pluse a bit of text. i.e i have a column fldID which contains numerics 1,2,3,4 etc and i want to poulate a column fldIMAGE with values 1.jpg, 2.jpg etc.
|
TRACKER
