Posts
 
Reputation
Joined
Last Seen
Ranked #2K
Strength to Increase Rep
+5
Strength to Decrease Rep
-1
100% Quality Score
Upvotes Received
3
Posts with Upvotes
3
Upvoting Members
3
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
3 Commented Posts
0 Endorsements
Ranked #1K
~39.2K People Reached
Favorite Forums
Favorite Tags
Member Avatar for evios

I'm currently working on my project. I use Vertrigo as my virtual server. However recently i always see this message when i use it.... MySQL database server does not work correctly. Check whether other applications use the important port (3306)... i'd no clue at all but then i reconfigure my …

Member Avatar for AnnDash
-1
16K
Member Avatar for cy163

I have two tables tb1 and tb2. I would like to sum up field values from two tables. How to do this using a SQL statement. tb1 Name Salary Bob 1000 Tom 2000 John 3000 Winson 4000 tb2 Name Bonus Bob 100 Tom 200 I would like to get the …

Member Avatar for rpv_sen
0
11K
Member Avatar for maydhyam

Is there a setting in the MySQL Administrator to set the file upload size?

Member Avatar for sergeik.rndwork
0
155
Member Avatar for agz86

i have 3 tables. leave_cri:typs of leave allowd 4 an emp leave_eli:all typ of leaves leave_detail:details of leave taken by an emp i need 2 write a query 2 select data based on these 3 tables. ie) i have 2 display these in a grid. leave details from_leave_details ; leave …

Member Avatar for krishna_gadgul
0
3K
Member Avatar for tuse

I need to check if a databse user exists and if not, create that user. However, I do not know the statement to check if a user already exits. How to check if a user already exists in MySQL?

Member Avatar for Offirmo
0
1K
Member Avatar for judithSampathwa

hey i have a mdf file which i made an application in visual studio 2008 and i want to migrate all the data and the tables in to the MySQL server, can someone help me in this thanxxxxx appreciate a lot

Member Avatar for judithSampathwa
0
88
Member Avatar for bubunchan

please help me to correct my answer: [B] STUDYCASE:[/B] The Following tables from part of a database held in a relational Database Management System (DBMS). Hotel ([U]HotelNo[/U], HotelName, City) Room ([U]RoomNo[/U], [U]HotelNo[/U], TypeHotel, Price) Booking ([U]HotelNo[/U], [U]GuestNo[/U], DateFrom, DateTo, RoomNo) Guess ([U]GuestNo[/U], GuestName, GuestAddress) Note: Underlined words is primary key …

Member Avatar for varmadba
0
110
Member Avatar for edwoodt

hi, i'm using phpmyadmin & would like to create an additional field in the following table. Field // Type Collation Attributes Null Default Extra Action user_id // int(10) first_name //varchar(20) last_name // varchar(40) email // varchar(80) pass // char(40) user_level //tinyint(1) active // char(32) registration_date// datetime the field would be …

Member Avatar for smantscheff
0
181
Member Avatar for joydeepu

I'm working on a mysql server 5.0.45 hosted on linux RHEL 5.0. 1. I've 2-tables as below: [INDENT]table1: acct_no VARCHAR(15) column1 varchar(10) table2: acct_no VARCHAR(12) column2 varchar(10)[/INDENT] In both the tables, there are many rows with identical A/c nos. 2. Of the below 2-queries, only the second one works. [INDENT][COLOR="maroon"]SELECT …

Member Avatar for varmadba
0
149
Member Avatar for krish_kooll

how to obtain query execution time? i need for mysql query in java... does anyone know

Member Avatar for linzyxer
0
837
Member Avatar for katiiiii

pleaseeeeeeee hepl meeeeeeee!!!!!!!!! i have 2 tables : time1 (noo integer,days varchar,times varchar,Tindex integer,primary key (noo,Tindex)) timetable1_1(COn integer,coursename varchar,dayss varchar,timess varchar, primary key(COn)) i have created a new table temptime1 and tried to fill it with the rows in time1 which their days and times are not available in timetable1_1 …

Member Avatar for rronyy
0
96
Member Avatar for jen140

