Which database are you using?

|
Swapnil 2022-06-23 13:31:49
Pavankalyan 2022-06-23 13:30:48
Now fetching data from select query is fast or from view

Direct fetching of record is always faster

svart 2022-06-23 13:46:21
Pavankalyan 2022-06-23 13:16:07
Upgarded Cent os 6 to cent os 7 : • After updating the Centos 6.9 to 7.7 reports are not working and MySQL queries are taking a long time to execute.

Check execution plan for all of slow queries

svart 2022-06-23 13:46:33
Pavankalyan 2022-06-23 13:31:20
Does view play any role in query speed

No

Preesha N 2022-06-23 15:30:30
mysql_en-22021.jpg
Hi anyone can hepl me for query
Chandru S 2022-08-01 17:39:40
Query plz
Swapnil 2022-08-01 18:07:39
Select LEFT(column, LEN(column)-5)
from table
Chandru S 2022-08-01 18:49:34
mysql_en-23366.jpg

Chandru S 2022-08-01 18:52:37
Query plz
Hari 2022-08-01 18:57:59
Select ID,FirstName,LastName from maintable_M0JKR Order by ID
Swapnil 2022-08-01 19:26:49
Select ID,FirstName,LastName from maintable_M0JKR
where FirstName = ‘Robert’
or LastName = ‘Smith’
Order by Age
Candoitnow001 2022-08-01 20:14:43
Hello Everyone..
In my table
Having three foreign key one primary key how to create a table

*Write a sql query for one primary key with multiple foreign keys*

I can say like this

Example :
table name( Booking)

Create table Booking
(
booking_id int(10) NOT NULL,
Hotel_no Varchar(10) not null,
Guest_no varchar (10) not null,
Date_from Date not null,
Date_to Date not null,
Room_no Date not null,
Booking_id int(10) primary key references booking(booking_id) ,

Hotel_no varchar(10) foreign key references hotel(hotel_no) ,

Guest_no varchar(10) foreign key
References Guest (guest_no) ,

room_id int(10) foreign key references room(room_no)
) ;

Is it right to created a Table

Candoitnow001 2022-08-01 20:15:20
Anyone respond my query and reply to perfect answer
Candoitnow001 2022-08-01 20:18:25
In this group anyone expert in mysql
If yes
Help me out of problem
I’m struck out here.
Swapnil 2022-08-01 20:31:39
while defining foreign key data type is not required
Candoitnow001 2022-08-01 20:33:13
It means can explain elaborate it
@swapnil
Candoitnow001 2022-08-01 20:36:02
mysql_en-23380.jpg
Is it ok
Vchoudhary12 2022-08-01 20:37:30
Line 51, remove things after key
Vchoudhary12 2022-08-01 20:38:18
Or else write primary key at end of line 45 and remove line 51 fully
Candoitnow001 2022-08-01 20:39:28
mysql_en-23383.jpg

Candoitnow001 2022-08-01 20:40:04
Asper your advice I removed primary key
Candoitnow001 2022-08-01 20:41:18
Hello V,
Where is to mention primary key
After the booking_id may I right
Vchoudhary12 2022-08-01 20:42:11
Line 45 just before comma
Candoitnow001 2022-08-01 20:43:31
mysql_en-23387.jpg

Swapnil 2022-08-01 20:43:47
which database are you using ?
Candoitnow001 2022-08-01 20:43:48
It shows line 51 error
Candoitnow001 2022-08-01 20:43:57
Mysql
Candoitnow001 2022-08-01 20:44:14
R u asking database
Candoitnow001 2022-08-01 20:44:43
I’m using database as “Grosvenor ”
Candoitnow001 2022-08-01 20:46:17
Hello V and swapnil
Candoitnow001 2022-08-01 20:46:35
Help me out…
Swapnil 2022-08-01 20:46:36
Primary and Foreign key example in mysql
CREATE TABLE Orders (
    OrderID int NOT NULL,
    OrderNumber int NOT NULL,
    PersonID int,
    PRIMARY KEY (OrderID),
    FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)
);
Candoitnow001 2022-08-01 20:47:35
Ok that’s ok
Here single Primary key
Multiple foreign key
Swapnil 2022-08-01 20:47:56
So add foreign key multiple times using same syntax
Candoitnow001 2022-08-01 20:48:48
Before I tried like this what you said
I tried all those
It shows error
Swapnil 2022-08-01 20:49:12
what error ?
|