- Strength to Increase Rep
- +5
- Strength to Decrease Rep
- -1
- Upvotes Received
- 3
- Posts with Upvotes
- 3
- Upvoting Members
- 3
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
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 … |
|
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 … |
|
Is there a setting in the MySQL Administrator to set the file upload size? |
|
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 … |
|
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? |
|
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 … |
|
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 … |
|
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 … |
|
how to obtain query execution time? i need for mysql query in java... does anyone know |
|
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 … |
|
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 … |
|
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 … |
|
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 |
|
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 … |
|
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 |
|
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 |
|
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 |
|
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 … |
|
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 … |
|
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.... |
|
|
|
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? |
|
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 … |
|
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 … |
|
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 |
|
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 … |
|
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 … |
|
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... |
|
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 … |