[mysql] Forum Topics

Hi All, I've been using the query below to get data that starts with a ',' then any number of spaces in between, then a word that starts with 'w'... SELECT * FROM xtable WHERE xvalue REGEXP '(,([[:space:]])*w)' Using the query above, I was able to get correct results like …

I am using phpMyAdmin and as I delete a row, it stuffs up the auto increment once I insert a new row. Example: Delete - 21 Insert - 22 (should be 21) Thanks, Regards X

Hi, presently i am working on mirroring in between two servers of mysql.can you please provide me a code to do mirroring

Hi, i don't know how to do the following or even if it's possible. These are 3 tables from my database sport: [team]-|-----<-[team_match]->-----|-[match] [LIST] [*]Team: [LIST] [*]id (int) [*]name (text) [/LIST] [*]Team_match: [LIST] [*]match_id (bigint) [*]team_id (int) [*]score (text) {this is not an integer because it can contain "f" for …

Thanks in advance for anyone who can help me with this query. I want to select all from table one and the matching image from table two. Using the following inner join query works great: [code] $result=mysql_query("SELECT * FROM members inner join avatars on members.user_id=avatars.user_id where members.user_id ='{$user_id}'");[/code] but if …

Hi all... Let's say that I have a database with two tables: departments (dep_id, dep_name) & employees (emp_id, emp_name, dep_id). I need to select the departments that have the employees with ids 10 AND 20. How do I do that with SQL? Note: The following is NOT what I want: …

Hi EveryOne, I am working on 5.1.18 mysql community edition. It has a large number of records. I wanted to create an event to handle some particular tasks regularly. So I googled and found that i would have to set a global variable event_schedular=ON. So I have run following command: …

k... so, here's the thing... I'm creating a User's Interface to insert some data into a database, and there are some fields that have foreign keys to other tables, which i have listed in a [ICODE]<SELECT>[/ICODE] form, so the user would just select the vlue from a list instead of …

Hi all, I need to import a database (currently in excel) to Mysql. I searched a little and found out that CSV files can be imported. However, there is a problem that I am facing. The delimiter for fields in a CSV is a ',' obviously. But many of the …

hi, i ve hospitaldb created in MYSQl, i have connectivity problem like[CODE] String connectionURL = "jdbc:mysql://eall:3306/hospitaldb"; // declare a connection by using Connection interface Connection connection = null; // declare object of Statement interface that uses for executing sql statements. PreparedStatement pstatement = null; // Load JBBC driver "com.mysql.jdbc.Driver" Class.forName("com.mysql.jdbc.hospitaldb").newInstance();[/CODE] …

Hi, I just want to retrieve name of the employees who have two or more than two email_id in employee table. pls help me out..

Im a newbie, I have compiled apache and mysql in the same server;i need to host a site that has perl scripts and the database linking .How to integrate the mysql server to apache for smooth functioning of this site??

Hi, Thanks for checking this out. My goal is simple. Create a list of all the years that have had articles published in them (so basically every year). I have three unique dates in the date column, 2008-08-20, 2007-08-20, and 2006-08-20. The code below only returns this as the print_r …

Hello everyone :) Sorry for bothering you, but I have a problem with solving one query, in general query is much more compllicated, but I will try to simplilfy it Lets asume that we have table named info and it looks like this: id , name,price, from_date, to_date, 1 , …

Hi Code below generates this error "Table 'sis_audit.pay' doesn't exist". [code]UPDATE pay SET Ref='111', date='2008-11-11' WHERE id=29[/code] When i create same table in different database, no error at all. Why? Thanks

Is there any easy way of mirroring a mysql database, without having access to the config files?? Reason I ask is that I have 3 servers all running of the same mysql databases. 95% of the access to the DB is read data. So what I'm thinking is for both …

Uhmm,, im new round here, And i just wondered something,, I have recently made a private server for World of Warcraft.. And i need to make a website to advertise obviously. But the only thing is that i have no idea how to make a registration page so people can …

i am assigned to convert data from microsoft excel to mysql... pls tell me how. pls help. thanks ! :(

Hi, How do we save person's pictures in database?Do we just create column "pictutePath" and enter this value "../pictures/user1.jpg" for each person or is there any other way? Thanks

Hi This might be a basic question for all of u, but i need help from you guys. here is my query select (sum(datediff(dd,DateAdmitted, DateDischarged))/count(*)) AS Avrvg from table1 where DateDischarged is not null this gives me the result as 4 in the column Avrvg. but the actual result should …

Hello everyone. This is my first post to this site. I've used it before as a reference and now I'm here with a question of my own. I'm currently storing some data in a row like this: "apples, oranges, pears, bananas, peaches" Basically the row contains just a few terms …

I have a php webpage file that contain all the file and the code i want to edit that database content from all the file extrcted from the www folder of the wamp serve rthat will be use to connect to the database pls where will i get the database …

hey guys, I have made a database using mysql and php. I have also put in a search option. But what i want is that if the item which is being searched for is not in the databse it should return "Database Not Found". I am not able to execute …

hey guys, I have made a database using mysql and i am showing it on the browser using php. now the problem is that i only want those columns to display which have entries or some data in them for a particular row. Suppose that if there is one entry …

Hello, I am a graphic designer who does some web design on the side. The store I work at had a website that the boss wanted transferred to a different host. So I downloaded it off the server and uploaded it onto a new one. I knew that I was …

how may i create stored function in phpmyadmin simple one is create but one i try to use a variable in function it is mysql manual error. can anyone help me.

Hi, maybe my problem has a very simple solution, but I'm going crazy to find a way to do that. I have a single table that looks like this: Number | Value (both string and numeric) 123 | foobar 123 | 23846 123 | foobar 345 | 34523 345 | …

Hi what sql query will I use to checks the "users_theme" table and finds all the user_id's which exist in this table and not the "users" table. Once I have those id's that exist in the user_theme table that does not exisit in the users table I want to delete …

hello friends.... I am PHP programmer using mysql as my database... Now it is the time to make fast all my queries ,which im using in my programming... I heard about indexing... Tel me what is indexing,how to put indexing to my table... mainly what are the advantages and disadvantages...or …

Using MySQL..I have a stored procedure that contains an input parameter defined as a text value. A list of ids are passed in through that parameter... the input parameter is used in the where clause of a select within the stored procedure, however, currently I have this created as a …