Hello all. I have a small db, that has news. I want to update the field "content" to add the phraze "<br>Aproved by Admin" for every row in the database. A better explanation, i have table news, with 1 table that is defined : create table news (id int, creator …

Member Avatar for jen140
0
175
Member Avatar for rajuchacha007

Hello, I am importing a .csv file in mysql. I am facing problem when it comes to date. Let me elaborate. CaptureDate 20071101 20071101 20071101 20071101 20071101 This is data. But when i Load the file, it displays only last record correctly but not the rest 4. Please help. Thanks …

Member Avatar for rajuchacha007
0
399
Member Avatar for mohan7690

hi all i want to insert an image into mysql database using stored procedure, i need to pass the image from c# plz help me

Member Avatar for varmadba
0
89
Member Avatar for mr_vodka

Hi I was wondering what the syntax would be to have a left join from one table to a resulting query without the view. Currently I use a view and it works fine but I was wondering how to achieve this without creating the view. Here is the current view's …

Member Avatar for mr_vodka
0
126
Member Avatar for sarvajna

I am using mysql as backend in my windows project, some times one of table gets stucked and application also gets stocked after restartin mysql server it will be alright , any alternative solution for this problem... Thanks in advance

Member Avatar for varmadba
0
82
Member Avatar for srpa01red

hello hi i am using mac osx 10.5 i want to start mysql in it with --log-bin option so as to take incremental backup.so how can i start mysql with that option. i start mysql as mysql -u root -p. plz help me. where can i find my binlogs

Member Avatar for varmadba
0
85
Member Avatar for srpa01red

Currently connected to remote server but remote configuration is not yet possible this is msg shown when trying to connect remotely to a database what does it means

Member Avatar for varmadba
0
86
Member Avatar for HITMANOF44th

i am having an issuse not sure how to approach this i have setup a area that grabs user's / user data by a search now i dont get the same results when i do lower case and uppser case any ideas ? [code]$query = "SELECT * FROM `users` WHERE …

Member Avatar for varmadba
0
132
Member Avatar for srpa01red

how can i find size of my database what is the max table size in mysql is table size shown is in terms of kb or mb in mysql by default actually dis is the max_data length shown using "show table status" 281474976710655. means data size is shown in kb …

Member Avatar for varmadba
0
142
Member Avatar for web_master

i created a new user with all the privileges in mysql and it didn't work. no user works except "root with no password" which is why i created several user and tried it...still didn't work....if anyone know what is wrong....please lemme know.... thank you....

Member Avatar for web_master
0
235
Member Avatar for desiguru
Member Avatar for desiguru

I have a column "ID" in a table, and I need to move that to another table in the same database. How do I do this?

Member Avatar for nav33n
0
226
Member Avatar for NoGood

Hi all, I'm creating an appointments scheduling system. I have a bookings table and a time table among others in a MySQL database. Each entry in the bookings table has a slotId value. In the time table each slotId has a startTime and an endTime. This is what i want …

Member Avatar for NoGood
0
134
Member Avatar for fabzster

Hi Im not sure if i need a join here, i cant seem to grasp the concept of joins really batteling with this I allocate points to id numbers in the points table and i have a list of all id numbers in the consultants table the id numbers only …

Member Avatar for varmadba
0
109
Member Avatar for balakrishnan.kb

hi all how to run the multiple sql statements same time in mysql querybrowser? for example i am write two sql statements, i want run the second statements in mysql query browser, how to terminate the first statement thanks

Member Avatar for varmadba
0
93
Member Avatar for hbmarar

Hi, For 2 lakh records, this works well but when the total number of queries is more than 5 lakh it does not . Actually i have 64 lakh records to work with and this gets forever. [code=sql]UPDATE tmp_yk_contributor set score_last_update = '$date' , ykscore = (IFNULL((select avg(score)*0.8 from yk_entity_score …

Member Avatar for varmadba
0
135
Member Avatar for hbmarar

hi experts, Is it possible that i could get the 3 queries made into one single query.Any help could make me understand and correct myelf in better queries. Each query is taking long time and sometimes the first query crashes , with > show processlist showing status as 'copying to …

Member Avatar for varmadba
0
121
Member Avatar for praveen_dusari

hi all, i have a auto suggestion box which displays countries when we type [B]a[/B] it will display all countries starting with letter [B]a[/B] like alaska,australia etc...,but i want to display every name which has letter [B]a[/B] in names like [B]a[/B]ustr[B]a[/B]li[B]a[/B],indi[B]a[/B], etc...

Member Avatar for varmadba
0
154
Member Avatar for cy163

Hello ALL, I did the following query. the EXPLAIN result showed 'NULL' in the 'key' colume, meaning that NONE of indexes have been used. However, indexes have been created on Name fields for both tb1 and tb2. I wonder why MySQL does not use the indexes to speed up the …

Member Avatar for varmadba
0
98